Changing Connection String Settings

handokowijaya

Member
Joined
Dec 14, 2006
Messages
5
Programming Experience
1-3
I'm building vb.net app using n-tier format with business layer using Typed Dataset that's generated from SQL 2005, and UI layer.
Everything works fine until my boss decided he wants to use an empty database, which means i have to redirect the connection string to the new database in our sql 2005.

Now currently the ConnectionString is saved as a settings entry in the business layer and the scope of this setting is Application. I tried changing this from code without any success. Does anybody know the best solution for this? My temporary solution is by changing it in designer mode and recompile the whole app.

Or does anybody know the link that might help. Pls help!

Thx
han
 
Back
Top