We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

paging on server side


setting the pageSettings info on server side does not work, what I am trying to do is to use CurrentPage and PageSize to retrieve the records, total count from db and set the paging info.

grid.PageSettings.TotalRecordsCount = total;
grid.PageSettings.TotalPages = (int)Math.Ceiling((double)total/grid.PageSettings.PageSize);
grid.PageSettings.PageCount = grid.PageSettings.TotalPages;

grid.datasource = data;

does not seem to work.

4 Replies

JK Jayaprakash Kamaraj Syncfusion Team May 27, 2016 01:04 PM UTC

Hi Kevin, 

Thank you contacting Syncfusion support. 

In ASP.NET, the server-side operations(paging/filtering/sorting) is performed by using the WebMethodAdaptor, and the DataManager parameter is set as value. 
We already have knowledgebase document for server-side operations. Please refer to the below link. 
Jayaprakash K. 

KE Kevin May 27, 2016 03:34 PM UTC

just briefly look at the documentation. the first question is why? why would it need all records to return and does all that in memory? for paging, the whole point of it is to load less data from the database, if there are millions of rows of data in the table, then it loads them all into the memory. is that the kind of design for efficiency in mind? 

KE Kevin May 27, 2016 03:57 PM UTC

never mind, will pass the parameters from the datamanager into the data access layer. 

SS Seeni Sakthi Kumar Seeni Raj Syncfusion Team May 30, 2016 05:33 AM UTC

Hi Kelvin, 

If you face any other problem, please let us know. We will help with it. 

Seeni Sakthi Kumar S. 

Live Chat Icon For mobile
Up arrow icon