C# 执行存储过程

 /// <summary>
        /// 执行存储过程
        /// </summary>
        public static void ExecProc(string procName, ref SqlParameter[] pam, ref int count, ref string ret)
        {
            string conn = ConfigurationManager.ConnectionStrings["HumanCenterEntities1"].ConnectionString.ToString();
            using (SqlConnection sqlconn = new SqlConnection(conn))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = sqlconn;
                cmd.CommandText = procName;
                cmd.CommandType = CommandType.StoredProcedure;
                // 添加参数  
                for (int i = 0; i < pam.Count(); i++)
                {
                    cmd.Parameters.Add(pam[i]);
                }
                sqlconn.Open();
                // 执行存储过程并返回影响的行数  
                try
                {
                    count = cmd.ExecuteNonQuery();
                }
                catch
                {
                    ret = "error";
                }
                //执行完后关闭
                sqlconn.Close();
            }
        }