We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to filter special characters like '[', ']', '*', '%' by typing it in dynamic filter?

Platform: WinForms |
Control: GridGroupingControl |
Published Date: April 19, 2015 |
Last Revised Date: April 19, 2015
Tags: filtering


By default, the filtering uses an expression that contains the column name like [column name]. Hence, using this [ in filtering expression is possible since the column name is mentioned within [ ] . If you filter in DataGridView using the same, it throws an exception as Error in Like operator: the string pattern ‘George[' is invalid and also the special characters like *, %, ] symbols is not considered while applying the dynamic filter.


These special characters can be handled within the square bracket like [ [ ]” or “[*]” when you type the text in the dynamic filter. The same works for RowFilter too. The following code example explains about RowFilter using the special character ‘[‘.





The following screenshot displays the filtering applied with special characters.


C:\Users\Giftline\Desktop\img.jpgNote: In the GridGroupingControl (1st grid), the characters [*] typed in the dynamic filter bar cell to filter the values start with the special character ‘*’.

Sample Links:

C#: SpecialCharacter

VB: SpecialCharacter

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon