I've previously done paging both with the built in portion of asp.net as well as using row_number() in mssql 2005. The benefit of doing it in .net is that is incredibly easy to set up both sorting and ...