The usual workaround for this purpose is loop through the rows in the Data Reader and assign each rows to Data Table, This is a time consuming process.

But Dot Net 2.0 and above provides a new DataTable.Load() as a quicker solution.

Here is the method
DataTable.Load(IDataReader);

Posted via email from fenildesai's posterous