This is a migrated thread and some comments may be shown as answers.

RadGrid DataBinding Best Practices for large datasets

3 Answers 421 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Nick
Top achievements
Rank 1
Nick asked on 06 Dec 2016, 10:21 PM

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

3 Answers, 1 is accepted

Sort by
0
Nick
Top achievements
Rank 1
answered on 08 Dec 2016, 03:32 PM
Anyone ?
0
Accepted
Kostadin
Telerik team
answered on 09 Dec 2016, 02:08 PM
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
Telerik UI for ASP.NET AJAX is ready for Visual Studio 2017 RC! Learn more.
0
Nick
Top achievements
Rank 1
answered on 09 Dec 2016, 02:53 PM
Thanks, Kosta. I'll look into those articles.
Tags
Grid
Asked by
Nick
Top achievements
Rank 1
Answers by
Nick
Top achievements
Rank 1
Kostadin
Telerik team
Share this question
or