Edit connection string in app.config

Try with below code:

"1.0" encoding="utf-8" ?>
"DBConnection" connectionString="Data Source=.;Initial Catalog=OmidPayamak;IntegratedSecurity=True" providerName="System.Data.SqlClient" />

Add below code for update value in runtime:

var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
if(connectionStringsSection != null)
{
connectionStringsSection.ConnectionStrings["DBConnection"].ConnectionString = "server=localhost;user=root;port=3306;password=abc";
config.Save();
ConfigurationManager.RefreshSection("connectionStrings");
}

2 Replies

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