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.