AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 How to Convert a SqlDataReader To a DataTable or DataSet in Asp.Net?
Posted by Moderator1 on  10/11/2008 8:42:29 AM 13518 Views
To convert a SqlDataReader to DataTable or DataSet, use DataTable's Load method. Just look at the sample block of statements below.

string sql = "Select * from MyTable";
SqlCommand cmd = new SqlCommand(sql, MyConnection);
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();

//Load the SqlDataReader object to the DataTable object as follows.
dt.Load(dr);

Response.Write(dt.Rows.Count.ToString());

Thats it.

Post New Tips/Tricks View all Tips/Tricks

Featured Resources:
Everything You Know About CSS Is Wrong! - Free 37 Page Preview!
For web designers and developers who want to ensure they're using the very latest, best-practice CSS techniques.
Easing the Migration to Microsoft SQL Server 2005
There are many business and technological reasons for making the move to SQL Server 2005 and SQL Server 2005 Enterprise Edition. In tandem with 64-bit computing platforms, SQL Server 2005 can boost performance by 30% in certain instances, deliver a better database management structure and bolster infrastructure security.
100% Free Subscription until Stock lost.View complete list.
Sponsored by