下拉列表解决办法

<%
sql="select * from 产品表"
rs.open sql,conn,1,1
%>
<form>
<select name="xinghao">
<%do while not rs.eof%>
<option value="<%=rs("xinghao")%>"><%=rs("xinghao")%></option>
<%
rs.movenext
loop
%>
</select>
</form>