RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: .NET
Expertise: Intermediate
May 13, 2008

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)  

Srinath MS
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date