RadGridview Virtual Mode filtering/grouping/sorting

[CWB]

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

[Julian Benkov]

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.

[Fabian Raul Jofre]

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

Regards,

[Julian Benkov]

Hello Fabian Raul Jofre,

Please view your last support ticket for the answer.

All the best,

Julian Benkov
the Telerik team

[Ed]

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  

[Stefan]

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

[Aseman]

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 ? 

[Dess | Tech Support Engineer, Principal]

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