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?