怎样把xml中的信息读取出来，存到datatable中？？

[StudyNetJava]

下面是xml中的内容，我想把section下的五个节点的内容读取出来，存到datatable中，应该怎么样做？？？

<ConfigRoot>
<Section>
<Name>SectionTest1</Name>
<Environments>Env1, Env2</Environments>
<SourceFolder>\\LocalMachine\Share\Test</SourceFolder>
<TargetFolder>\\OtherMachine\Share\Target</TargetFolder>
<TimeoutInSec>300</TimeoutInSec>
</Section>

<Section>
<Name>SectionTest2</Name>
<Environments>Env1, Env2</Environments>
<SourceFolder>\\LocalMachine\Share\Test</SourceFolder>
<TargetFolder>\\OtherMachine\Share\Target</TargetFolder>
<TimeoutInSec>300</TimeoutInSec>
</Section>

<Section>
<Name>SectionTest3</Name>
<Environments>Env1, Env2, Env3</Environments>
<SourceFolder>\\LocalMachine\Share\Test</SourceFolder>
<TargetFolder>\\OtherMachine\Share\Target</TargetFolder>
<TimeoutInSec>300</TimeoutInSec>
</Section>
</ConfigRoot>

[StudyNetJava]

引用 7 楼 u012597229 的回复:

private static DataSet ConvertXMLToDataSet(string xmlData) { StringReader stream = null; XmlTextReader reader = null; try { DataSet xmlDS = new DataSet(); stream = new StringReader(xmlData); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); return xmlDS; } catch (Exception ex) { string strTest = ex.Message; return null; } finally { if (reader != null) { reader.Close(); } } }

传入的xmlData是xml的路径？？？还是什么？？？

[特别]

引用 9 楼 qq_16256793 的回复:

[quote=引用 7 楼 u012597229 的回复:] private static DataSet ConvertXMLToDataSet(string xmlData) { StringReader stream = null; XmlTextReader reader = null; try { DataSet xmlDS = new DataSet(); stream = new StringReader(xmlData); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); return xmlDS; } catch (Exception ex) { string strTest = ex.Message; return null; } finally { if (reader != null) { reader.Close(); } } }

传入的xmlData是xml的路径？？？还是什么？？？[/quote] xmlData就是指你的XML内容 <ConfigRoot> <Section> <Name>SectionTest1</Name> <Environments>Env1, Env2</Environments> <SourceFolder>\\LocalMachine\Share\Test</SourceFolder> <TargetFolder>\\OtherMachine\Share\Target</TargetFolder> <TimeoutInSec>300</TimeoutInSec> </Section> <Section> <Name>SectionTest2</Name> <Environments>Env1, Env2</Environments> <SourceFolder>\\LocalMachine\Share\Test</SourceFolder> <TargetFolder>\\OtherMachine\Share\Target</TargetFolder> <TimeoutInSec>300</TimeoutInSec> </Section> <Section> <Name>SectionTest3</Name> <Environments>Env1, Env2, Env3</Environments> <SourceFolder>\\LocalMachine\Share\Test</SourceFolder> <TargetFolder>\\OtherMachine\Share\Target</TargetFolder> <TimeoutInSec>300</TimeoutInSec> </Section> </ConfigRoot>

[exception92]

http://blog.csdn.net/duanzi_peng/article/details/24018431 遍历集合，拼接datatable.

[lincolnandlinda]

为什么很多人都不会用Linq To Xml......

[娃都会打酱油了]

这个看起来不是标准的dataset转成的xml，否则的话可以直接转化回dataset

[StudyNetJava]

引用 1 楼 duanzi_peng 的回复:

http://blog.csdn.net/duanzi_peng/article/details/24018431 遍历集合，拼接datatable.

看了你的文章，也不是很懂

[StudyNetJava]

引用 3 楼 starfd 的回复:

这个看起来不是标准的dataset转成的xml，否则的话可以直接转化回dataset

这个是自己写的

[exception92]

引用 4 楼 qq_16256793 的回复:

[quote=引用 1 楼 duanzi_peng 的回复:] http://blog.csdn.net/duanzi_peng/article/details/24018431 遍历集合，拼接datatable.

看了你的文章，也不是很懂[/quote] 是，帮你把代码写出来你都懂了。

[走着看世界]

private static DataSet ConvertXMLToDataSet(string xmlData) { StringReader stream = null; XmlTextReader reader = null; try { DataSet xmlDS = new DataSet(); stream = new StringReader(xmlData); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); return xmlDS; } catch (Exception ex) { string strTest = ex.Message; return null; } finally { if (reader != null) { reader.Close(); } } }

[特别]

引用 7 楼 u012597229 的回复:

private static DataSet ConvertXMLToDataSet(string xmlData) { StringReader stream = null; XmlTextReader reader = null; try { DataSet xmlDS = new DataSet(); stream = new StringReader(xmlData); reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); return xmlDS; } catch (Exception ex) { string strTest = ex.Message; return null; } finally { if (reader != null) { reader.Close(); } } }

DataSet.ReadXml +1