In my website I display list of products based on the user search text. I have implemented this using SQL server stored procedure. I would like to do SQL server side paging. I have implemented this in the stored procedure using rownumber. But please suggest how I can implement this in the front end. What kind of control I can use for displaying product results and to do paging.
I would like my pager control on the top and botto of the list and look like this:
Page 4 of 57 < Prev 1 2 3 4 5 Next >
please help. Is there any jquery that I can use. Please help thanks