Filtering data - Error When decimal filter applied.

[Pramod Dhanwade]

Hi,

Here is the description of the error I am having for filter bar.

Steps to reproduce the error :

I have data grid wired with filter bar.

When i apply custom filter on data grid --> "Contains" condition on Numeric column of data grid--> enter any numeric value --> Messagebox is dispalyed "Cannot perfrom like operation on System.Decimal and System.String"

Could you please suggest me how to trap this error? Or give me some solution by which i can avoid applying "Contains" custom condition for numeric columns?

Thanks,
Pramod Dhanwade

[Administrator]

You can try catching the error by handling grid.ValidateFailed (I think this should be hit in this case, but I may be wrong.). There you can display your own message. To avoid the grid difpalying its default message, set grid.CurrentCell.ErrorMessage = "" and set e.Handled = true.

In 2.0.5.1, you can design your own custom filter dialog and display it instead of the default. That way, you can avoid having a Contains option for numerical columns, or whatever. See the GridFilterBar sample that ships with 2.0.5.1 to see a sample.

[Pramod Dhanwade]

Hi,

Thanks for your suggestion.

I used filterbar_FilterBarTextChanged event. I applied new filter condition to the datagrid DataView. While applying this filter condition, it throws an error, which i caught and thus avoiding the messagebox getting displayed.

Thanks once again for your support.

Pramod Dhanwade

>You can try catching the error by handling grid.ValidateFailed (I think this should be hit in this case, but I may be wrong.). There you can display your own message. To avoid the grid difpalying its default message, set grid.CurrentCell.ErrorMessage = "" and set e.Handled = true.
>
>In 2.0.5.1, you can design your own custom filter dialog and display it instead of the default. That way, you can avoid having a Contains option for numerical columns, or whatever. See the GridFilterBar sample that ships with 2.0.5.1 to see a sample.

[Administrator]

>Hi,
>
>Here is the description of the error I am having for filter bar.
>
>Steps to reproduce the error :
>
>I have data grid wired with filter bar.
>
>When i apply custom filter on data grid --> "Contains" condition on Numeric column of data grid--> enter any numeric value --> Messagebox is dispalyed "Cannot perfrom like operation on System.Decimal and System.String"
>
>Could you please suggest me how to trap this error? Or give me some solution by which i can avoid applying "Contains" custom condition for numeric columns?
>
>Thanks,
>Pramod Dhanwade