Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap