Êý¾Ý±íÉú³ÉÌØ¶¨¸ñʽµÄ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"
Ïà¹ØÎÊ´ð£º
ÄÄλ´ó¸çÓÐûÓÐASP.NETÖÐÀûÓÃCookiesʵÏÖÓû§×Ô¶¯µÇ¼µÄ´úÂë...ллÁË...Ô½ÏêϸԽºÃ....
ʲôÒâ˼£¿×Ô¶¯µÇ¼£¿
mark òÊÓÊÇ´æ´¢cookies ÎÒÒ²¶Ôcook±È½ÏÃÔºý ¹Ø×¢ÏÂ
¼ÈÈ»ÄãÖªµÀÓÃcookies×Ô¼º¶¯¶¯´óÄÔ¶àºÃ£¡ ......
֮ǰÓöµ½Ò»¸öÎÊÌâ¡£
ÓÚÊÇ×öÁËÒÔÏÂʵÑ飺
Ò³Ãæ¼ÓÔØºó£¬Ìá½»Ò»¸öAjaxÇëÇó(ÔݳÆÎªajax1)£¬ÇëÇóµÄÏß³ÌÔÚ·þÎñÆ÷Éϱ»Ë¯Ãß10ÃëÖÓ¡£
µã»÷Ò³ÃæÉÏÒ»¸öbutton£¬´¥·¢ÁíÒ»¸öAjaxÇëÇó(ajax2)¡£
µ±Ã»ÓÐʹÓÃsession£¬ÔÚ·þÎñÆ÷δ´ ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......