关于XML的数据库配置文件

Question

DataSet ds=new DataSet();
ds.ReadXml(m_DataPath + "Conn.xml");

Answer 1

<?xml version="1.0" encoding="utf-8" ?>
<NewDataSet>
<dataconfig>
<userid>sa</userid>
<password></password>
<database>sxcjwdata</database>
<server>yan</server>
</dataconfig>
</NewDataSet>

Answer 2

public void DataOpen()
{
string xmlfilename,userid,password,database,server;
xmlfilename=Server.MapPath("dataconfig.xml");
DataSet myDs=new DataSet();
myDs.ReadXml(xmlfilename);
DataRow myDataRow=myDs.Tables[0].Rows[0];
userid=myDataRow["userid"].ToString();
password=myDataRow["password"].ToString();
database=myDataRow["database"].ToString();
server=myDataRow["server"].ToString();
sqlString="user id="+userid+";password="+password+";database="+database+";server="+server;
dataConn.ConnectionString=sqlString;
dataConn.Open();
} public void DataClose()
{
dataConn.Close();
}

Answer 3

可以在web.config配制撒
<?xml version="1.0" encoding ="gb2312"?>
<configuration>
<appSetting>
<add key="dsn" value="连接字符串"/><appSetting></configuration>
然后在程序中加入一下代码就可以了：
using System.Configuration
 
sting conn=ConfigurationSettings.appSettings["dsn"];