Custom GridView Paging with ObjectDataSource Control with ASP.Net 2.0

ASP.Net is packed with many data bound control to present the data in tabular form to the users. In GridView control, we can enable the inbuilt paging by setting AllowPaging and PageSize property. In this approach, it will fetch all the records from database to display the records in any page. This will affect the performance when the number of records is really huge. It will be good, if we fetch only those records which are required to display in that particular page. This article will help us to implement the custom paging with ObjectDataSource control and SqlServer 2005