<select name="type_select">
<option value="" selected>请选择关键字</option>
<%
set rc=server.createobject("ADODB.recordset")
rc.open "...",conn,3,1
for i=1 to rc.RecordCount
if rc.eof then
exit for
end if
%>
<option value="<%=rc("....")%>"><%=rc("....")%></option>
<%
rc.movenext
next
rc.close
set rc=nothing
conn.close
set conn=nothing
%>
</select>