I have a document library. I am displaying this library using my own CSS in a custom web part. My question is how do I apply pagination?
Normally in ASP.Net we simply use
SQL query such as SELECT *
FROM sys.databases
ORDER BY name
OFFSET 5 ROWS
FETCH NEXT 5 ROWS ONLY
to limit the numeber of rows returned based on current page. Is there such a thing in SharePoint when fetching data from list/library?
For this, you'll want to use the ListItemCollectionPosition property of SPQuery.
SPListItemCollectionPosition is the class which helps to achieve paging and sorting the results fetched by SPQuery.
See here: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splistitemcollectionposition.aspx
and here for a more comprehensive example
Paging using CAML cannot go to a Nth page directly, like you can do in SQL.
For using paging, you need to use ListItemCollectionPosition property in the SPQuery.
If you have further questions, please comment. If not, please accept the answer
EDIT1) References - http://www.c-sharpcorner.com/UploadFile/40e97e/sharepoint-2010-using-splistitemcollectionposition-for-fas/
