Cannot perform 'like' operation on system.double and system.string

[mjassalina]

Cannot perform 'like' operation on system.double and system.string


Hi, Im experiencing this error, Can anyone help me regarding this?

Here's the code:


LstTableBindingSource.Filter = "(Convert([Defect ID], 'System.String') LIKE '" & txtSearch.Text & "')" &
"OR (Sen LIKE '" & txtSearch.Text & "')"


Thank you.

 

[strongm]

The error message is your friend here, and is pretty specific about what the problem is: Sen is clearly a double (or is being coerced to one somewhere), and needs to be converted - just like [Defect ID]- to a string.