Probably using "custom paging" you mean "ranking": Ranking functions (T-SQL)
]. If yes, you need to change sql query to your needs... For example, if you want to "paging" by
statement as is shown below:
SELECT ROW_NUMBER() OVER (ORDER BY p.FirstName + ' ' + p.LastName) AS "Row Number", p.patientid, ...
Quote:Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
But why reinvent the wheel? (i'm not sure i used it correctly)
Have a look here:
Table Of Contents: GridView examples for ASP.NET
GridView Examples for ASP.NET 2.0: Paging and Sorting the GridView's Data