如何在.net中以编程方式设置连接字符串配置？

using System.Configuration;

// 获取连接字符串配置
string connectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

// 修改连接字符串配置
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
ConnectionStringsSection connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");

// 创建一个新的连接字符串实例
ConnectionStringSettings newConnectionString = new ConnectionStringSettings("myConnectionString", "Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword", "System.Data.SqlClient");

// 删除旧的连接字符串
connectionStringsSection.ConnectionStrings.Remove("myConnectionString");

// 添加新的连接字符串
connectionStringsSection.ConnectionStrings.Add(newConnectionString);

// 保存更改
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("connectionStrings");