C# How to Modify DataSet Connection Strings at Runtime?
PROGRAMMING HELP 2015/10/19 11:07
Detailed instructions by Paul Keister in his excellent article Adaptive Connection Strings for Windows Forms Applications
In brief
the connection string property is set read only in the Settings.Designer.cs class:
public string MyAppConnectionString { get { return ((string)(this["MyAppConnectionString"])); } }
However, all application settings are accessible in read/write mode by using the indexer directly. The following code demonstrates how to modify the connection string using this approach:
//change the application connection string Properties.Settings.Default["MyAppConnectionString"] = strCnString; //debug:verify that this really did work Console.WriteLine(Properties.Settings.Default.MyAppConnectionString);