SQL code:
DECLARE @s VARCHAR(100)
SET @s='a,b,c,dd,ee,f,aa,a,aa,f'
SELECT b.v from
(SELECT CAST('<r>' + REPLACE(@s,',','</r><r>') + '</r>' AS XML) x) a
CROSS APPLY
(SELECT v=t.x.value('.','VARCHAR(10)') from a.x.nodes('//r') AS t(x) ) b
Õâ¸öµÄfcuandy ......
ÎÒÒª°ÑÒ»¸ömp3¸ñʽµÄÎļþÒÑÁ÷µÄÐÎʽ´æ´¢µ½xmlÖУ¬xmlÊÇÓбêÇ©µÄ£¬ËùÒÔ²»ÄÜÓöþ½øÖÆÁ÷£¬ÎÒ°ÑÒôƵÎļþ¶Á³Ébyte¡¾¡¿£¬È»ºóÓÃbase64±àÂë³Éstring£¬ÎÒÏë´æ´¢string£¬ÄÜ´æµ½ÎļþÖУ¬µ«ÊǶÁµÄʱºò²»ÄÜÈ«²¿¶Á³öÀ´£¬ÎªÊ²Ã´£¬Ö»ÄܶÁÎļþµÄÒ»²¿·Ö£¬ÇóÖú£¬Ð´³öÓõÄbufferedwriter£¬¶ÁÈëÓõÄbufferedreader£¬±àÂëÓõÄutr-8
°ï¶¥
......
ÎÒ´Óºǫ́·µ»ØµÄXMLÊÇÕâÑùµÄ
<root>
<area label="СÇøÒ»" dj="118.745056" bw="34.1158" />
<area label="СÇø¶þ" dj="118.755056" bw="34.116104" />
<area label="СÇøÈý" dj=&quo ......
<?xml version="1.0" encoding="gb2312" ?>
<property>
<a> <![CDATA[200]]> </a>
<b> <![CDATA[test]]> </b>
<c>300 </c>
</property>
ÓÐÒÔÉÏÒ»×éÊý¾Ý£¨Õâ¸öÊÇÓÉÁíÒ»¸ö´úÂëÉú³ÉºóµÄ½á¹û£¬ÓÉÓÚÄò ......
×î½üÔÚ¹¤×÷ÖÐÓöµ½Ò»¸öÎÊÌ⣺
ÏîÄ¿ÖÐÓкܶàxml´æµÄÊÇÊý¾Ý£¬Ò²ÓкܶàxslÀ´½âÎöxml µ«ÊÇxslûÓÐд¶ÔÓ¦µÄ½âÎöxmlÎļþ ÕâÈÃÎÒºÜÍ·Í´
ÎÒÖ÷ÒªÊÇÏëÎÊÏ xslÊÇÈçºÎÖ¸¶¨Æä½âÎöµÄxmlÎļþµÄ
ÊÇxmlÖ¸Ã÷½âÎöËûµÄxsl°É
ÔõôָÃ÷
HTML code:
<?xml-stylesheet href="test.xslt" type="text/xsl"?> ......
Çë½Ï´óÒ»¸öÎÊÌâ
¡¡¡¡±¾ÈËʹÓÃC#×öÒ»¸öWinForm¿Í·þϵͳ£¬ÆäÖÐijЩÉèÖñ£´æΪXMLÎļþ£¬ÏÖÔÚÓÐÎÊÌâÇë½Ì´ó¼Ò
¡¡¡¡ÎÒ´°ÌåµÄ×ó±ßʹÓÃÒ»¸öListBox¿Ø¼þ£¬ÓÃÀ´ÏÔʾÅäÖõıàºÅ£¬ÔÚ´°ÌåÓÒ±ßʹÓÃTextBox,rediocheck¿Ø¼þµÈ£®ÏÖÔÚʵÏÖ£¬µã±£´æʱ½«¸÷×ÔÐÅÏ¢±£´æXMLÎļþµÍÏ£®´ò¿ª´°Ìå²é¿´Ê±£¬µã×ó±ßµÄ±àºÅ£¬ÓұߵÄTextBoxµÈ¿Ø¼þÏÔÊ¾Ô ......