WinForms - Data Grid - Find Panel Modes (v18.2)

If you are a DevExpress WinForms user, you have very likely worked with our Data Grid before – it’s a staple of the product line. We are adding a few features in the v18.2 release, and our post in September already described Scrollbar Annotations and a few others. Now it’s time to look at the new Find Panel functionality!

Before v18.2, the Find Panel in the Data Grid only supported one behavior: it filtered grid data using the string entered by the user, and it hid all rows that didn’t match the criterion.

Data Grid Find Panel Filter Mode

For v18.2, we assigned this behavior – which remains the default – the name Filter Behavior. However, using the property OptionsFind.Behavior you can now also switch to a new mode called Search. In this mode, the Data Grid highlights matching rows but leaves other data visible at the same time. This means that the search feature resembles the way searching works in a web browser, or a document based application like Word or even Visual Studio.

Data Grid Find Panel Search Mode

As you can see in the screenshot, the buttons displayed next to the search string editor are Previous and Next in this mode. Using the keyboard, Enter and F3 activate the Next button, and Ctrl-Enter, Shift-Enter and Shift-F3 go to the Previous occurrence, providing an intuitive experience for most users.

The search string editor shows the number of rows that match the criterion, and the new Scrollbar Annotations are used in this mode to show the yellow highlights in the scrollbar that are also visible in the screenshot.

If you would like this mode to be the default for all Data Grid Find Panels in your application, you can set a static property like this:

WindowsFormsSettings.FindPanelBehavior = FindPanelBehavior.Search;

Finally, please note that the new Search mode is not supported for Server Mode data sources.

Please Let Us Know What You Think!

Your feedback is always welcome! What do you think about the new Search mode? Would you like to see this mode supported in other controls, like the Tree List or the Vertical Grid? Do you think the mode should become the default in the future?

9 comment(s)
Santiago Moscoso

Nice one.

Would you add an icon inside the text box at the start showing current behaviour, than when clicked let you change the behavior? Say a funnel for filtering and a magnifier for searching.

Take as example icons at the start of cells on the filter row.

Of course this could be enabled/disabled by a setting.

30 October, 2018
Christopher Jay

We have a wide variety of users.  Many are novices.  I can imagine that they would find this feature useful but only if I could somehow dim the non-matching rows in addition to having the scrollbar marks.  It would be intuitive and would probably look great.  Any way to do this?

30 October, 2018
Dmitry Babich (DevExpress)

@Santiago

Even though we didn’t plan this feature in the near future, I should say that the idea sounds interesting. We will keep it in mind when planning future improvements in our Grid Control.

@Christopher 

This functionality can be implemented via the RowStyle event. Please submit a new ticket in our Support Center, and our support team will provide you with the required code.

30 October, 2018
Robert Perry 1

It would be brilliant (and an easy win) if the Find Panel actually filled the space it has and docked properly, instead of being squashed to the left 🤗

30 October, 2018
Daniel Hüttenberger

The OR search like in WPF Grid as option would be much better.

30 October, 2018
Daniel Hüttenberger

I mean the AND search.

30 October, 2018
Edhy Rijo

Hi Oliver,

Nice feature.  We welcome the constant enhancements to the tools.

One that my users always request is to be able to do an exact match search which can be accomplish by entering the search value in quotation like "the".  I already have this functionality via custom code but it will be nice to have it out of the box.

31 October, 2018
Laurence

Will this also apply to the Treeview find panel?

31 October, 2018
Dmitry Babich (DevExpress)

@Laurence

Yes, this functionality is likely to appear in our TreeList in 2019 as well.

2 November, 2018

Please login or register to post comments.