Hi All

I want to know that is it possible to use paging in data grid
when i use rate reader object to read data from database

when i do so it doesn't work
while with data adopter object it works...
what could be the prob??

I'm pretty sure that's due to the way the DataReader works. Basically, it reads records one at a time from the database, staying connected to the database, so there's no method to randomly access the records.

You could use one of the other Data objects, such as a DataSet, or you could read the records into a strongly typed custom object (prefered).

If there are a lot of records in the database, you'd be better off using cusom paging to only query the database for the records on the current page, as opposed to retreiving them all and then paging through them.

I know that data reader works in connected environment and data adopter reads data in disconnected environment....

R u saying that we cannot store data in dataset object using data reader object????

Originally Posted by Minaki

I'm pretty sure that's due to the way the DataReader works. Basically, it reads records one at a time from the database, staying connected to the database, so there's no method to randomly access the records.

You could use one of the other Data objects, such as a DataSet, or you could read the records into a strongly typed custom object (prefered).

If there are a lot of records in the database, you'd be better off using cusom paging to only query the database for the records on the current page, as opposed to retreiving them all and then paging through them.

No, what I'm saying is you can't page through records with an SqlDataReader because of the way it accesses records. You have to move the records into an object that can randomly access the records.