可能手误.
public int myUpdatedRunProcedure(string procName,IDataParameter[] parameters,string appConnKey,out int rowsAffected)
{
connStr = System.Configuration.ConfigurationSettings.AppSettings[appConnKey];
SqlConnection cn = new SqlConnection(connStr);
cn.Open();
SqlCommand cmd = new SqlCommand(procName,cn);
cmd.CommandType = CommandType.StoredProcedure;
foreach(SqlParameter pm in parameters)
{
cmd.Parameters.Add(pm);
}
rowsAffected = command.ExecuteNonQuery();
int result = (int)command.Parameters["ReturnValue"].Value;
cn.Close();
cn.Disponse();
return result;
}
public int myUpdatedRunProcedure(string procName,IDataParameter[] parameters,string appConnKey,out int rowsAffected)
{
connStr = System.Configuration.ConfigurationSettings.AppSettings[appConnKey];
SqlConnection cn = new SqlConnection(connStr);
cn.Open();
SqlCommand cmd = new SqlCommand(procName,cn);
cmd.CommandType = CommandType.StoredProcedure;
foreach(SqlParameter pm in parameters)
{
cmd.Parameters.Add(pm);
}
rowsAffected = command.ExecuteNonQuery();
int result = (int)command.Parameters["ReturnValue"].Value;
cn.Close();
cn.Disponse();
return result;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货