We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Filtering data - Error When decimal filter applied.

Thread ID:

Created:

Updated:

Platform:

Replies:

17179 Aug 3,2004 08:07 AM UTC Jan 19,2006 09:25 AM UTC Windows Forms 3
loading
Tags: GridControl
Pramod Dhanwade
Asked On August 3, 2004 08:07 AM UTC

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 [Syncfusion]
Replied On August 3, 2004 08:24 AM UTC

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
Replied On August 3, 2004 09:28 AM UTC

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 [Syncfusion]
Replied On January 19, 2006 09:25 AM UTC

>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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;