WinForms Data Grid – A New Filtering Option

WinForms Team Blog
12 March 2021

Hope you are all well. As always, thank you for your continued support.

Our next major WinForms Grid update (v21.1) will introduce a new UI element to help improve usability. As you can see in the animation below, v21.1 will allow end-users to enter search strings directly within the Grid’s column header.

We'd love to hear your feedback – let us know what you think of this new UI element.

FREE DevExpress Xamarin UI Controls

Deliver high-impact native mobile apps with our feature-rich Data Grid, Scheduler, Chart, TabView, Editors, and utility controls. Reserve your free copy today!
dbSoft
dbSoft

Perfect!!!! You helping us to create better applications for our customers!! Thank you DevExpress Team!!

I only hope, that winforms will not be deprecated after the years!!!

12 March 2021
CRM-48072708-3269-4580-8510-390573ae1482
Kiryl Y

Very cool. Autofilter row is kinda annoying.

Thank you 

12 March 2021
Jeremiah Tilley
Jeremiah T
Looks great! Users will love that adjustment. Nicely implemented.
12 March 2021
Christopher Jay
Christopher Jay

Personally, I LOVE it.  It's going to be difficult to migrate our existing users to use it though since we do not have direct contact with them to explain it to them.  I may have to turn on this feature but build a tutorial using the Adorner tool to show our users how to use it.  It would be nice if DevExpress could build a nice tutorial/walkthrough for how to use common grid features that developers can call as a simple method to show to our users, like:

GridControl1.ShowTutorial()

That way, we can decide who to show it to and when.  I picture something like flyouts that point to various elements of a grid control with a short explanation of each feature that is enabled in the grid.  Maybe customizable explanations could be added eventually, too.  You could likely create a much better interactive walkthrough of grid features than I would be able to in less time.  It would really help our users understand the power of these grid features!

Great work, as always.

12 March 2021
Chuck Bass
Chuck Bass
I like it but fear our use case doesn't match.  I have tons of data so I can't throw away the horizontal space.  In our use case, the filter value would be better stored vertically a line down (sort of like the filter row) but using your more stylized text as you show above.  Just making it a smaller font with a touch of grey with the magnifier icon could look quite nice.
12 March 2021
Ray Navasarkian (DevExpress)
Ray Navasarkian (DevExpress)

Chuck - you'll have an option to display the applied filter as a tooltip - though I don't think this feature should be used with "tons" of columns. One obvious problem with "tons" of columns is horizontal scrolling. Please consider this is as just a new UI option - it will never serve as a catch all since its usefulness will always be driven by screen real estate.


12 March 2021
Chris D
Chris D
Love it!
13 March 2021
Alvis Kums
Alvis Kums
Love it!!!
13 March 2021
Alexander Krakhotko (Xafari team)
Alexander Krakhotko (Xafari team)
looks great!
a few questions:
1) what is the maximum width of the blue text?
2) what happens when the header is wider than the column caption width?
13 March 2021
jerome crevecoeur
jerome crevecoeur

Could you add an appearence property to filterRow in GridView ?

When there is no row, all users are confusing new row and filter row....




14 March 2021
sun chao
sun chao
the column which is in filter state should be highlighted(for example, bold, big font), otherwise some stupid user will complain data lost.
14 March 2021
Jan Thordsen
Jan Thordsen

I agree with sun chao. Filtered views tend to make nervous users even more nervous :-)

Otherwise great improvement.

14 March 2021
AnGa
AnGa
I love it!
15 March 2021
Customer69806
Mikael 69806
Good function, this will be used!
15 March 2021
Anwar Sayeed_1
Anwar Sayeed_1
Very good feature
16 March 2021
Guido Geurts
Guido Geurts

When will this be available ?

I can't wait to show this to my users


16 March 2021
Edhy Rijo
Edhy Rijo

I like it.

Thanks!

16 March 2021
Jeff Weir
Jeff Weir
Looking forward to this feature in VCL 22.1!
16 March 2021
Customer109543
UR-IT
I really like that. Plze go on!
18 March 2021
Customer109543
UR-IT
I really like that. Plze go on!
18 March 2021
CRM-4f704ce5-174a-44c8-8f1f-326cd5f3d4f8
DEVBMC

Fantastic!

When will this be available ?

19 March 2021
Dmitry (DevExpress)
Dmitry (DevExpress)
@DEVBMC Hi, this will be released in v21.1. As always, we expect to release the first major update of the year in mid-May.
19 March 2021
Appy Developers
Appy Developers

very good, but please give an options to have both the excel filter option, and the new search idea.


19 March 2021
Chuck Bass
Chuck Bass

RE: "One obvious problem with "tons" of columns is horizontal scrolling. "


Umm, no.  Just the opposite.  For many of our columns, the header text drives column width.  We enable multi-line headings in order to have no horizontal scrolling.  Needing to make every searchable/filterable column twice as wide is a no-go in most of my use cases because it will create more horizontal scrolling.

If my users weren't stuck on smallish monitors this would be less of an issue, but width is an issue I deal with.

However, the feature definitely will work in some of my use cases and the appreciate the more modern styling and interaction.  The polish over time makes your tools a joy to work with.

25 March 2021
Klaus Pieper_1
Klaus Pieper_1
How can the user select "contains", "starts with" filters etc.?
16 April 2021

Please login or register to post comments.