获取XML流并将其放入数据表中 [英] Getting an XML stream and putting it into a datatable
本文介绍了获取XML流并将其放入数据表中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我写了这段代码,但是我遇到了从服务器收到的XML问题。
我得到一个例外:
DataTable不支持来自Xml的架构推断
我的代码到目前为止:
HttpWebResponse oResp =(HttpWebResponse)myReq.GetResponse(); |
StreamReader oResultSR = new 的StreamReader(oResp.GetResponseStream(),编码); |
XmlReader reader = XmlReader 。创建(oResultSR); |
DataSetXL.Tables [a] .ReadXml(reader); |
oResultSR.Close(); |
oResp.Close(); |
XmlWriter writer = XmlWriter 。创建(@" C:\ file.xml" ); |
DataSetXML.Tables [a] .WriteXml(writer); |
writer.Close(); |
解决方案
您可以尝试以下选项
- 而不是使用DataTable的ReadXml方法使用Dataset的ReadXml方法。
- 使用ReadXml也调用包含xml文件的XSD的ReadXmlSchema方法
您还可以参考以下主题
Hi all,
I've written this code but I am having problems with the XML I receive from the server..
I get an exception:
DataTable does not support schema inference from Xml
my code so far:
HttpWebResponse oResp = (HttpWebResponse)myReq.GetResponse(); |
StreamReader oResultSR = new StreamReader(oResp.GetResponseStream(), encoding); |
XmlReader reader = XmlReader.Create(oResultSR); |
DataSetXL.Tables[a].ReadXml(reader); |
oResultSR.Close(); |
oResp.Close(); |
XmlWriter writer = XmlWriter.Create(@"C:\file.xml"); |
DataSetXML.Tables[a].WriteXml(writer); |
writer.Close(); |
解决方案
You can try following options
- Instead of using ReadXml method of DataTable use ReadXml method of Dataset.
- With ReadXml also call ReadXmlSchema method containing xml file's XSD
You can also refer following threads
这篇关于获取XML流并将其放入数据表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文