ASP»ñÈ¡ÏÂÀ¿òÖÐÖµµÄÎÊÌâ - Web ¿ª·¢ / ASP
ÎÒÏë»ñµÃÏÂÀ¿òÀïÃæµÄÖµ¿ÉÊÇ×ÜÊÇ»ñµÃ×îºóÒ»¸ö
´úÂëÈçÏ£º
<select name="select19" id="select19" onchange="javascript:form.submit()">
<option selected="selected" value="0">ÇëÑ¡Ôñ</option>
<%
sql1="select brandName from brand GROUP BY brandName"
set rs1=UseDB.EditDB(sql1)
while not rs1.eof
brandName=rs1("brandName")
%>
<option value="<%=brandName%>"><%=brandName%></option>
<%
rs1.movenext
wend
set rs1=Nothing
%>
</select>
ÎÒÊÇÒª»ñµÃvalueÀïÃæµÄÖµ£¬Ò³ÃæÏÔʾµÄÖµÊǺõġ£
<%
sql1="select brandName from brand GROUP BY brandName"
set rs1=UseDB.EditDB(sql1)
do while not rs1.eof and rs1.bof
brandName=rs1("brandName")
%>
<option value="<%=brandName%>"><%=brandName%></option>
<%
rs1.movenext
loop
set rs1=Nothing
%>
</select>
²»Ðа¡Ðֵܣ¬ÄãÄÇÑùÁ¬¸öÖµ¶¼»ñÈ¡²»µ½ÁË
»òÕßÄÇλÐֵܰïæÖØÐÂдһ¸ö£¬Ð»Ð»ÁË
Óà DropDownList »ñÈ¡Öµ²»ºÜÈÝÒ×Âð£¿ÄãÊÇÓÃʲô¿Ø¼þ»ñÈ¡µÄ£¿
È¡Öµ£¿request("select19")È¡²»µ½Âð£¿
¿ÉÒÔÈ¡µ½Öµ£¬¿ÉÊÇ×ÜÊÇ×îºóÒ»¸öoptionµÄÖµ
onchange="javascript:form.submit()"ÕâÑùд£¬Ê×ÏȾͷ¸ÁËb/s±à³ÌµÄ´ó¼É£¬·þÎñÆ÷ºÍ¿Í»§¶Ë²»·Ö
Ó¦¸Ãµ÷ÓÃÒ»¸ö
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØдurl²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖص㣬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£
2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£
3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££»
vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......