XML读取到datatable中

[chengli8710yea]

<?xml version="1.0" encoding="gb2312" ?>
<DOCUMENT>
<QUERYORDER>
<MERCHANTID>105420173995066</MERCHANTID>
<BRANCHID>420000000</BRANCHID>
<POSID>381450994</POSID>
<ORDERID>S111008183528687</ORDERID>
<ORDERDATE>2011-10-08 18:36:05</ORDERDATE>
<AMOUNT>1.00</AMOUNT>
<STATUS>成功</STATUS>
<REFUND>0.00</REFUND>
<ACCTYPE>12</ACCTYPE>
<SIGN>yyy</SIGN>
</QUERYORDER>
<QUERYORDER>
<MERCHANTID>105420173995066</MERCHANTID>
<BRANCHID>420000000</BRANCHID>
<POSID>381450994</POSID>
<ORDERID>S111008192748013</ORDERID>
<ORDERDATE>2011-10-08 19:28:50</ORDERDATE>
<AMOUNT>1.00</AMOUNT>
<STATUS>成功</STATUS>
<REFUND>0.00</REFUND>
<ACCTYPE>14</ACCTYPE>
<SIGN>xxx</SIGN>
</QUERYORDER>
</DOCUMENT>

小弟拜求各位大侠帮忙将此XML字符串读取到DATATABLE或者LIST中，谢谢！

[chengli8710yea]

大侠们的方法我都试了，但是报错，错误如下：
System.Xml.XmlException: Unexpected XML declaration. The XML declaration must be the first node in the document, and no white space characters are allowed to appear before it. Line 4, position 3.

我是远程抓取XML的数据，然后存入到DATATABLE或者LIST里面，XML字符串是抓取到了，但就是转换的时候出错

[孟子E章]

上面的错误是说你得到的不是合法的 xml文件

[chengli8710yea]

那怎么解决啊，求大侠详解

[孟子E章]

你先看你远程抓取回来的数据是什么样子的啊。你看看是否符合xml的格式要求啊

[弦弦]

            IList<xmlModel> list = new List<xmlModel>();
            try
            {
                doc.Load(mapPath);
                XmlNodeList nodelist = doc.GetElementsByTagName("QUERYORDER");
                foreach (XmlNode var in nodelist)
                {
                    xmlModel mode = new xmlModel();
                    mode.Id = var.Attributes["MERCHANTID"].InnerText.ToString();
                    mode.Pwd = var.Attributes["BRANCHID"].InnerText.ToString();
                    mode.Ip = var.Attributes["POSID"].InnerText.ToString();
                    ....
                    list.Add(mode);
                }
            }

[1800包吃包住]

DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("TEXT.xml"));

最简单的读取到DataSet中!!!

[酷儿]

2楼正解 楼主没事应该多度娘一下

[chengli8710yea]

我得到的是一个XML字符串，ds.ReadXml()行得通？

[1800包吃包住]

string XML=@"<userinfo>
<distinguishedName><![CDATA[CN=ss,OU=smop开发组,OU=内容管理平台研发组,OU=技术支持中心,OU=技术部,OU=IFENGUSERS,DC=staff,DC=ifeng,DC=com]]></distinguishedName>
<department><![CDATA[流媒体技术组]]></department>
<sn><![CDATA[aa]]></sn>
<givenName><![CDATA[]]></givenName>
<mail><![CDATA[[e-mail]]]></mail>
<cn><![CDATA[aa]]></cn>
<company><![CDATA[ccc]]></company>
<userPrincipalName><![CDATA[[e-mail]]]></userPrincipalName>
<sAMAccountName><![CDATA[luoy]]></sAMAccountName>
<sAMAccountType><![CDATA[805306368]]></sAMAccountType>
</userinfo>";
string SN = "";
string Email = "";
XElement xl = XElement.Parse(XML);
foreach (XElement xll in xl.Elements())
{
if (xll.Name == "sn")
{
SN= xll.Value;
}
if (xll.Name == "mail")
{
Email= xll.Value;
}
}

这是我解析一个XML字符串的
你可以学下！！！

[挨踢直男]

        string xml = "你的xml字符串";
        DataSet ds = new DataSet();
        MemoryStream ms = new MemoryStream();
        StreamWriter wr = new StreamWriter(ms);
        wr.Write(xml);
        wr.Flush();
        ms.Seek(0, SeekOrigin.Begin);
        ds.ReadXml(ms);
        DataTable dt = ds.Tables[0];