I use a stored procedure to run the paged query, It runs the query twice; once to count, once to get the paged result set. I then return the count as the return value from the stored procedure and the result set is returned to the caller.

I also use Xml to pass in the search parameters and attributes for the paging information, but that would be a topic for another day.

Barry