I am trying to filter a dataview, say i have an item in a column called weebles I want to be able to pull it up in the filter by just typing in a search box we and just looking for a part of a string not the whole string
for some reason i keep getting this error
An unhandled exception of type 'System.Data.SyntaxErrorException' occurred in system.data.dll
Additional information: Syntax error: Missing operand after ''%we%'' operator.
This is the code i am using
dv1.RowFilter = ComboBox1.Text & "LIKE'%" & TextBox1.Text & "%'AND LocationNo = " & CStr(loc)