DataReader Method of DataSet conversion

public static DataSet Convertdatareadertodataset (SqlDataReader Reader)
{
DataSet DataSet = new DataSet ();
Todo
{
Create New Data table

DataTable schematable = reader. GetSchemaTable ();
DataTable datatable = new DataTable ();

if (schematable!= null)
{
A query returning Records was executed

for (int i = 0; i < SchemaTable.Rows.Count; i++)
{
DataRow DataRow = schematable.rows[i];
Create A column name this is unique in the data table
String columnName = (string) datarow["ColumnName"]; + "//ADD the column definition to the" data table
DataColumn column = new DataColumn (ColumnName, (Type) datarow["DataType");
DATATABLE.COLUMNS.ADD (column);
}

DATASET.TABLES.ADD (dataTable);

Fill The data table we just created

while (reader. Read ())
{
DataRow DataRow = Datatable.newrow ();

for (int i = 0; i < reader. FieldCount; i++)
datarow[i] = reader. GetValue (i);

DATATABLE.ROWS.ADD (DataRow);
}
}
Else
{
No records were returned

DataColumn column = new DataColumn ("rowsaffected");
DATATABLE.COLUMNS.ADD (column);
DATASET.TABLES.ADD (dataTable);
DataRow DataRow = Datatable.newrow ();
Datarow[0] = reader. RecordsAffected;
DATATABLE.ROWS.ADD (DataRow);
}
}
while (reader. NextResult ());
return dataSet;
}