XML配置文件

//配置文件

ConnectDatabase.xml

<?xml version="1.0" encoding="utf-8" ?>
<ConnectionSettings>
<!--连接本地数据库-->
<!--<ConnectionString>
Data Source = 本地服务器名;Initial Catalog = 数据库名; Integrated Security = true;
</ConnectionString>-->
<!--连接身份验证数据库-->
<!--<ConnectionString1>
Data Source=连接服务器名;Initial Catalog=数据库名;User ID=用户名;Password=用户密码
</ConnectionString1>-->
<!--连接内嵌数据库-->
<connectionStrings2>
Data Source = .\SQLEXPRESS;AttachDBFilename = |DataDirectory|\数据库名.mdf;Integrated Security = True;User Instance = True
</connectionStrings2>
</ConnectionSettings>

 

//使用配置文件连接数据库

XmlDocument xmlDoc = new XmlDocument();
SqlConnection con = new SqlConnection();
/// <summary>
/// 连接数据库字符串
/// </summary>
/// <returns>返回SqlConnection</returns>
public SqlConnection openDB()
{
//调用xml配置文件
xmlDoc.Load("XML/ConnectDatabase.xml");
XmlNode conNode = xmlDoc.SelectSingleNode("ConnectionSettings/connectionStrings2");
string str = conNode.InnerText;
con = new SqlConnection(str);
return con;
}