28,409
社区成员




'先查詢選定值
<%
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT depart FROM [depart]", conn,1,1
do while not rs.eof
%>
<select id="depart" >
<option value="<%=rs("depart")%>"><%=rs("depart")%></option>
</select>
<%
rs.MoveNext
loop
rs.close
conn.close
%>
'後獲取保存
<%
dim depart
depart=request.form("depart")
sql="insert into [depart] (depart) values('"&depart&"')"
%>