Editing data before it's filtered

[ryan]

Hello,

I need to edit grid data in code before the server does filtering on it when the filter button is pressed.  The reason I need to do this is because text in my table has a space after it (which means the EndsWith filter doesn't work).  Anyone know the server-side event handler I can use to remove the whitespace before filtering is done on the data?  Or is there some other way to do this?

Thanks,

Ryan

[Tsvetoslav]

Hello ryan,

You can change the filter value instead:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName && ((Pair)e.CommandArgument).Second.ToString() == "YourColumnUniqueName")
    {
        ((TextBox)(((Telerik.Web.UI.GridFilteringItem)(e.Item))["YourColumnUniqueName"].Controls[0])).Text = ((TextBox)(((Telerik.Web.UI.GridFilteringItem)(e.Item))["YourColumnUniqueName"].Controls[0])).Text + " ";
    }
}

Hope it helps.

Best wishes,
Tsvetoslav
the Telerik team