SqlDataReader

[Ghost]

Can I get record as DataRow object from SqlDataReader (if yes how)?

 

[Guest]

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