RadGrid DataBinding Best Practices for large datasets

4 posts, 1 answers
  1. Nick
    Nick avatar
    3 posts
    Member since:
    May 2016

    Posted 06 Dec 2016 Link to this post

    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

  2. Nick
    Nick avatar
    3 posts
    Member since:
    May 2016

    Posted 08 Dec 2016 Link to this post

    Anyone ?
  3. Answer
    Kostadin
    Admin
    Kostadin avatar
    1733 posts

    Posted 09 Dec 2016 Link to this post

    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.
  4. Nick
    Nick avatar
    3 posts
    Member since:
    May 2016

    Posted 09 Dec 2016 Link to this post

    Thanks, Kosta. I'll look into those articles.
Back to Top