Hi Friends,

Here In my application I placed one button and when I click on the button I need to read the data from database and we need to store that in dataset then by using datatablereader how can I  read the records one by one from dataset and the columns values Ineed to display on the textboxes...........Anybody can help on this.

Regards,

Venkatesh.

9886008288(Banglore).

3 MONTHS FREE & FREE SETUP on ASP.NET 3.5/2.0 Web Hosting! Windows 2008 & 2003 Servers Available, MS SQL 2008/2005, .NET 3.5 SP1, Entity Framework, LINQ, Silverlight 2.0, 30 Day Money Back Guarantee – Click Here!

Check out this post about the DataTableReader:

http://dotnetslackers.com/Community/blogs/kaushalparik/archive/2008/06/05/datatablereader-class-in-ado-net.aspx

why use datareader?

why not datarow..

datarow dr = new datarow();

dataset ds = new dataset();

dr = ds.tabels[0].rows[0];

balkjb.text = dr["test_id"].tostring();

or

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
 {

dr = ds.tabels[0].rows[ i];

balkjb.text += " ";

balkjb.text += dr["test_id"].tostring();

                       
}

janis:

why use datareader?

I believe that similar to the SQLDataReader the DataTableReader will be faster, then iterating through the DataTable.Rows collection.