ethnarch
asked on
Using RowFilter and getting this error Missing operand after ''%we%'' operator.
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.SyntaxErrorEx ception' 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)
for some reason i keep getting this error
An unhandled exception of type 'System.Data.SyntaxErrorEx
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
nevermind fixed my own problem thanks for the help
ASKER
just increasing the points so that i can give you both some. Thanks for the alternate coding method i didn't know you could do it that way.
ASKER