修改配置文件中的连接字符串

  /// <summary>
    /// 修改配置文件中的连接字符串
    /// </summary>
    /// <param name="server">服务器名称</param>
    /// <param name="userid">用户ID</param>
    /// <param name="password">密码</param>
    /// <param name="database">数据库名称</param>
    protected bool ReadXml(string server, string userid, string password, string database)
    {
        try
        {
            string sqlconstring = "Data Source=" + server + "; User ID=" + userid + "; Password=" + password + "; Initial Catalog=" + database;
            string path = HttpContext.Current.Server.MapPath("~/web.Config");
            System.Xml.XmlDocument doc = new System.Xml.XmlDocument();
            doc.Load(path);
            System.Xml.XmlNode node = doc.SelectSingleNode("configuration/connectionStrings/add");
            System.Xml.XmlElement eml = (System.Xml.XmlElement)node;
            eml.SetAttribute("connectionString", sqlconstring);
            doc.Save(path);
            return true;
        }
        catch
        {
            return false;
        }
    }

----------------------------------------------------------------------------

2012.12.13添加，修改WinForm的配置文件：

 public class AppSettings
    {
        public static string AppConfig()
        {
            return System.IO.Path.Combine(Application.StartupPath, "xx.exe.config");//xx.exe.config实际为app.config生成后文件
        }

        public static string GetValue(string appKey)
        {
            XmlDocument xDoc = new XmlDocument();
            try
            {
                xDoc.Load(AppSettings.AppConfig());
                XmlNode xNode = xDoc.SelectSingleNode("//appSettings");
                XmlElement xElem = (XmlElement)xNode.SelectSingleNode("//add[@key='" + appKey + "']");               
                if (xElem != null)
                    return xElem.GetAttribute("value");
                else
                    return "";
            }
            catch 
            {
                return "";
            }
        }

        public static void SetValue(string AppKey, string AppValue)
        {
            XmlDocument xDoc = new XmlDocument();
            xDoc.Load(AppSettings.AppConfig());
            XmlNode xNode = xDoc.SelectSingleNode("//appSettings");
            XmlElement xElem1 = (XmlElement)xNode.SelectSingleNode("//add[@key='" + AppKey + "']");                    
        
            if (xElem1 != null)
            {
                xElem1.SetAttribute("value", AppValue);
            }
            else
            {
                XmlElement xElem2 = xDoc.CreateElement("add");
                xElem2.SetAttribute("key", AppKey);
                xElem2.SetAttribute("value", AppValue);
                xNode.AppendChild(xElem2);
            }
            xDoc.Save(AppSettings.AppConfig());
        }
    }