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.
Solution 2: Use the view state to store page boundaries and select
the desired records with the TOP keyword in the SQL select statement.
Related Resources