Cannot perform 'LIKE' operation on System.Int32 and System.String

Maria

I am trying to perform a quick search but I keep getting this error or a similar one

I have a textbox, a find button, and 6 radio buttons. The search is performed on the columns in my database depending on which radio button is selected. I am having trouble when I try passing the type int columns. This is the section of code I am having problems with.

DataRow[] foundRows;
UserTable.DefaultView.Sort="TaxNumber";
foundRows = UserTable.Select("TaxNumber LIKE '" + txtFind.Text+"*'");

I also tried: foundRows = UserTable.Select("TaxNumber LIKE '" + int.Parse(txtFind.Text)+"*'"); but that didnt work either.

Thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

sanjeewa darshana14y ago
what happen if i am using access
0
Nupur17y ago
Thanks, it really helped..
0
Dusan Tkac17y ago
Hi,

you are getting this error because the Type of your "TaxNumber" column in the data table is Int32 and you are trying to compare it with string. I think that LIKE can be used only to compare two strings.

Try this:

foundRows = UserTable.Select("Convert(TaxNumber, 'System.String') LIKE '" + txtFind.Text+"*'");

Cheers,

Dusan
+2
Maria18y ago
sql
0
Ryan Alford18y ago
Are you using Access or SQL?
0