Implement Custom Paging with SQL Server 2005

The default behavior of .NET data components involves retrieving the entire results of a query when loading data for display on a page. A better approach involves loading only data that will display on the page. In this article Tony Patton of TechRepublic.com shows you how to use ListView and GridView controls to implement custom paging with a SQL Server 2005 backend.