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?

Description:

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.

Solution:

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 ‘[‘.

C#

 

VB

 

The following screenshot displays the filtering applied with special characters.

F:\Winforms\KB\DataGrid\SpecialCharacter\WindowsFormsApplication21\SpecialCharacterfilter2.png

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

Article ID: Published Date: Last Revised Date: Platform: Control:
4492 04/19/2015 04/19/2015 WinForms GridGroupingControl
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

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

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