title: Pagination MVC - SQL Server 2008
body: <p>Hi all i wonder if someone can give me some help. I've written some sql that will perform some server side pagination, this is working fine when i'm executing it manually. However i want to build a user interface and obviously allow the user to page through each page of data. I'm quite new to mvc and i'm struggling on how to come up with a solution to execute a stored procedure passing in the pageSize and pageNumber. I've worked out how to execute the stored procedure, but struggling on how to do the pagination part. Any pointers?</p>