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.
Note: In the GridGroupingControl (1st grid), the characters [*] typed in the dynamic filter bar cell to filter the values start with the special character ‘*’.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|