DataTable到Xdocument自定义 [英] DataTable to Xdocument Custom

问题描述

我有一个如下所示的数据表

i have a datatable that looks like the following

type                cname   ctable      text          allowgroupping
StringFilter         AAA     Table1      Good,Bad      Yes
StringFilter         BBB     Table2      Ugly          No
StringFilter         CCC     Table3      Lucky         Yes

然后我要从该表中生成以下XML

and from that table i want to produce the following XML

<Filters Date ="25.07.2012 22:50">
<StringFilter cname="AAA" ctable="Table1" allowgroupping="Yes">Good,Bad</StringFilter>
<StringFilter cname="BBB" ctable="Table2" allowgroupping="No">Ugly</StringFilter >
<StringFilter cname="CCC" ctable="Table3" allowgroupping="Yes">Lucky</StringFilter >
</Filters>

• 类型列代表标签
• cname，ctable和allowgroupping是属性
• 列文字代表内部文字

您能帮我使用linq和xDocument实现这一点吗?

can you please help me achive this using linq and xDocument?

推荐答案

添加对System.Data.DataSetExtensions

using System.Data.DataSetExtensions;

var XDocument doc = new XDocument();
var root =  new XElement("Filters");

var items = dt.Rows.AsIEnumberable().Select(row=> new XElement("StringFilter",             new XAttribute("cname",(string) row["cname"]),
    /*additional attributes here*/
     (string) row["text"]  ));

root.Add(items);
doc.Add(root);

这篇关于DataTable到Xdocument自定义的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！