RadGrid Filter Does Not Work With Special Characters

[Mayur]

I am using radgrid filter in which i am performing search operation,when i put text it filters the data but when i put text along with special characters for eg: building[ then filter does not work.

[Shinu]

Hi Mayur,

Please try setting EnableLinqExpressions="true"  for the grid and those characters will be taken into account as part of the filter value. If this doesn't help, provide your code snippet.

Thanks,
Shinu

[Milena]

Hello Mayur,

RadGrid does have an IllegalStrings collection which contains the strings which if entered will prevent the grid from filtering. You can find more information on this matter here.

Regards,
Milena
Telerik

 

 

[Piyush]

Hi Shinu,

I too am having same problem, I tried with your suggestion but it is giving exception "An exception of type 'System.Data.SyntaxErrorException' occurred in System.Data.dll but was not handled in user code".
 
In Additional information "Syntax error: Missing operand after '["FirstName"]' operator." i am getting this exception.
Please help me how will i get solution i am new to this technology.

[Milena]

Hello,

It is hard to determine the cause of the problem based on the provided information. Could you please provide sample project and steps for reproduce in order replicate the issue on our side?

Note, if you try to filter using Illegal characters, then the filtering will not be applied.
Illegal strings indicate which strings could not be entered as a part of the filtering value. Excluding values from the array will allow these values to be entered in the filtering value. However, it is not recommended because possible security vulnerabilities could arise.

Regards,
Milena
Telerik