public static DataSet GetDataset(string storedProcName, SqlParameter[] p)
{
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(connection, storedProcName, p);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ap = new SqlDataAdapter(command);
ap.Fill(ds);
return ds;
}
}