Example #1
0
        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");
        }
Example #2
0
 /// <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);
 }