update a connection string in app.config at runtime

[steve1rm]

Hello,

I want to be able to update a connection string that I have in my app.config file. This is so that the customer can change the connection to another server or database.

Can anyone give me any example code. I am using Visual Basic 2005.

Many thanks in advance,

Steve

 

[PGoRule]

Check out the following thread...It may help you to start with.
How to dynamically change connection strings at runtime

Sharing the best from my side...

--Prashant--

 

[steve1rm]

Hello

I am using my.settings to create a application scope connection string.

My problem I have into the setting and create a connection string (easy). But I don't know and can't find out to update and save the new connection string.

My.Settings.cnnString = "This is example connection" 'Error read-only property

I am using vb.net 2005

Can anyone help,

Thanks in advance,

Steve

 

[steve1rm]

Hello

I am using my.settings to create a application scope connection string.

The customer would like to change this if they want to connect to another database, and this should update the app.config file with the updated connection string.

My problem I have into the setting and create a connection string (easy). But I don't know and can't find out to update and save the new connection string.

My.Settings.cnnString = "This is example connection" 'Error read-only property

I am using vb.net 2005

Can anyone help,

I got this code and it seem it would work. However, there is a problem with the code. I get a "Object reference not set to an instance of an object."

Here my code.

Dim config As Configuration.Configuration = Configuration.ConfigurationManager.OpenExeConfiguration(Configuration.ConfigurationUserLevel.None)
        config.ConnectionStrings.ConnectionStrings("ServiceMasterConnectionString").ConnectionString = "This is new connection " 'Error - 
        config.Save()

Thanks in advance,

Steve

 

[steve1rm]

Resolved

http://www.vbcity.com/forums/topic.asp?tid=133875