Regarding Retrieving the Data from sqlserver.

Question

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.

Chaitanya Reddy Vonaja · Answer

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 Nayak · Answer

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