有一个如下格式的xml:
<?xml version="1.0" standalone="yes" ?>
- <DATAPACKET Version="2.0">
- <METADATA>
- <FIELDS>
<FIELD attrname="GTHCODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="RECDATE" fieldtype="dateTime" />
<FIELD attrname="ICN" fieldtype="string" WIDTH="16" />
<FIELD attrname="TIM" fieldtype="string" WIDTH="14" />
<FIELD attrname="CARDTYPE" fieldtype="string" WIDTH="2" />
<FIELD attrname="VEHICLE_CODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="SAM" fieldtype="string" WIDTH="8" />
<FIELD attrname="DSN" fieldtype="r8" />
<FIELD attrname="SUBORGAN_CODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="LINE_ID" fieldtype="string" WIDTH="5" />
<FIELD attrname="STAFF_ID" fieldtype="string" WIDTH="10" />
<FIELD attrname="ST_CODE_CODE" fieldtype="string" WIDTH="9" />
</FIELDS>
<PARAMS LCID="1033" />
</METADATA>
- <ROWDATA>
<ROW GTHCODE="00010000" RECDATE="20080117" ICN="91001917"
TIM="20080126051641" CARDTYPE="91" VEHICLE_CODE="123" SAM="00000051"
DSN="000001" SUBORGAN_CODE="00010401" LINE_ID="00810" STAFF_ID="10000"
ST_CODE_CODE="010030020" />
</ROWDATA>
</DATAPACKET>本人想读取内容到dataTable里,该如何处理,请大家帮忙。本人是刚做项目的?
先谢谢。
<?xml version="1.0" standalone="yes" ?>
- <DATAPACKET Version="2.0">
- <METADATA>
- <FIELDS>
<FIELD attrname="GTHCODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="RECDATE" fieldtype="dateTime" />
<FIELD attrname="ICN" fieldtype="string" WIDTH="16" />
<FIELD attrname="TIM" fieldtype="string" WIDTH="14" />
<FIELD attrname="CARDTYPE" fieldtype="string" WIDTH="2" />
<FIELD attrname="VEHICLE_CODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="SAM" fieldtype="string" WIDTH="8" />
<FIELD attrname="DSN" fieldtype="r8" />
<FIELD attrname="SUBORGAN_CODE" fieldtype="string" WIDTH="8" />
<FIELD attrname="LINE_ID" fieldtype="string" WIDTH="5" />
<FIELD attrname="STAFF_ID" fieldtype="string" WIDTH="10" />
<FIELD attrname="ST_CODE_CODE" fieldtype="string" WIDTH="9" />
</FIELDS>
<PARAMS LCID="1033" />
</METADATA>
- <ROWDATA>
<ROW GTHCODE="00010000" RECDATE="20080117" ICN="91001917"
TIM="20080126051641" CARDTYPE="91" VEHICLE_CODE="123" SAM="00000051"
DSN="000001" SUBORGAN_CODE="00010401" LINE_ID="00810" STAFF_ID="10000"
ST_CODE_CODE="010030020" />
</ROWDATA>
</DATAPACKET>本人想读取内容到dataTable里,该如何处理,请大家帮忙。本人是刚做项目的?
先谢谢。
doc.Load("xml文件路径");
XmlNode child = doc.SelectSingleNode("/METADATA/FIELDS");
if (child != null) {
XmlNodeReader nr = new XmlNodeReader(child );
while (nr.Read() )
//执行到此将读到的东西加到一个字符序列对象里面
//然后依据一定的格式填充datatable
}