Loading

Regarding Retrieving the Data from sqlserver.

Chaitanya Reddy Vonaja

Hi,

Iam having gridview.I want to display ten thousand records in gridview.Per page i want display only 10 records.iam retrieving all ten thousand records into dataset.It is taking lot of time.How can i retrieve only ten records per page.This has to happen like when i click on second page it has to display next ten records that is from 11-20?

Please help me guys.

Thank You.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chaitanya Reddy Vonaja16y ago
hi,
Thanks for reply.This not what iam looking for.i want to retrieve only ten records per page.The example you have provided will retrieve all the records from database and display ten records when you click on page.
Satyapriya Nayak16y ago
Hi Chaitanya,

Here is a simple program i did it now of your requirement.Run the attachments.

Thanks

If it helps you plz mark it as Accepted answer