[Solved] Block special characaters in filtercolumn in grid.

[unnikkannan m]

Hai Telerik Team,

 I'm using radgrid to show the details and has given the filtering property of the rad grid. But when entering the special charcters for filtering it causes the error. I tried to get the filter string on the client side and checked for special characters, if found then to cancel the filter operation. But if i gave '|' along with the filter contents it also caused error.
If its possible to block the special from entering the filter box it would be better. Please give me a solution.

Regards & Thanks
Unni.

[Shinu]

Hello Unnikkannan,

Try attaching 'onkeyup' event for filter textboxes in order to prevent the user from typing special characters.

CS:

    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:

    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;
        }
    }

-Shinu.

[unnikkannan m]

Hai Shinu,

  Thanks for the quick reply and it worked. One more doubt can we avoid pasting the special characters by firing the onvaluechanged event() of the filtering texxtbox. which event is needed to be fired for avoid pasting special characters.

Regards
Unni

[Princy]

Hi Unni,

Try out the following code to avoid pasting special characters into the 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("onPaste", "Paste_Event();");
            }
        }
    }

js:

function Paste_Event()
  {
            var objTxtBox = window.event.srcElement;
            var PasteData = window.clipboardData.getData("Text");
            var regx, flg;
            regx = /[^0-9a-zA-Z'' ]/
            flg = regx.test(PasteData);
            if (flg) {
                var val = PasteData;
                event.returnValue = false;
            }
  }

Hope this helps..
Princy.

[Maria Isabel Henao]

Hi,

I tried the Paste_Event function and it works just perfect on IE. Is there a way to make it work on Firefox? I understand the issue is getting access to the clipboard content on Firefox, do you know any workaround to effectively block special characters on a paste event?

thanks ahead,

Maria Henao

[Maria Isabel Henao]

Nevermind! I solved it by using onBlur instead of OnPaste event and checking/formatting the filter value there.

function CheckFilterValue(controlId)
{
    var filterControl = $get(controlId);
    filterControl.value = filterControl.value.replace(regExp, "");
    return true;
}