XML ´æ´¢º¯Êý
ÔÚSqlserverÊý¾Ý¿âNorthwindsÖд´½¨Ò»¸ö´æ´¢¹ý³Ì£¬
¸Ã´æ´¢¹ý³ÌÓÐÁ½¸ö²ÎÊý£¬nvarchar(5)ÀàÐ͵Ä@customerID ÊÇcustomers±íµÄcustomerID£¬ xmlÀàÐ͵IJÎÊý@xmlCustOrderÊÇÊä³ö²ÎÊý£¬´æ´¢¹ý³Ì½«¸ù¾ÝordersºÍcustomers ±íÊä³öÌõ¼þΪ¸ÃcustomerIDµÄ¿Í»§ºÍ¶©µ¥ÐÅÏ¢xmlÊä³öµ½@xmlCustOrder£¬@xmlCustOrderµÄxml¸ñʽÈçCustOrderProc2.xml
Ëùʾ¡£
CustOrderProc2.xml
<CustomerOrders>
<Customers>
<CustomerID>ALFKI</CustomerID>
<CompanyName>Alfreds FutterkisteAbbc</CompanyName>
<Country>Germany</Country>
<Orders>
<OrderID>10643</OrderID>
<CustomerID>ALFKI</CustomerID>
<OrderDate>1997-08-25T00:00:00+08:00</OrderDate>
</Orders>
</Customers>
</CustomerOrders>
ÒªÇóÊäÈë¹ý³Ì ProcCustomerOrderXml2120061101245
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
ÈçºÎ¶ÔxmlÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......
ÈçÌâ
ÎÒÕâѧÆÚÑ¡µÄ¿ÎÌâÊÇÕâ¸öµ«ÊDz»ÖªµÀ¸ÃÔõô׼±¸£¬µ¼Ê¦Ò²Ã»Ôõô˵Çå³þ£¬Ï£Íû¸÷λ´ïÈËÄÜÖ¸µãÒ»¶þ£¬Ð¡µÜÔÚÕâл¹ýÀ²£¡
ллÄã £¬ÎÒÏÖÔÚÒ²×Ô¼º¿´×ÊÁÏÕûÀíË¼Â·ÄØ£¬¾ßÌåµÄ»¹ÒªÒ»µãʱ¼ä¡£
ÒýÓÃ
˼·ÈçÏ£º
ʹÓà ......
<?xml version="1.0"?>
<root>
<status>433</status>
<msg>Õâ¸öÊǺº×Ö</msg>
<serialno>123</serialno>
</root>
ÈçºÎÓÃASP¶ÁÈ¡ statusÖµ ......
string b = "";
b = System.Guid.NewGuid().ToString();//»ñµÃ»á»°ID
//дXML
XmlDocument xml = new XmlDocumen ......