I am trying to include my.settings.dept in my sql like:
This will not work. Is there a correct way to perform this using my.settings?
I copied this code from the tableadapter configuration wizard.
VB.NET:
SELECT CustID, CustType, Address1FROM Profile
WHERE (UCASE(CustType) = "' & my.settings.dept & '")
ORDER BY SiteName
This will not work. Is there a correct way to perform this using my.settings?
I copied this code from the tableadapter configuration wizard.