C#-调用存储过程

编写数据库存储过程

编写调用存储过程的通用数据访问方法

/// 

        /// 执行增、删、改 （存储过程)
        /// 
        ///
        ///
        /// 
        public static int  UpdateByProcedure(string procedureName,SqlParameter[] parameters)
        {
            SqlConnection conn = new SqlConnection(connString);
            SqlCommand cmd = new SqlCommand();
            try
            {
                conn.Open();
                cmd.Connection = conn;
                cmd.CommandType = CommandType.StoredProcedure;//声明存储过程
                cmd.CommandText = procedureName;//存储过程名
                cmd.Parameters.AddRange(parameters);//添加输入参数
                return cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
        }

编写调用存储过程方法

 SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@StudentName",objStudent.StudentName),
                new SqlParameter("@Age",objStudent.Age),
                new SqlParameter("@Gender",objStudent.Gender),
                new SqlParameter("@Birthday",objStudent.Birthday),
                new SqlParameter("@CardNo",objStudent.CardNo),
                new SqlParameter("@ClassId",objStudent.ClassId),
                new SqlParameter("@StudentIdNo",objStudent.StudentIdNo),
                new SqlParameter("@PhoneNumber",objStudent.PhoneNumber),
                new SqlParameter("@StudentAddress",objStudent.StudentAddress),
                new SqlParameter("@StuImage",objStudent.StuImage)
            };
            try
            {                                                       //调用存储过程
                return Convert.ToInt32(SQLHelper.UpdateByProcedure("usp_AddStudent", parameters));
            }
            catch (SqlException ex)
            {

                throw new Exception("数据库操作出现异常："+ex.Message);
            }
            catch (Exception ex)
            {
                throw ex;
            }

调式