How to trap bad filter expression in RadGrid

[Dexter McCloud]

I have a date field in a RadGrid called, "DueDate".  I would like to make sure the user does not enter invalid data into the filter.  To contemplate matters, this date field may not always be present.  I may set the DueDate to an empty string in the grid ItemDataBound event depending on business rules.  So, the Due Date in the grid may be a valid date or an empty string.

Does anyone know how I can check the filter after the user clicks a filterig menu option so I can throw an error before the grid tries to rebind the data?

[Schlurk]

Using this you can capture the filtering event and then either cancel it if you have a bad filter, or let it continue to execute the filtering:

    protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.FilterCommandName)
        {
            if (logic)
            {
                e.Canceled = true;
            }
        }
    }

[Dexter McCloud]

This worked perfectly.  Thanks!