Hi friends,in this article I will explain about How to do Custom
paging for GridView using DataList in ASP.NET using C#/VB.NET to increase SQL
perfomance
When there are bulk
records to show in the GridView, developers often use paging to distribute the
complete records with multiple pages to show the records in the GridView. This
means that, when you change the page index, the GridView is bound
everytime from the database to show the next records.