How to Convert a SqlDataReader To a DataTable or DataSet in Asp.Net?

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:

Programmers Heaven C# School Book - Free 338 Page eBook

The Programmers Heaven C# School book covers the .NET framework and the C# language.

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.