RadGridview Virtual Mode filtering/grouping/sorting

8 posts, 0 answers
  1. CWB
    CWB avatar
    4 posts
    Member since:
    Feb 2009

    Posted 18 Nov 2009 Link to this post


    I need to filter/group/sort through more than 100,000 records.
    Loading all records to datatable takes long time and keeping preloaded data in datatable increases memory consumption.
    I'd like to implement virtual mode in GridView, so I can retrieve first X rows of data to datatable based on columns filters.
    Can someone give me an example of using Virtual Mode with filtering/grouping/sorting.
    In all examples that I found so far, filtering option is set to false.

    Thank you,
  2. Julian Benkov
    Julian Benkov avatar
    1135 posts

    Posted 23 Nov 2009 Link to this post

    Hello Tamar,

    RadGridView does not process filtering, sorting, and grouping in Virtual Mode. Only the UI and expression collections are updated.

    You can use FilterChanged, SortChanged, and GroupByChanged events to implement you logic for virtual mode. The events notify for a change in the related expression collections and send updates to RadGridView UI to fire CellValueNeeded event to fill again the displayed cells in the current grid view.

    In the future editions of RadGridView, we have planned to implement virtual grouping operations with a simpler and more useful API.

    Kind regards,
    Julian Benkov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. Fabian Raul Jofre
    Fabian Raul  Jofre avatar
    29 posts
    Member since:
    Dec 2008

    Posted 29 Jun 2010 Link to this post

    Hi, could you give some tips on how to implement grouping functionality in virtual mode?


  4. Julian Benkov
    Julian Benkov avatar
    1135 posts

    Posted 02 Jul 2010 Link to this post

    Hello Fabian Raul Jofre,

    Please view your last support ticket for the answer.

    All the best,

    Julian Benkov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Ed
    Ed avatar
    11 posts
    Member since:
    Jun 2011

    Posted 17 Aug 2011 Link to this post


    I am also interested implementing GroupBy functionality in Virtual Mode. Would you make the solution or the tips available to me as well? I am using Q2 2010 Winform on VS2008.

  6. Stefan
    Stefan avatar
    2911 posts

    Posted 19 Aug 2011 Link to this post

    Hi Ed,

    Thank you for writing.

    RadGridView does not support any data operations in virtual mode. This mode is intended to display large amounts of data handled manually.

    I hope that you find this information helpful.
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  7. Aseman
    Aseman avatar
    43 posts
    Member since:
    Aug 2019

    Posted 13 Jan 2020 Link to this post


    thank you for your attention 

    i implement this project 


    in my solution 

    BUT ALSO I received The Error Msg:  "Filtering Is Not Supported in Virtual Mode"


    Please tell me WHY ? 

  8. Dess | Tech Support Engineer, Sr.
    Dess | Tech Support Engineer, Sr.  avatar
    4169 posts

    Posted 16 Jan 2020 Link to this post

    Hello, Aseman,    

    The referred KB is quite an old solution for manipulating over a million of records in RadGridView.

    The recommended approach now is to to use RadVirtualGrid which is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. It provides a convenient API for implementing filtering, grouping (achieved with hierarchy), sorting without affecting the performance with millions of records.

    I hope this information helps.

    Dess | Tech Support Engineer, Sr.
    Progress Telerik

    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top