ASP 菜鸟测试版

来源:百度知道 编辑:UC知道 时间:2024/06/23 06:59:17
<%
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from khxx"
rs.Open sql,conn,1,1
%>
<td colspan="3" rowspan="2"><p>
<select name="select">
<% if rs.eof then%>
<% else %>
<option value=
<%
do while not rs.eof
%> selected <%if rs("kh_mc")=request("kh_mc") then%>seleced<%end if%>>请选择客户
<option value="gsxx.asp"><%=rs("kh_mc")%></option>
>
<%
rs.movenext
loop
%>
<% end if %>
</select>
<%
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from khxx"
rs.Open sql,conn,1,1
%>

下拉菜单读出数据,选择相应数据,那么下面的文本框内的数据如何才

<select name="select2">
<%
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from khxx"
rs.Open sql,conn,1,1
if not rs.eof and rs.bof then
do while not rs.eof
%>
<option value="gsxx.asp"><%=rs("kh_mc")%></option>
<%rs.movenext
loop
end if%>
</select>