/// <summary>
/// 改写数据库配置文件
/// </summary>
/// <param name="WebUrl">Web.config文件地址</param>
/// <param name="Sql">SQL语句调用名称</param>
/// <param name="SQLName">服务器名称</param>
/// <param name="DataName">数据库名称</param>
/// <param name="User">用户名</param>
/// <param name="Pass">密码</param>
public void SetWebconfig(string WebUrl, string Sql,string SQLName,string DataName,string User,string Pass)
{
XmlDocument xmldoc = new XmlDocument(); //初始化XmlDocument
xmldoc.Load(@WebUrl); //文件打开位置
XmlNodeList nodeList = xmldoc.SelectSingleNode("configuration").ChildNodes;//获取configuration节点的所有子节点
foreach (XmlNode xn in nodeList)//遍历所有子节点
{
XmlElement xe = (XmlElement)xn;//将子节点类型转换为XmlElement类型
if (xe.Name == "connectionStrings")//如果有节点的名称叫connectionStrings
{
XmlNodeList nls = xe.ChildNodes; //转换格式
foreach (XmlNode xn1 in nls)//遍历XmlNodeList
{
XmlElement xe3 = (XmlElement)xn1;//转换类型
if (xe3.Name == "add")//如果找到 Add节点
{
xe3.RemoveAllAttributes();//删除名下所有属性
//添加属性
xe3.SetAttribute("name", Sql);
//拼写SQL链接语句
string SQL = "Data Source=" + SQLName + ";Initial Catalog=" + DataName + ";Persist Security Info=True;User ID=" + User + ";Password=" + Pass;
xe3.SetAttribute("connectionString", SQL);
xe3.SetAttribute("providerName", "System.Data.SqlClient");
}
}
}
}
xmldoc.Save(@WebUrl);//保存文件
}
引用using System.Xml;
/// 改写数据库配置文件
/// </summary>
/// <param name="WebUrl">Web.config文件地址</param>
/// <param name="Sql">SQL语句调用名称</param>
/// <param name="SQLName">服务器名称</param>
/// <param name="DataName">数据库名称</param>
/// <param name="User">用户名</param>
/// <param name="Pass">密码</param>
public void SetWebconfig(string WebUrl, string Sql,string SQLName,string DataName,string User,string Pass)
{
XmlDocument xmldoc = new XmlDocument(); //初始化XmlDocument
xmldoc.Load(@WebUrl); //文件打开位置
XmlNodeList nodeList = xmldoc.SelectSingleNode("configuration").ChildNodes;//获取configuration节点的所有子节点
foreach (XmlNode xn in nodeList)//遍历所有子节点
{
XmlElement xe = (XmlElement)xn;//将子节点类型转换为XmlElement类型
if (xe.Name == "connectionStrings")//如果有节点的名称叫connectionStrings
{
XmlNodeList nls = xe.ChildNodes; //转换格式
foreach (XmlNode xn1 in nls)//遍历XmlNodeList
{
XmlElement xe3 = (XmlElement)xn1;//转换类型
if (xe3.Name == "add")//如果找到 Add节点
{
xe3.RemoveAllAttributes();//删除名下所有属性
//添加属性
xe3.SetAttribute("name", Sql);
//拼写SQL链接语句
string SQL = "Data Source=" + SQLName + ";Initial Catalog=" + DataName + ";Persist Security Info=True;User ID=" + User + ";Password=" + Pass;
xe3.SetAttribute("connectionString", SQL);
xe3.SetAttribute("providerName", "System.Data.SqlClient");
}
}
}
}
xmldoc.Save(@WebUrl);//保存文件
}
引用using System.Xml;