WinForms Data Grid - How to make the Auto Filter Row insensitive to accents

This example demonstrates how to create a custom function that removes diacritic symbols from the specified string. The GridView.SubstituteFilter event is handled to inject the custom function into the grid's active filter.

Note

The SubstituteFilter event is available in v15.1+. For older versions, create a custom grid control and customize the auto-filter row's behavior. You should override the GridView.RaiseCustomRowFilter method to normalize the cell text and filter string using the standard String.Normalize method. The cell value is processed based on the comparison operator type specified by the OptionsColumnFilter.AutoFilterCondition property.

Files to Review

• GridFilterSubstitutor.cs (VB: GridFilterSubstitutor.vb)
• RemoveDiacriticsFunction.cs (VB: RemoveDiacriticsFunction.vb)
• MainForm.cs (VB: MainForm.vb)
• Program.cs (VB: Program.vb)