RadGrid DataBinding Best Practices for large datasets

[Nick]

Hey I have a RadGrid that pulls information from the database and I'm using my NeedDataSource Event to pull the data from the DB, make a few tweaks and assign it to my RadGrid DataSource property. We're using the default paging,sorting, etc and what happens when a user moves to the next page is that the NeedDataSource even is fired again and my data starts pulling from the database again and goes through the same process and it just went for no apparent reason. Is there a way to use the existing DataSource that is already in the RadGrid ? For Reference I'm using Telerik.Web.UI Version 2013.1.403.35

Thanks

[Nick]

Anyone ?

[Kostadin]

Hi Nick,

I am afraid you cannot prevent firing the NeedDataSource event handler and you need to provide a data on each call in order to be displayed on the page. What I can suggest you is to use custom paging, sorting and filtering in order to provide only a part of the data and perform all operation on the server. You can check out the following help article which elaborates more on server operations.
Custom Paging
Applying Custom Sort Criteria​
Grid - Custom Paging

Regards,
Kostadin
Telerik by Progress

[Nick]

Thanks, Kosta. I'll look into those articles.