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.
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 Windows Forms GridGroupingControl
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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