I have been playing about with using a stored procedure that only returns a resultset based on page number and page size. Is fairly easy to do. I have been using it in an jQuery Ajax scenario rather than the onpagechange event in the asp.net codebehind. (Only works 2005 >) http://msdn.microsoft.com/en-us/library/ms186734.aspx http://www.codeproject.com/KB/database/PagingResults.aspx Worth a look. Hope someone finds it useful.
