What can I turn my ASP.net SQLDataReader into?

Question

I would like to convert into a DataView, or a DataTable, but it doesn't convert directly.

Answer 1

Hi,

The enclosed link explains how to achieve this. Basically, you can convert an DataAdaptor into a DataSet (which is a group of DataTables) instead of a DataReader. If your query was simple, as it would have to be if you were only expecting a single DataTable to be generated, you can merely access the DataTable you seek with

DataSet ds = new DataSet; //Used as example for naming
DataTable dt = ds.tables[0]; //Used as example for naming

Hope this helps,

Leo