David's Home

改web.config設定檔

以下是  更改web.config 程式
適用於  需要增加或修改資料庫連線設定等.....功能

    protected void Button1_Click(object sender, EventArgs e)
    {

        // 取 config 檔  
        string appconfigFile = AppDomain.CurrentDomain.SetupInformation.ConfigurationFile;
        // 利用 xml 讀取  
        XmlDocument cfg = new XmlDocument();
        cfg.Load(appconfigFile);

        //修改      
        string sConnString = null;
        XmlNodeList element = cfg.GetElementsByTagName("connectionStrings");
        XmlNode nodeParent = element.Item(0);
        XmlNode nodeChild = null;
        foreach (XmlNode node in nodeParent)
        {
            if (node.Attributes["name"].Value == "Local_tw")
            {
                //sConnString = node.Attributes["connectionString"].Value;
                nodeChild = node;
            }
        }

        ////  Host=192.168.1.100;Database=BizPortal_tw;User ID=root;Password=root;Unicode=true
        sConnString = "Host=" + host.Text.Trim() + ";" +
                      "Database=BizPortal_tw;User ID=" + rootid.Text.Trim() + ";" +
                      "Password=" + rootpwd.Text.Trim() + ";Unicode=true";

        nodeChild.Attributes["connectionString"].Value = sConnString;

        // 建立 <add key='FontColor' value='white' />  
        //XmlElement element = cfg.CreateElement("add");
        //////element.SetAttribute("name", "Local_tw");
        //////element.SetAttribute("connectionString", "Host=192.168.1.99;Database=BizPortal_en;User ID=root;Password=root;Unicode=true"); element.SetAttribute("providerName", "MySQLDirect .NET Data Provider");

        //////// 插入到 appSettings 裡  
        //////XmlElement root = cfg.DocumentElement;
        //////XmlNode AppSettingsNode = root.SelectSingleNode("//connectionStrings");
        //////AppSettingsNode.AppendChild(element);

        // 存檔  
        cfg.Save(appconfigFile);  

    }