关于读取xml问题！

Question

数据库有如下字段   Color    gs     gname      age
   red      ss      yd        10
   yellow   dd      gh        28
   black    aa      nh        17
   green    ds      xx        21怎么将数据读取后生成一个xml文件，xml格式：<?xml version="1.0" encoding="gb2312"?>
  <guestbook>
  <article Color="red">
    <gs>ss</gs>
    <gname>yd</gname>
    <age>10</age>
  </article>
  <article Color="yellow">
    <gs>dd</gs>
    <gname>gh</gname>
    <age>28</age>
  </article>
  <article Color="black">
    <gs>aa</gs>
    <gname>nh</gname>
    <age>17</age>
  </article>
  <article Color="green">
    <gs>ds</gs>
    <gname>xx</gname>
    <age>21</age>
  </article>
  </guestbook>请教！急用！！！

Answer 1

DataTable有WriteXml方法。直接指定路径即可。

Answer 2

能写个案例出来吗？我用dataset的WriteXml方法写出来XML数据如下<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <dtable>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B>&lt;demo Color="1" gs="1" gname="1         " url="1"/&gt;&lt;demo Color="2" gs="2" gname="2         " url="2"/&gt;&lt;demo Color="3" gs="3" gname="3         " url="3"/&gt;&lt;demo Color="4" gs="4" gname="4         " url="4"/&gt;&lt;demo Color="5" gs="5" gname="5         " url="5"/&gt;&lt;demo Color="6" gs="6" gname="6         " url="6"/&gt;&lt;demo Color="7" gs="7" gname="7         " url="7"/&gt;&lt;demo Color="8" gs="8" gname="8         " url="8"/&gt;&lt;demo Color="9" gs="9" gname="9         " url="9"/&gt;</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
  </dtable>
</NewDataSet>读取出来就成这个样子了！

Answer 3

试试
dataset.Table[0].WriteXml("路径");

Answer 4

你这样只能自己写 方法 操作xml 了
因为 有个属性列。 color 这个列比较特别循环数据 加xml 节点保存就行了
xmldocment
 此消息通过 【CSDN论坛 Winform测试版】 回复！
龙月.NET的博客

Answer 5

--> 测试数据：[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([Color] varchar(6),[gs] varchar(2),[gname] varchar(2),[age] int)
insert [TB]
select 'red','ss','yd',10 union all
select 'yellow','dd','gh',28 union all
select 'black','aa','nh',17 union all
select 'green','ds','xx',21select 
[Color] AS "@Color",
[gs],
[gname],
[age]
from [TB] for xml path('article'),Root('guestbook')/*
XML_F52E2B61-18A1-11d1-B105-00805F49916B
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<guestbook>
    <article Color="red">
        <gs>ss</gs>
        <gname>yd</gname>
        <age>10</age>
    </article>
<article Color="yellow"><gs>dd</gs><gname>gh</gname><age>28</age></article><article Color="black"><gs>aa</gs><gname>nh</gname><age>17</age></article><article Color="green"><(4 行受影响)*/
drop table TB

Answer 6

DataTable table = new DataTable();
table.Columns.Add(new DataColumn("color", typeof(string)));
table.Columns.Add(new DataColumn("gs", typeof(string)));            
table.Columns.Add(new DataColumn("gname", typeof(string)));
table.Columns.Add(new DataColumn("age", typeof(uint)));
table.TableName = "guestbook";
DataRow row = table.NewRow();
row["color"] = "red";
row["gs"] = "ss";
row["gname"] = "yd";
row["age"] = 10;
table.Rows.Add(row);
table.WriteXml("demo.xml");
貌似就多一行Element

Answer 7

好例子
 此消息通过 【CSDN论坛 Winform测试版】 回复！
龙月.NET的博客

Answer 8

测试结果<?xml version="1.0" standalone="yes"?>
<DocumentElement>
  <guestbook>
    <XML_F52E2B61-18A1-11d1-B105-00805F49916B>&lt;demo Color="1" gs="1" gname="1         " url="1"/&gt;&lt;demo Color="2" gs="2" gname="2         " url="2"/&gt;&lt;demo Color="3" gs="3" gname="3         " url="3"/&gt;&lt;demo Color="4" gs="4" gname="4         " url="4"/&gt;&lt;demo Color="5" gs="5" gname="5         " url="5"/&gt;&lt;demo Color="6" gs="6" gname="6         " url="6"/&gt;&lt;demo Color="7" gs="7" gname="7         " url="7"/&gt;&lt;demo Color="8" gs="8" gname="8         " url="8"/&gt;&lt;demo Color="9" gs="9" gname="9         " url="9"/&gt;</XML_F52E2B61-18A1-11d1-B105-00805F49916B>
  </guestbook>
  <guestbook>
    <color>red</color>
    <gs>ss</gs>
    <gname>yd</gname>
    <age>18</age>
  </guestbook>
</DocumentElement>

Answer 9

我电脑上<?xml version="1.0" standalone="yes"?>
<DocumentElement>
  <guestbook>
    <color>red</color>
    <gs>ss</gs>
    <gname>yd</gname>
    <age>10</age>
  </guestbook>
</DocumentElement>

Answer 10

直接一个sql语句，获取返回结果就OK了