I am trying to add a query to my TableAdapter Fill. I am wanting to filter the results based on 3 items that are stored in passed variables. From the documentation that I have, the SQL Select statement should be...
SELECT item1, item2
FROM table
WHERE (filter1=@first and filter2=@second and filter3=@third)
however, whenever I try to do this (or even try to do just a single passing of variable in), I get "Error in WHERE clause near '@'. Unable to parse query text."
How should I be setting up this process Do I not build it onto the datafill What is the best way to do this If I force the value of the filter1 (filter1=1), that part works.
Thanks.