Bindingsource.Filter problem.

Question

Hi guys anyone could help me on my problem. i have my bindingsource.filter = colname Like '%34%'. i got some error --> ' Cannot perform 'Like' operation on System.Int32 and System.String. ' If i'm trying to filter the numeric and dates in my bindingsource that's the error will show on my application. i hope somebody could help this problem.

aLi jackson · Answer

yeah I'm aware of that only String datatype would be applicable for LIKE operator BUT I resolved my problem and I want to shared guys how i did it. Here's my code kindly check. Myself.BindingSource.Filter =  convert([ & colName & ]'System.String') LIKE '% & Me .txtContainingText.Text & %' Actually I only converted first into string my colName in my bindingsource before I proceed in my filtering. Anyway thanks guys for this useful forums and I learned alot. God bless! Regards aLi

Mirko Meier · Answer

The like operator only works with strings. It doesn't work with integers.