How to read records one by one from sqldatareader

Hi Ramakrishna,

Load your collection results into a object(genericlist or the likes) that you would like to store the disconnected data in. From there databind the control(s) to the object, increasing or decreasing your object(list) index with next/previous.

Riaan

Don't do that. Since datareader works in a connected mode, as long as the user is browsing the records with the next and previous buttons, the connenction with the SQL server will be active. Later on the SQL server will reject the new connections once the connection limit exceeds.

Again, datareader will not allow you to read a previous record.It will allow only the next record.

Instead use a dataset and read each records on next and previous button.

Hi Ramakrishna,
datareader is useful only in the case where you need a limit amount data and more over it is active connection oriented, that is it will retain the connection unless and until we close it.. instead of that 1 we can use disconnected data binders such as DataAdapters,
dataadapter will retrieves the data completely and closes connections automatically...so we can use that one as our own object(Managed code).

even though if you want that one
then
Where cmd is an object of SqlCommand,

<pre lang="c#">
SqlDataReader dr=cmd.ExecuteReader();
dr.Read();//use methode to Advance the System.Data.SqlClient.SqlDataReader to the next record.
//and returns bool type(whether next record exist or not).