Convert DataReader to DataTable in C#

SqlDataReader sdr = comm.ExecuteReader();

 
 

DataTable ret = new DataTable();

 
 

DataTable schema = sdr.GetSchemaTable();

for (int n = 0; n < schema.Rows.Count; n++) ret.Columns.Add(new DataColumn((String) schema.Rows[n][“ColumnName”], (Type) schema.Rows[n][“DataType”]));

 
 

while (sdr.Read())

{

DataRow dr = ret.NewRow();

for (int n = 0; n < sdr.FieldCount; n++) dr[n] = sdr.GetValue(n);

ret.Rows.Add(dr);

}

Advertisement