Question

.net从Access提取数据写入XML

我想从ACCESS数据库读取数据然后输出一个XML文件，XML文件格式如下
<?xml version="1.0" encoding="utf-8"?>
<galleries>
<gallery>
<title>Russia</title>
<images>
<image src="galleries/Russia/Bridge.jpg">Bridge</image>
<image src="galleries/Russia/Dusk_at_the_river.jpg">Dusk at the river</image>
<image src="galleries/Russia/Glowing_river.jpg">Glowing river</image>

</images>
</gallery>
<gallery>
<title>Bands</title>
<images>
<image src="galleries/Bands/Tv_on_the_radio_London_3.jpg">Tv on the radio London 3</image>
<image src="galleries/Bands/Tv_on_the_radio_London_5.jpg">Tv on the radio London 5</image>
<image src="galleries/Bands/Tv_on_the_radio_London_6.jpg">Tv on the radio London 6</image>
<image src="galleries/Bands/Tv_on_the_radio_London_7.jpg">Tv on the radio London 7</image>
</images>
</gallery>

如何输出这样格式的XML，XML里的title是用户自己写的
因为数据库里的TITLE比较多，那么他是怎么分类整齐的写入XML文件呢

Answer 1

你可以把数据存放至dataset 然后利用dataset输出xml

追问

请问怎么操作。。。。刚入门

追答

datatable也可以
DataTable dt = new DataTable();//新建一个datatable
using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=cost.mdb;))//oledb连接access
OleDbCommand cmd = new OleDbCommand("select * from tableA", conn);//sql查询
OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
oda.Fill(dt);//填充至datatable
cmd.Dispose();
conn.Close();
dt.WriteXml(Server.MapPath("../xml/abc.xml"));写出xml

Answer 2

参见参考资料里的网址
根据自己的需要修改