C# 无固定参数的存储过程(篇一)

这个比较简单,使用还算方便

SqlConnection conn = new SqlConnection("");

//方法

        public DataSet Exec(string procName, SqlParameter[] sqlParams)
        {
            try
            {
                DataSet ds = new DataSet(procName);
                SqlCommand cmd = new SqlCommand(procName,conn);
                cmd.CommandType = CommandType.StoredProcedure;
                for (int i = 0; i < sqlParams.Length; i++)
                {
                    cmd.Parameters.Add(sqlParams[i]);
                }
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds, "表");
                this.gridControl1.DataSource = ds.Tables["表"];
                return ds;
            }
            catch (Exception ex)
            {
               MessageBox.Show(ex.Message);
            }
            return null;
        }

//调用
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            SqlParameter[] para1 = new SqlParameter[3];
            para1[0] = new SqlParameter("参数1", "值1");
            para1[1] = new SqlParameter("参数2", "值2");
            para1[2] = new SqlParameter("outText", SqlDbType.VarChar, 255);//定义输出参数
            para1[2].Direction = ParameterDirection.Output;//声明输出
            Exec("存储过程名称", para1);
            MessageBox.Show(para1[2].Value.ToString());
        }