public static bool Proc(string param1, int param2)
{
bool isSucc = true;
string ConnectionStrings = ConfigurationManager.ConnectionStrings["字符串"].ToString();
using (SqlConnection conn = new SqlConnection(ConnectionStrings))
{
try
{
conn.Open();
using (SqlCommand rscm = new SqlCommand("procName", conn))
{
rscm.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@param1", SqlDbType.VarChar);
param.Direction = ParameterDirection.Input;
param.Value = param1;
rscm.Parameters.Add(param);
param = new SqlParameter("@param2", SqlDbType.Int);
par
C#中调用存储过程并且具有返回值
最新推荐文章于 2021-02-02 17:02:41 发布