Hi! How to manage databse in IDE (dataset, table preview) and application with relative database path in connection string?
For now i have to insert into connection string full path to database. When I use connection string like : "data source=|DataDirectory|database.db3" then in dataset i cannot get connection with database.
If i have full path todatabase then if I deploy/copy compiled app to where it has to be, then I must manualy change connection string in application option file. I'm simply forgeting to change connectionstring before release. Is there any solution to have working relative path with development and release without changing connectionstring every release and development??
Thanx
Wiaz