paging on server side

[Kevin]

hi

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;
grid.databind()


does not seem to work.

[Jayaprakash Kamaraj]

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. 

 

https://www.syncfusion.com/kb/4300/server-side-api-for-datamanager-operations 

 

Documentation for Adaptors: http://help.syncfusion.com/aspnet/grid/data-adaptors 

 

Regards, 

 

Jayaprakash K. 

[Kevin]

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? 

[Kevin]

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

[Seeni Sakthi Kumar Seeni Raj]

Hi Kelvin, 

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

Regards, 

Seeni Sakthi Kumar S.