HOW TO: Implement Custom Paging with the DataGrid Control using Database Paging

Solution

Solution 1: Invoke a stored procedure to create a temporary table with an identity column to enumerate the records, and then return only the desired range of records.

• Design a Custom Paging Solution: Turbocharge paging through large datasets in your web apps' list screens with ASP.NET's DataGrid control by Brett Olges & Doug Safford (.NET Magazine)
• Creating a Stored Procedure for Custom Paging with the ASP.NET DataGrid Control by Shannon Horn (DotNetJunkies)
• Tutorial: Paging Database Output from the Database by Eugene Welch (interactiveThink)

Solution 2: Use the view state to store page boundaries and select the desired records with the TOP keyword in the SQL select statement.

• Walkthrough: Creating Paged Data Access Using a Web Forms Page (MSDN)

Related Resources

• MSDN: DataGrid.AllowCustomPaging Property