I'm trying to set a DataAdapter connection string to point to %APPDATA%
from within Visual Studio designer by editing the DataAdapter properties. I cannot seem to be able to use that moniker on the connection string property. It doesn't get translated to C:\Users\MyUserName\AppData\Roaming
when I then run the application in debug mode.
How can I ensure that these type of strings can be set within the designer so they are not hardcoded and do not jeopardize any future Setup project?
Note: I know how to handle it in code with GetFolderPath(). But is there similar functionality for controls properties and string settings/resources in the designer?