°Ñ¶à´ÎµÄ²éѯ½á¹û±£´æµ½Ò»¸öXMLÎļþÀï
//Ñ»·Ìå
.................
.................
.................
SqlDataAdapter da = new SqlDataAdapter(select, connection);
DataSet ds = new DataSet();
da.Fill(ds, "stockup");
ds.WriteXml("write7.xml", XmlWriteMode.WriteSchema);
//Ñ»·½áÊø
ÔÚÑ»·ÌåÖÐÖ´ÐеÄÊÇSQL²éѯ
ÎÒÏë°Ñÿ´ÎµÄ²éѯ½á¹û¶¼±£´æµ½write7.xmlÖУ¬µ«ÊÇÏÖÔÚÖ»ÄܰÑ×îºóÒ»´ÎµÄ²éѯ½á¹û±£´æÏÂÀ´£¬Ç°ÃæµÄ²éѯ½á¹û¶¼±»¸²¸ÇÁË£¬Çë´óÏÀÃǰïæ½â´ð¡£
WriteXml(string, XmlWriteMode);Õâ¸öÊÇдÕû¸öxmlÎĵµµÄ£¬µ±È»ÊǸ²¸Ç°¡£¡
×Ô¼ºÐ´´úÂ룬ѻ·Ìí¼Óxml½Úµã~
ÏȰÑxmlÎļþ¶Áµ½Äڴ棬ÔÙÌí¼Ó½áµã£¬ÔÙ±£´æ¾ÍÐÐÁË
Â¥Éϼ¸Î»Äܸø³öÏêϸһµãµÄ´úÂëÂð£¿Ð»Ð»
C# code
<?xml version="." encoding="gb"?>
<bookstore>
<book genre="fantasy" ISBN="--">
<title>Oberon's Legacy </title>
<author>Corets, Eva </author>
<price>. </price>
</book>
</bookstore>
1¡¢Íù <bookstore>½ÚµãÖвåÈëÒ»¸ö <book>½Úµã£º
XmlDocument xmlDoc=new XmlDocument();
xmlDoc.Load(&
Ïà¹ØÎÊ´ð£º
ÈçºÎ¶ÔxmlÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......
ÒÑÖªÎļþ1.xmlºÍÊý¾ÝÎļþdb.xml£¬ÈçºÎÓÃjava±àд³ÌÐò£¬µÃ³ö2.xmlÎļþ£¿
1.ÒÑÖªxmlÎļþ 1.xml½á¹¹ÈçÏ£º
<cs>
<cs name="cs1" details="This is cs1" country="China&q ......
²ÉÓÃDOM ½øÐнâÎöxml¡£ÒªÇó½«xml×Ö´®²åÈëÖ¸¶¨½Úµã×÷ΪÆä×Ó½Úµã
±ÈÈ磺
Ôxml
<root>
</root>
Òª²åÈëµÄxml×Ö´®
<a>test</a>
Ä¿µÄxml£º
<root>
<a> ......
¡¶C#Èë޵䡷µÚÈý°æ£¨vs2005£©Ëµ±àдxmlºó¿ÉÒÔÓÒ»÷£¬Ñ¡view data grid£¬ÓÃÁбíÏÔʾÊý¾Ý¡££¨23.1.7½Ú£©
ÎÒÏÖÔÚÔÚÓÃvs2008£¬ÎÒÏàÐÅÕâ¸ö¹¦ÄÜÓ¦¸Ã»¹ÊÇÓе쬱»·Åµ½ÄĶùÈ¥ÁËÄØ£¿
ʵ¼ùһϾÍÖªµÀÀ²£¡
ÒýÓÃ
ʵ¼ùÒ»Ï ......
ÔÚSqlserverÊý¾Ý¿âNorthwindsÖд´½¨Ò»¸ö´æ´¢¹ý³Ì£¬
¸Ã´æ´¢¹ý³ÌÓÐÁ½¸ö²ÎÊý£¬nvarchar(5)ÀàÐ͵Ä@customerID ÊÇcustomers±íµÄcustomerID£¬ xmlÀàÐ͵IJÎÊý@xmlCustOrderÊÇÊä³ö²ÎÊý£¬´æ´¢¹ý³Ì½«¸ù¾ÝordersºÍcustomers ±í ......