C#中调用存储过程并且具有返回值

来源：互联网发布：贵州省大数据公需科目编辑：程序博客网时间：2024/06/05 02:39
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);                        param.Direction = ParameterDirection.Input;                        param.Value = param2;                        rscm.Parameters.Add(param);                        param = new SqlParameter("@Date", SqlDbType.VarChar);                        param.Direction = ParameterDirection.Input;                        DateTime curDate = DateTime.Now;                        param.Value = curDate.ToShortDateString() + " 00:00:00";                        rscm.Parameters.Add(param);                        param = new SqlParameter("@RetValue", SqlDbType.Int);                        param.Direction = ParameterDirection.ReturnValue;                        rscm.Parameters.Add(param);                        rscm.ExecuteNonQuery();                        int retValue = Convert.ToInt32(rscm.Parameters["@RetValue"].Value.ToString());                        if (retValue != 0)                        {                            isSucc = false;                        }                    }                }                catch                {                    isSucc = false;                }            }            return isSucc;        }
阅读全文
1 0