RadGrid filter issue

[Benjamin]

I having having some issue with the filter of RadGrid. 

When i type ‘ the result is showing no data found which is what i wanted.

but if i type something like abc.get(‘abc’); or ‘) OR 1=1 -- the filter textbox get cleared and all result is shown. Would like to check other than this, is there anyway to not clear the filter textbox and for the result to show no data found instead?

[Attila Antal]

Hi Benjamin,

For security reasons, some of the characters/keywords are considered illegal strings in the Grid. 

If you prefer to override that you can change the IllegalStrings array and remove the characters you would like to use, see Filter grid with quotes, AND, OR or other special symbols

For example, you can exclude the OR keyword:

protected void Page_Load(object sender, EventArgs e)
{
    GridFilterFunction.IllegalStrings = new string[] { " LIKE , AND , \",>,<,<>, NULL , IS " };
}

 

The results will be as you described:

 

Regards,
Attila Antal
Progress Telerik