Updating conn string at run time

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:

Code:

---

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 :

Code:

---

            //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.

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

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

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

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

Code:

---

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");

---