I added queries to my dataset via the designer. is there a way to use variables in those queries?
Printable View
I added queries to my dataset via the designer. is there a way to use variables in those queries?
Nevermind, I found my answer.
It appears you have to edit the property of said query and insert the parameters there, then have place holders. For OLEDB I had to use the question mark
In case anybody else cares.Code:SELECT Item
FROM Table
WHERE (Itemname LIKE '%' + ? + '%')
ORDER BY ?, ?