I am trying to perform a quick search but I keep getting this error or a similar one
Cannot perform 'LIKE' operation on System.Int32 and System.String
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