且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在运行时更改app.config文件中的connectionString?

更新时间:2022-11-04 15:05:34

Imports System.Configuration
Imports System.Configuration.ConfigurationManager

        Dim config As System.Configuration.Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None)          
        config.ConnectionStrings.ConnectionStrings("MyProject.Properties.Settings.MyProjectConString").ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=|DataDirectory|\SampleDB;Persist Security Info=True;"
        config.Save(ConfigurationSaveMode.Modified)

其中 MyProject.Properties.Settings.MyProjectConString 是项目的名称和连接字符串。

Where MyProject.Properties.Settings.MyProjectConString is the name of your project and connection string.