Last post Jan 09, 2007 03:14 PM by mattbug
Dec 01, 2006 02:27 PM|mattbug|LINK
I've successfully implemented custom paging with a GridView following the steps in Scott Mitchell's tutorial and using the stored procedure from this excellent article,
A More Efficient Method for Paging Through Large Result Sets. (I had to add a line to the sproc that adds 1 to the startRowIndex). The GridView paging speed for my 800,000+ record table is
Now if only I could get sorting to work...
I've tried to take Scott's tutorial on
Sorting Custom Paged Data, which is aimed at SQL Server 2005, and modifying it to work with the stored procedure mention above, but so far I have had no luck. Please, help me figure out custom sorting with SQL Server 2000. Thanks!
Jan 08, 2007 04:32 PM|mattbug|LINK
Jan 09, 2007 03:14 PM|mattbug|LINK