若没有指定连接数据库字符串,则使用该连接,
从下面config.xml中读取数据库连接信息。
config.xml中格式大体如下。
<set>
<setting id ="default">
<server>175.15.5.96</server>
<user>sa</user>
<password>root</password>
<database>test</database>
</setting>
</set>
从下面config.xml中读取数据库连接信息。
config.xml中格式大体如下。
<set>
<setting id ="default">
<server>175.15.5.96</server>
<user>sa</user>
<password>root</password>
<database>test</database>
</setting>
</set>
、XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(Server.MapPath("config.xml"));
XmlNodeList xnl = xmlDoc.SelectNodes("set/setting");
foreach (XmlNode linkNode in xnl)
{
XmlElement xe = (XmlElement)linkNode;//将子节点类型转换为XmlElement类型
string aa = xe.SelectSingleNode("server").InnerText.Trim();
string bb = xe.SelectSingleNode("user").InnerText.Trim();
}
数据库类百度搜一个。
{
string str = File.ReadAllText("D:\\1.txt",Encoding.Default);
return Regex.Match( Regex.Replace(str, @"<(\w+)>([^<]+)</\1>\s*", "$1=$2;"),@"(\S+?;)+").Value;
}
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="connString" value="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=ACS502-ROCKY"/>
</appSettings>
</configuration>在代码中引用using System.Configuration;
OleDbConnection conn = null;
if(conn.ConnectionString=="")
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(Server.MapPath("config.xml"));
XmlNodeList xnl = xmlDoc.SelectNodes("set/setting");
foreach (XmlNode linkNode in xnl)
{
XmlElement xe = (XmlElement)linkNode;//将子节点类型转换为XmlElement类型
string aa = xe.SelectSingleNode("server").InnerText.Trim();
string bb = xe.SelectSingleNode("user").InnerText.Trim();
}}else
{
conn.ConnectionString=ConfigurationSettings.AppSettings["connString"];
}