I have 1Lakh records in a table called 'Employee'.Now i am going to display those records in a Gridview with the help of datatable or dataset.(this is the query:select empid,empname,empage from employee).I have enabled Paging and my page size is to display only 1000 in 1st page and another 1000 page in 2nd page....etc option.
I am using Sql server DB.
My problem is :
* All the my 1lakh records are fetched in the Datatable or Dataset once my page loads.So,performance speed gone in very very bad.
My requierment is :
* I am displaying only 1000 records in the 1st page index .So i would like to fetch only these 1000 records in my Datatable or dataset.
Once i went to next page,then only those 1000 records will be populated in the Datatable.
How can we acheive this?Please its very very urgent
NOTE:There is no Where Condition in my Sql Query.
Please give me some suggestions