Re: How to create instance of dataview or datatable from datareader which contains da
You don't create a DataTable from a DataReader. A DataReader retrieves data from a data source. A DataTable stores data. If you want the data retrieved by a data reader to be stored in a data table then you have to create the data table yourself, apply the appropriate schema and then populate it. I've posted some code in the VB.NET CodeBank to populate a DataTable from a DataReader.
A DataView object doesn't exist in isolation. All DataViews are a view of the data in a DataTable, so it follows that you must have a DataTable first. Every DataTable is automatically associated with a DataView through its DefaultView property. If you need more than one view of the same table you can explicitly create more DataView objects.
Last edited by jmcilhinney; Jun 1st, 2006 at 08:56 AM.
Reply With Quote
