Edit connection string in app.config

Question

is there any c# code to edit the connection string in application app.config file at run time ??

Manas Mohapatra · Answer

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

Bikesh Srivastava · Answer

no but you can override any things