GRoupSeparator in GridNumericColumn Filter Textbox

[Albert Shenker]

I have a client-side bound grid with filtering. I also have a GridNumericColumn set to type Int32. When I type in the grid filter box, the value displayed automatically includes a comma group separator, like "96,546". How do I get rid of the comma separator so it only displays "96546"?

[Viktor Tachev]

Hello Albert,

By default the GridNumericColumn is using a NumericTextBox for a filter input. It formats the numeric value that is entered based on the Culture applied on the page. This is why you are seeing a separator for the entered number.

If you would like to change the behavior you can handle the ItemCreated event for the RadGrid and set the GroupSeparator for the numeric input manually. The code snippet below outlines the approach:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
{
    if (e.Item is GridFilteringItem)
    {
        GridFilteringItem filerItem = (GridFilteringItem)e.Item;
        RadNumericTextBox textItem = (RadNumericTextBox)filerItem["NumericColumn"].Controls[0];
        textItem.NumberFormat.GroupSeparator = "";
    }
}

Regards,
Viktor Tachev
Telerik by Progress