Subsonic Paging using stored procedure

Question

I have seen the video of paging using subsonic http://subsonicproject.com/querying/webcast-using-paging/

I am calling a stroed procedure to reterive the data. Is it possible for me to use the Paging? Please give me few samples.

Thanks

Answer 1

You'll need to add paging to your stored procedure. Methods to accomplish this vary based on which database you're using. I would capture the SQL generated by a paged query, copy that SQL into a new sproc, add params for page number and page size, then access the Stored procedure proxy method for your newly-created sproc.

Answer 2

@Adam - yes I have access to the stored procedure and can modify them.

@John-> Do you have any sample code for what you have mentioned in your message?

Thanks