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

RadGridview Virtual Mode filtering/grouping/sorting

7 Answers 389 Views
GridView
This is a migrated thread and some comments may be shown as answers.
CWB
Top achievements
Rank 1
CWB asked on 18 Nov 2009, 06:00 PM
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

7 Answers, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 23 Nov 2009, 03:02 PM
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.
0
Fabian Raul Jofre
Top achievements
Rank 2
answered on 29 Jun 2010, 08:35 PM

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

Regards,

0
Julian Benkov
Telerik team
answered on 02 Jul 2010, 03:06 PM
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
0
Ed
Top achievements
Rank 1
answered on 17 Aug 2011, 03:39 PM
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  
0
Stefan
Telerik team
answered on 19 Aug 2011, 04:14 PM
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 >>

0
Aseman
Top achievements
Rank 1
Veteran
answered on 13 Jan 2020, 05:22 PM

Hello 

thank you for your attention 

i implement this project 

https://www.telerik.com/support/kb/winforms/gridview/details/high-performance-with-radgridview-and-virtual-mode-including-filtering-sorting-and-grouping

in my solution 

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

 

Please tell me WHY ? 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 16 Jan 2020, 09:08 AM

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.

Regards,
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.
Tags
GridView
Asked by
CWB
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Fabian Raul Jofre
Top achievements
Rank 2
Ed
Top achievements
Rank 1
Stefan
Telerik team
Aseman
Top achievements
Rank 1
Veteran
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or