About Dataset and DataReader

[ramnujs]

is is possible to transfer all records read by DataReader object to a Dataset as a datatable?

 

[jmcilhinney]

Of course. You can put the data from a dataReader wherever you want. You'll have to create the DataTable and its schema yourself though. If you want information about the table schema in order to create a DataTable you can call GetSchemaTable on the DataReader.