Ê÷ÐÍÊý¾Ý¸ñʽΪXMLÊý¾Ý
±ÈÈç
SQL code:
id pid name
1 null a
2 1 a1
3 null b
4 3 b1
5 4 b11
6 3 b2
....
µÈ·ñµÃ³öÈçϸñʽµÄXML£¿
SQL code:
<item id='1' text='a'>
<item id='2' text='a1'></item>
</item>
<item id='3' text='b'>
<item id='4' text='b1'>
<item id='5' text='b11'></item>
</item>
<item id='6' text='b2'></item>
</item>
....
Çë¸÷λ´óÏÀ°ï°ï棬лл
SQL code:
-- µ¼ÈëÈ¥ÖØ, last() , position()
DECLARE @doc xml
SET @doc ='<?xml version="1.0" encoding="gb2312" ?>
<employees>
<employee>
<empid>e0001</empid>
<name>Ïô·å</name>
</employee>
<employee>
<empid>e0002</empid>
<name>¶ÎÓþ</name>
</employee>
<employee>
<empid>e0003</empid>
<name>ÍõÓïæÌ</name>
</employee>
<employee>
<empid>e000
Ïà¹ØÎÊ´ð£º
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
½ñÌìÓöµ½Ò»¸öÎÊÌ⣬°ÑxmlÖеÄÖµ×°µ½.txt¸ñʽµÄÎļþÖС£
ÎÒÄ¿Ç°Ïëµ½Á½ÖֱȽϱ¿µÄ·½·¨£º1.¿ÉÒÔͨ¹ýxmlspy±à¼¹¤¾ßʵÏÖ
2.ͨ¹ý°Ñxmlת³ÉJavabean£¬È»ºóתµ½excelÖУ¬ÔÙ´Óб£´æÖØÃüÃûΪ. ......
ÈçºÎ¶ÔxmlÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
¡¶C#Èë޵䡷µÚÈý°æ£¨vs2005£©Ëµ±àдxmlºó¿ÉÒÔÓÒ»÷£¬Ñ¡view data grid£¬ÓÃÁбíÏÔʾÊý¾Ý¡££¨23.1.7½Ú£©
ÎÒÏÖÔÚÔÚÓÃvs2008£¬ÎÒÏàÐÅÕâ¸ö¹¦ÄÜÓ¦¸Ã»¹ÊÇÓеģ¬±»·Åµ½ÄĶùÈ¥ÁËÄØ£¿
ʵ¼ùһϾÍÖªµÀÀ²£¡
ÒýÓÃ
ʵ¼ùÒ»Ï ......