Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄxml - .NET¼¼Êõ / ASP.NET
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBranch="true" label="¼¼Êõ¿Æ" >
<folder state="unchecked" isBranch="false" label="ÕÅÈý" />
<folder state="unchecked" isBranch="false" label="ÀîËÄ" />
<folder state="unchecked" isBranch="false" label="ÍõÎå" />
<folder state="unchecked" isBranch="false" label="ÕÔÁù" />
......
¡¡¡¡</folder>
¡¡¡¡<folder state="unchecked" isBranch="true" label="Éú²ú¿Æ" >
<folder state="unchecked" isBranch="false" label="Å£Æß" />
<folder state="unchecked" isBranch="false" label="Âí°Ë" />
......
¡¡¡¡</folder>
......
</folder>
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBranch="true"
Ïà¹ØÎÊ´ð£º
ÎÒÔÚºǫ́µ÷ÓÃJavaScriptµÄʱºò£¬ËûÊÇÔÚºǫ́°ÑʼþµÄ´úÂëÖ´ÐÐÒ»´ÎºóÔÚÖ´ÐÐJavaScript·½·¨
ÓÐʲô°ì·¨ ÔÚÖ´ÐÐJavaScript·½·¨µÄʱºòͣס£¬ÔÚÖ´ÐкóÃæµÄ´úÂë
²»Ì«Ã÷°×°¡£¬ËµÇå³þµã°É
¾ÍÊÇÖ´Ðкǫ́´úÂëµÄʱºò ......
asp.net ajaxÖÐupdatepanelÀïÃæµÄ¿Ø¼þÀïÃæÓиöbuttonºÍÈô¸Étextbox
ÎÒµã»÷buttonÑéÖ¤ÐÅÏ¢³öÏÖ£¬µ«ÊǾÍÊÇÎÞ·¨À¹½ØÎÒbuttonºóÃæÔËÐеÄʼþ£¡
ÑéÖ¤µÄ´úÂëÊÇJSÑéÖ¤»¹ÊÇ.netÖеÄÑéÖ¤¿Ø¼þ£¬»òÊǰ´Å¥Ê¼þÖеĺǫ́ÑéÖ¤£¿
......
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......
ÈçºÎ¶ÔxmlÄÚÈÝÊý¾Ý½øÐбȽÏ
ÀýÈ磺
<?xml version='1.0' encoding='utf-8'?>
<TestLIST>
<PID>40</PID>
<TestName>ÉîÛÚÊÐ</TestName>
......