public static void UpdateConnectionStringsConfig(string key, string conString) { bool isModified = false; //记录该连接字符串是否已经存在 if (ConfigurationManager.ConnectionStrings[key] != null) { isModified = true; } //新建一个连接字符串实例 conString = EncodeAndDecode.EncodeBase64(conString); ConnectionStringSettings mySettings = new ConnectionStringSettings(key, conString); // 打开可执行的配置文件 Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); //如果连接字符串已存在,首先删除它 if (isModified) { config.ConnectionStrings.ConnectionStrings.Remove(key); } //将新的连接字符串添加到配置文件中 config.ConnectionStrings.ConnectionStrings.Add(mySettings); //保存对配置文件所做的更改 config.Save(ConfigurationSaveMode.Modified); //强制重新载入配置文件的ConnectionString配置节 ConfigurationManager.RefreshSection("connectionStrings"); }
/// <summary> /// 获取连接节点值 /// </summary> /// <param name="key"></param> /// <returns></returns> public static string GetConnectionValue(string key) { if (ConfigurationManager.ConnectionStrings[key] != null) { return(EncodeAndDecode.DecodeBase64(ConfigurationManager.ConnectionStrings[key].ConnectionString)); //return ConfigurationManager.ConnectionStrings[key].ConnectionString; } return(string.Empty); }