Updating conn string at run time

[venerable bede]

I dont get this.
I have figured out how to read then update settings in my app.config at run time using the following exert:

Configuration config = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
ConfigurationSectionGroup grpApp = config.GetSectionGroup("applicationSettings");
ClientSettingsSection secPropSet = (ClientSettingsSection)grpApp.Sections[sSettingsSection];
secPropSet.SectionInformation.ForceSave = true;
 SettingElement elm = secPropSet.Settings.Get(SettingName);
elm.Value.ValueXml.InnerText = NewValue.Trim();
config.Save()

This works fine with custom sections but not with <connectionStrings>.
Reading the connection strings can be done using the following exert :

            //conn strings
ConnectionStringsSection connStringSection = config.ConnectionStrings;
 ConnectionStringSettingsCollection connectionStringsCollection = connStringSection.ConnectionStrings;
System.Collections.IEnumerator connStringsEnum = connectionStringsCollection.GetEnumerator();
int i = 0;
 while (connStringsEnum.MoveNext())
{ ///blah blah

}

For the life of me I cannot figure out how to write an update made against a connection string.

[MonkOFox]

I don't understand,

if you have a connection object, and it's connectionString is set, cant you just modify it later at runtime?

using its "myConnection.ConnectionString()" property?

Justin Fox

[venerable bede]

That wont update the config file though. Or at least I dont think it will.

[MonkOFox]

Oh, why do you need it to update the config file? I thought you just needed to connect to a different database with the same connection for some reason.

Justin Fox

[Harsh Gupta]

Assuming that you are using 2005 (I am not sure if it works in earlier version(s)).

Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);

ConnectionStringSettings connStringSettings = new ConnectionStringSettings("testName", "server=testServer;Initial Catalog=testDB;blah blah");
config.ConnectionStrings.ConnectionStrings.Add(connStringSettings);

config.Save(ConfigurationSaveMode.Minimal, false);

ConfigurationManager.RefreshSection("connectionStrings");