Hi ALL,

            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