1. Home
  2. Forum
  3. ASP.NET Web Forms
  4. Server Side Paging for large data set.

Server Side Paging for large data set.

I am using an Excel style grid to display a data set with filtering, sorting and paging from a SQLdatasource.
I call Grid.DataBind() when a Dropdownlist selection is changed.
When the data set gets too big, I get an Out Of Memory Exception (about 50,000 records) and the grid fails.
I believe I need to use server side paging, but I cannot find any documentation on how to convert to Server side for ASP.net Web Forms.

Am I on the right track to use server side events? 
Can you provide any examples of using server sided events on a grid in ASP.net Web Forms?

1 Reply
SA Saravanan Arunachalam Syncfusion Team October 27, 2017 05:43 AM UTC

Hi Levi, 
Thanks for contacting Syncfusion’s support. 
Query 1: I believe I need to use server side paging, but I cannot find any documentation on how to convert to Server side for ASP.net Web Forms. 
We understood from your query, you need to render the Grid with load on demanding, it can be achieved by using UrlAdaptor of DataManager and we have already discussed about this in the following documentation link. 
We have provided default load on demand support and no need to seperately peerform paging on server side, if we binding sqlDatasource to the Grid and we have discussed this query in the below online demo link. 
And also refer to the following knowledge base document link to know about server side data operation. 
Query 2: Am I on the right track to use server side events?  
 We have already discussed this query in the below online demo and documentation link. 
Regards, 
Saravanan A. 


Loader.
Up arrow icon