ConvertReaderToDataSet

public static DataSet ConvertReaderToDataSet(SqlDataReader reader)
{
try
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
for (int i = 0; i < reader.FieldCount; i++)
dt.Columns.Add(reader.GetName(i).ToString());
try
{
DataRow dr;
while (reader.Read())
{
dr = dt.NewRow();
for (int i = 0; i < reader.FieldCount; i++)
dr[reader.GetName(i)] = reader[i];
dt.Rows.Add(dr);
}
}
catch (Exception Exc)
{
throw new Exception(Exc.Message);
}
ds.Tables.Add(dt);
return ds;
}
catch(Exception Exc)
{
throw new Exception("ConvertReaderToDataSet: " + Exc.Message);
}
}