Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp sql²éѯÎÊÌâ - Web ¿ª·¢ / ASP

СµÜÓöµ½Ò»¸öÎÊÌ⣺
 ¾ÍÊÇÔÚÊý¾Ý²éѯʱËüÌáʾ ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£µ«ÊÇwhereºóÃæµÄ¶¼ÊÇÁ½¸ö¶¼ÊÇÊý×Ö°¡
ÎÒµÄÊý¾Ý¿âÊÇÈçÏÂͼ
ÎÒÊǶÔÕâ¸ö±í²éѯÁ½´Î ²¢ÇÒÊÇǶÌ׵ĴúÂë 

HTML code:
<div id=mulu >
<ul>
<%
sql="select * from p_class where parentid=0"
set rs=conn.execute(sql)
if rs.eof then
response.Write("ûÓÐĿ¼·ÖÀ࣬Çëµ½ºǫ́Ìí¼Ó")
else
do while not rs.eof %>
<li id=big><%=rs("class")%></li>
<%
sql2="select * from p_class where parentid='"&rs("id")&"'"
set rs2=conn.execute(sql2)
if rs2.eof then
else
do while not rs2.eof
%>
<li id=small><%=rs2("class")%></li>
<%
rs2.movenext
loop
end if
rs.movenext
loop
end if

%>
</ul>
</div>






ллyan11cn
 £¬Ð¡µÜ»ù´¡²»ÔõôºÃ£¬»¹Êǵúúò¹²¹


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

ASP ¡£NETÈçºÎÑ¡Ôñ - Web ¿ª·¢ / ASP

´ó¼ÒºÃ!ÎÒÊÇÒ»¸öѧÉú,ÏÖÔÚÊÇѧASPµÄ²»ÖªµÀÔõô»ØÊÂ,ÎÒ×Ô¼ºÊÇÓÃCMS×ö¹ýÍøÕ¾ ´úÂëÒ²ÄÜ¿´¶®Ò»µã ÏÖÔÚÏëÂò±¾Êé,Ïë·¨Óкܶà,¾ÍÊÇÏëÂòASPµÄ ÓÖ¿´µ½´ó¼Ò˵ASPÒÔºóûÓÐNETǰ¾°ºÃ,ÎÒÓÖÏëÔÙÈ¥Âò±¾ASP.NETµÄ ÎÒÖªµÀÓÐÕâÑùµÄÏë·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ