RadGridview Virtual Mode filtering/grouping/sorting

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

    Posted 18 Nov 2009 Link to this post

    Hi,

    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,
    Tamara
  2. Julian Benkov
    Admin
    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?

    Regards,

  4. Julian Benkov
    Admin
    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

    Hello,

    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.

    Regards,
    Ed  
  6. Stefan
    Admin
    Stefan avatar
    2908 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.
     
    Greetings,
    Stefan
    the Telerik team

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

Back to Top