devxlogo

Quickly Copy Data Rows from DataReader to a DataTable

Quickly Copy Data Rows from DataReader to a DataTable

In many situations, it’s wiser to use DataReader instead of a DataSet. However, DataReader is limited due to its inability to transform data rows into a suitable holder, like DataTable.

The usual workaround for this limitation is to loop through the DataRows from the DataReader and assign them to the DataTable. This can be a pain.

Luckily, .NET 2.0 provides the new DataTable.Load method as a quicker solution. It allows you to pass any object that supports the IDataReader interface (for example, a DataReader). Here’s how:

DataTable.Load Method (IDataReader)  

devx-admin

Share the Post: