110,535
社区成员
发帖
与我相关
我的任务
分享
public static int ExecProcedure(string ProcName, params SqlParameter[] MyComParameters)
{
string connStr = System.Configuration.ConfigurationSettings.AppSettings["lj"];
SqlConnection MyConn = new SqlConnection(connStr);
try
{
MyConn.Open();
SqlCommand MyCom = new SqlCommand(ProcName, MyConn);
MyCom.CommandType = CommandType.StoredProcedure;
//填充存储过程的参数
if (MyComParameters != null)
{
foreach (SqlParameter MyParm in MyComParameters) MyCom.Parameters.Add(MyParm);
}
int ReturnVal = MyCom.ExecuteNonQuery();
MyCom.Parameters.Clear();
return ReturnVal;
}
catch
{
throw;
}
finally
{
MyConn.Close(); MyConn.Dispose();
}
}