Posted on: 6/11/2014 4:22:05 AM | Views : 447

Hi,
I have a query which returns the Date in descending, which I am binding to datatable and then to a gridview.
The records in the sql table are as below: below is the sample of records, not all records:
6/26/2014 6/13/2014 6/12/2014 6/12/2014 6/11/2014 6/11/2014 6/10/2014 6/10/2014 6/9/2014 6/7/2014 5/6/2014 4/30/2014 2/28/2014 In the gridview, i have set the page size to 10. The records are retrieved and works fine. In the pagination, I am again calling the same BindGrid function which is called in the page load. Everytime all the records are filled in datatable and then according to page, the records are shown.
I am using C# 4.0 and asp.net.
Is there any other method which can be used to reduce the overload?
Thanks
 

Go to the complete details ...