Grid Filter issue

[vairam]

Hi

If i Type '|' this special character in the filter text box its giving me a error.

http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/filtering/defaultcs.aspx.

How can i restrict this

Regards
Vairamuthu

[Shinu]

Hello,

RadGrid do not support filtering using some special characters. To be more specific, " LIKE ", " AND ", " OR ", " | ",  "\"", ">", "<", "<>", " NULL ", " IS " and '';" are unsupported.

I tried following approach in order to prevent the special characters entering in filer textbox.

C#:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridFilteringItem)

{

GridFilteringItem fItem = (GridFilteringItem)e.Item;

foreach (GridColumn col in RadGrid1.MasterTableView.Columns)

{

(fItem[col.UniqueName].Controls[0] as TextBox).Attributes.Add("onkeyup", "CheckSpecial(this, event)");

}

}

}

JavaScript:

<script type="text/javascript">

function CheckSpecial(text,e)

{

var regx, flg;

regx = /[^0-9a-zA-Z'' ]/

flg = regx.test(text.value);

if (flg)

{

var val=text.value;

val=val.substr(0,(val.length)-1)

text.value=val;

}

}

</script>

Hope this helps :)

-Shinu.

[vairam]

Hi shinu

Thanks i will try this.

Regards
Vairamuthu