执行存储过程通用方法

忙了两个月没写东西，今天就给大家分享点劳动成果。

来个执行存储过程通用方法 

        /// <summary>
        /// 执行存储过程，返回一个DataSet。
        /// </summary>
        /// <param name="procdure"></param>
        /// <param name="para"></param>
        /// <returns></returns>
        public DataSet ExeProcedure(string procdure, string[] para)
        {
            da = new SqlDataAdapter();
            comm = new SqlCommand(procdure, con.conn);
            comm.CommandType = CommandType.StoredProcedure;

            for (int i = 0; i < para.Length; i++)
            {
                string text = para[i].ToString();
                i++;
                string value = para[i].ToString();
                parameters = new SqlParameter(text, value);
                comm.Parameters.Add(parameters);
            }
            da.SelectCommand = comm;
            ds = new DataSet();
            try
            {
                da.Fill(ds);
            }
            catch (System.Exception ex)
            {
                CloseLink();
            }
           // CloseLink();
            return ds;
        }

数组里放存储过程中的变量和值，格式别错了如下：
            strPara[0] = "@BeginDate";
            strPara[1] = beginDT;
            strPara[2] = "@EndDate";
            strPara[3] = endDT;