ÏÖÓÐÒ»¸öxmlÎļþ£º
<?xml version="1.0" encoding="utf-16"?>
<componentDocuments>
<componentDocument Version="1.0">
<header>
<flow ID="GOGOGO" nodeID="Begin" &g ......
ÏÖÔÚ¿ªÔ´µÄcube xmlÉè¼ÆÆ÷ÓÐÄÄЩ°¡£¬ÎÒÖªµÀÒ»¸öschema workbench,µ«Õâ¸öÉè¼ÆÆ÷¹¦ÄÜÌ«¼òµ¥¡£
ÎÒÏ£ÍûÕÒµ½Ò»¸ö¹¦ÄܶàЩ¡£ÓÐËÖªµÀÂð£¿
BIµÄ¶«Î÷£¬Ñ§Ï°£¬°ï¶¥...
SQL code:
²»¶®£¬°ï¶¥£¬Ñ§Ï°£¬²ä·Ö.
ÎÒÃÇÏÖÔÚÏë×öÒ»¸öÉè¼ÆÆ÷£¬Ä¿µÄÊÇ·½±ã¿ì½Ý£¬¶øÇÒÏ£ÍûÓû§ÄÜ×Ô¼º¶¨ÖÆcube xml¡£Òò´ËÐèÒªÒ»¸ö¹¦ÄÜÍêÉÆµÄ¿ªÔ´µÄÉ ......
ÈçÌ⣬лл¸÷λ£¡
C# code:
private DataSet ConvertXmlToDataSet(string xmlPath)
{
DataSet mySet = new DataSet();
XmlDocument xdoc = new XmlDocument();
xdoc.Load(xmlPath);
XmlNodeReader reader = new XmlNodeReader(xdoc);
mySet.ReadXml(reader);
......
ÏÖÓÐÒ»¸öxmlÎļþ£º
<?xml version="1.0" encoding="utf-16"?>
<componentDocuments>
<componentDocument Version="1.0">
<header>
<flow ID="GOGOGO" nodeID="Begin" & ......
ÔXMLÎļþ
<?xml version="1.0" encoding="GB2312"?>
<catalog>
<cd>
<title>Empire Burlesque </title>
<typeid>001 </typeid>
&nbs ......
Èç <people>
<name is="123">yangchao </name>
.....
</people>
ÎÒѡȡ <people>Ϊ½Úµã£¬ÏÖÔÚÏë·ÃÎÊis="123",ÓÃASPÔõôʵÏÖ£¿ÎÒÖªµÀÈç¹û·ÃÎÊ <people>µÄ½ÚµãÊôÐÔÊÇxml.getAttribute("is"),µ«ÊÇÎÒÏÖÔÚÏë·ÃÎÊ <nam ......