Try creatinga DataTable
Following code may help
//Create A DataTable
DataTable dTable = new DataTable();
//Get the totla number of fields in the reader
int colCounter = reader.FieldCount;
int recordRead = 0 ;
for (int i = 0 ; i < colCounter ; i++)
{
dTable.Columns.Add(reader.GetName(i),reader.GetFieldType(i));
}
dTable.BeginLoadData();
object[] values = new object[colCounter];
while (reader.Read())
{
reader.GetValues(values);
dTable.LoadDataRow(values,true);
}
dTable.EndLoadData();
Regards
Dinesh Kalawat
