数据表生成特定格式的xml

[wsxcy66668888]

从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式文件

<folder state="unchecked" label="全部">
　　<folder state="unchecked" isBranch="true" label="技术科" >
<folder state="unchecked" isBranch="false" label="张三" />
<folder state="unchecked" isBranch="false" label="李四" />
<folder state="unchecked" isBranch="false" label="王五" />
<folder state="unchecked" isBranch="false" label="赵六" />
......
　　</folder>
　　<folder state="unchecked" isBranch="true" label="生产科" >
<folder state="unchecked" isBranch="false" label="牛七" />
<folder state="unchecked" isBranch="false" label="马八" />
......
　　</folder>
......
</folder>

[wsxcy66668888]

从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式文件

<folder state="unchecked" label="全部">
　　<folder state="unchecked" isBranch="true" label="技术科" >
	<folder state="unchecked" isBranch="false" label="张三" />
	<folder state="unchecked" isBranch="false" label="李四" />
	<folder state="unchecked" isBranch="false" label="王五" />
	<folder state="unchecked" isBranch="false" label="赵六" />
        ......
　　</folder>
　　<folder  state="unchecked" isBranch="true" label="生产科" >
	<folder state="unchecked" isBranch="false" label="牛七" />
	<folder state="unchecked" isBranch="false" label="马八" />
        ......
　　</folder>
    ......
</folder>

[wsxcy66668888]

人员姓名节点应该缩进的

[wsxcy66668888]

<folder state="unchecked" label="全部">
　　<folder state="unchecked" isBranch="true" label="技术科" >
       <folder state="unchecked" isBranch="false" label="张三" />
       <folder state="unchecked" isBranch="false" label="李四" />
       <folder state="unchecked" isBranch="false" label="王五" />
       <folder state="unchecked" isBranch="false" label="赵六" />
        ......
　　</folder>
　　<folder  state="unchecked" isBranch="true" label="生产科" >
       <folder state="unchecked" isBranch="false" label="牛七" />
       <folder state="unchecked" isBranch="false" label="马八" />
        ......
　　</folder>
    ......
</folder>

[glassbody]

应该写一个类，写方法把表转换成xml的，具体方法我也记不清了，有时间给你查一下..

[shelless]

有个操作xml的类
好久没用了，说不清了。。

[wuyq11]

DataSet ds = new DataSet();
ds.WriteXml(@"C:\temp.xml");
或
XmlDocument xmlDoc=new XmlDocument();
xmlDoc.Load("a.xml");
XmlNode root=xmlDoc.SelectSingleNode("");

[jshi123]

	SqlDataAdapter da = new SqlDataAdapter();
	da.SelectCommand = new SqlCommand("select 部门,姓名 from tb order by 部门", conn);

	DataTable dt = new DataTable();
	da.Fill(dt);

	XmlDocument doc = new XmlDocument();

	XmlElement root = doc.CreateElement("folder");
	root.SetAttribute("state", "unchecked");
	root.SetAttribute("label", "全部");
	doc.AppendChild(root);

	XmlElement cur_dept = null;
	foreach (DataRow row in dt.Rows)
	{
		if (cur_dept == null || row["部门"] as string != cur_dept.GetAttribute("label"))
		{
			XmlElement dept = doc.CreateElement("folder");
			dept.SetAttribute("state", "unchecked");
			dept.SetAttribute("isBranch", "true");
			dept.SetAttribute("label", row["部门"] as string);
			root.AppendChild(dept);
			cur_dept = dept;
		}

		XmlElement employee = doc.CreateElement("folder");
		employee.SetAttribute("state", "unchecked");
		employee.SetAttribute("isBranch", "false");
		employee.SetAttribute("label", row["姓名"] as string);

		cur_dept.AppendChild(employee);
	}

	doc.Save(@"d:\test.xml");

[智者知已应修善业]

http://blog.csdn.net/xianfajushi/archive/2009/07/22/4371397.aspx