C#里调用带输出参数的存储过程
private int PageCount(SqlParameter[] param, string procName, SqlParameter outPutParam)
{
using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(procName, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(param);
cmd.Parameters.Add(outPutParam);
outPutParam.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return Convert.ToInt32(cmd.Parameters["@count"].Value);//获取存储过程的返回值
}
}