执行一个存储过程的方法

 

 public DataSet CreateDataSet(string sqlString)
        {
            SqlConnection con = CreateConnection();
            SqlDataAdapter sdp = new SqlDataAdapter();
            sdp.SelectCommand = new SqlCommand();
            sdp.SelectCommand.Connection = con;
            sdp.SelectCommand.CommandType = CommandType.StoredProcedure;
            sdp.SelectCommand.CommandText = "Pr_RunSql";
            sdp.SelectCommand.Parameters.Add("@sql", sqlString);
            con.Open();
            DataSet ds = new DataSet();
            sdp.Fill(ds);
            con.Close();
            return ds;
        }