How do I … change Config ConnectionString at runtime
21-Jun-1212 Leave a comment
See code below
Public Class RuntimeConnection Const ConStringSettingsName = "MyEntitiesName" Sub SetRuntimeConnection(UserNameValue As String, PasswordValue As String) Dim currentConString = ConfigurationManager.ConnectionStrings(ConStringSettingsName).ConnectionString Dim myWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~") Dim builder As New EntityClient.EntityConnectionStringBuilder(currentConString) Dim sqlConStrManager As New SqlClient.SqlConnectionStringBuilder(builder.ProviderConnectionString) sqlConStrManager.UserID = UserNameValue sqlConStrManager.Password = PasswordValue builder.ProviderConnectionString = sqlConStrManager.ConnectionString myWebConfig.ConnectionStrings.ConnectionStrings(ConStringSettingsName).ConnectionString = builder.ConnectionString myWebConfig.Save() ConfigurationManager.RefreshSection("connectionStrings") 'Dim msg = String.Concat(sqlConStrManager.ConnectionString, vbCrLf, vbCrLf, builder.ConnectionString, vbCrLf, vbCrLf, _ ' myWebConfig.ConnectionStrings.ConnectionStrings(ConStringSettingsName).ConnectionString) 'MsgBox(msg) End Sub End Class
Also see below
Imports System.Configuration ... Dim config As Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None) config.ConnectionStrings.ConnectionStrings("myEntities").ConnectionString = value config.Save() ConfigurationManager.RefreshSection("connectionStrings") 'MsgBox(config.ConnectionStrings.ConnectionStrings("myEntities").ConnectionString) .
End.