Write to us
MS SQL Server
Free Tech Magazines
Asp.Net Web Hosting
Link to Us
Questions & Answers
Tips & Tricks
How to Convert a SqlDataReader To a DataTable or DataSet in Asp.Net?
10/11/2008 8:42:29 AM
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.
Post New Tips/Tricks
View all Tips/Tricks
Backup and Recovery Best Practices for Microsoft SQL Server 2005
To help you choose from among the available configuration options and backup and recovery procedures, HP has conducted extensive laboratory tests to determine best practices.
Washington Technology's coverage of government, business and technology issues helps contractors manage the business of delivering technology and services to the government.
100% Free Subscription until Stock lost.
View complete list.
. www.AspdotnetCodes.com. All rights reserved.