There are several articles available about how to perform custom paging using a GridView or a Repeater, that's fine if you have to work with that controls, but in some cases you need to use it in your own custom controls or other scenarios
This article explains you a good performing solution for paging: it uses SQL Server 2005 new function ROW_Number, bad news of this way of performing queries is that you will have to use Dynamic SQL in your stored procs if you need to use dynamic sorting (ORDER BY limitations... ).
|