record move

[farshad]

If I use SqlDataReader to loop through the data to get all the fields of a table then how can I go to the next record and show the data.
So that if I click on the next button each time, the textboxes get populated with the next record of data, etc?

Thanks

 

[Ariez]

If you want to "navigate" , its good to have a local copy of the records you want to access that way.
If youre using the reader to get the data of more than one row, youll need to a mechanism to hold that data like arrays of rows for instance.
But if find it more useful to use a data adapter and build a local copy of whatever command I need.