Have Geek Brain

Subsonic paging using a stored procedure

I saw a video of paging using subsonic http://subsonicproject.com/querying/webcast-using-paging/

I am calling a stored procedure to retrieve data. Is it possible to use paging? Please give me some samples.

thanks

+1


a source to share


1 answer


You need to add paging to your stored procedure. The methods for achieving this depend on the database being used. I would grab the SQL generated by the search query, copy that SQL into a new sproc, add parameters for the page number and page size, then access the stored procedure proxy method for your newly created sproc.



+1


a source






More articles:


All Articles