c# - Change connection string & reload app.config at run time -


When I change the connection string using this code, then it will run on app.config Does not load. I hope how we expect to reload it app.config .

  config.ConnectionStrings.ConnectionStrings ["JVVNL_NEW.Properties.Settings.JVVNL_NEWConnectionString1"]. Connection String = ConString; Config.ConnectionStrings.ConnectionStrings ["CMS_NEW.Properties.Settings.JVVNL_NEWConnectionString1"] ConnectionString = ConString; Config.Save (ConfigurationSaveMode.Modified, True); ConfigurationManager.RefreshSection (config.ConnectionStrings.SectionInformation.SectionName);  

The exact thing to do was to do this code working for me:

  var config = ConfigManager.OpenExeConfiguration (ConfigurationUserLevel.None); Var connectionStringsSection = (ConnectionStringsSection) config.GetSection ("connectionStrings"); ConnectionStringsSection.ConnectionStrings ["Blah"]. ConnectionString = "Data Source = Blow; Initial Catalog = Blow; UID = Blah; Password = Blah"; Config.Save (); ConfigurationManager.RefreshSection ("ConnectionStrings");  

Comments