Hi All, After we moved from JSP and started developing a web application in ASP.NET, the DataAdapter is used for all sort of operations like insert/update/delete for a table. But, most of the time we need to query the data from db for a Table/View and the returned
data will be a Single Table of data. Though ADO.NET has a facility of keeping such a data in DataTable, y does ADO.NET have not provided a way to return a DataTable. Similar to DataAdapter returning a DataSet. Its like a mix up of DataReader and DataAdapter
with Read Only component returning DataTable. Or, please let me know whether there exists a way to convert a DataReader into a DataTable WITHOUT any looping of col. names and rows and inserting it into DataTable ? Or, can we write a Class and override DataReader
/ DataAdapter to return data as a DataTable ? Yours, Sankar.B
jinishans
Member
220 Points
44 Posts
Y ADO.NET does not return a simple ReadOnly Query data as a DataTable though we need most of the ...
Aug 01, 2003 04:18 AM|LINK