Public Sub savenewconnection(ByVal id As String, ByVal pass As String, ByVal source As String) Try Dim newdbcon As String Dim oldconnection As ConnectionStringSettings = ConfigurationManager.ConnectionStrings("mydbcon") Dim dbcon As String = oldconnection.ConnectionString Dim builder As New OleDbConnectionStringBuilder(dbcon) builder.Add("Data Source", source) builder.Add("Password", pass) builder.Add("User ID", id) newdbcon = builder.ConnectionString Dim config As System.Configuration.Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None) config.ConnectionStrings.ConnectionStrings("mydbcon").ConnectionString = newdbcon config.Save(ConfigurationSaveMode.Modified) ConfigurationManager.RefreshSection("ConnectionStrings") Catch ex As Exception MsgBox(ex.Message) End Try End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)