How to Change web.config ConnectionString dynamically

Dear Code Master,

I hope this question meet in good health, i am writing an application, i have finished writing and every thing is working we upload it to cloud for the client from time to time their is the need to make some amendment that also had to affect the database.

When we re-upload we need to make changes to the connection string in web.config, we them impliment changing the web.config dynammically that ir from run time we put some text boxes and a submit button when the button is click by the client it should edit the web.config connectionstring section and update it with the new connection string.

we have tried the following:

// ===========================================
// The content of pathname is shown below
// string pathname = "~/web.config";
//============================================
System.Configuration.Configuration Config1 = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(pathname);
ConnectionStringsSection conSetting = (ConnectionStringsSection)Config1.GetSection("connectionString");
ConnectionStringSettings StringSettings = new ConnectionStringSettings("NIQSDB", "Data Source=" + ServerName + ";Database=" + DBaseName + ";User ID=" + UserID + ";Password=" + PSSWD + ";");
conSetting.ConnectionStrings.Remove(StringSettings);
conSetting.ConnectionStrings.Add(StringSettings);
Config1.Save(ConfigurationSaveMode.Modified);

and i am getting the following error

Object reference not set to an instance of an object.

conSetting.ConnectionStrings.Remove(StringSettings);

please what am i doing wrongly.

thank you

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajeev Punhani9y ago
Accepted answer
Hi Abraham,

Please try the below code
var configuration = WebConfigurationManager.OpenWebConfiguration("~");
var section = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
if (section != null)
{
    section.ConnectionStrings["NIQSDB"].ConnectionString = "Data Source=" + ServerName + ";Database=" + DBaseName + ";User ID=" + UserID + ";Password=" + PSSWD + ";";
    config.Save();
}
You were missing 's' in connectionStrings .