2.根據文本框輸入文本,進行提交,並且查詢得出結果寫入到Select中
Query.asp
<form name=frmQuery action="query.asp" method=post>
<input type=text name=txtQueryStr>
<input type=submit value=提交>
</form>
<select>
<%
On Error Resume Next
If Request.Form("txtQueryStr")<>"" Then
tmpQueryStr=Replace(Request.Form("txtQueryStr"),"'","''") '替換掉文本框中可能輸入的單引號
Set Conn=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open "Provider=SQLOLEDB.1;Data Source=server;DataBase=database;UID=uid;PWD=pwd;"
Rs.ActiveConnection=Conn
Rs.Source="Select * from 表名 Where 字段='" &tmpQueryStr& "'"
Rs.Open Rs.Source,Conn,1,1
While Not Rs.EOF
%>
<option value="<%=Rs("字段")%>"><%=Rs("字段")%></option>
<%
Rs.MoveNext
Wend
End If
If Err Then
Response.Write Err.Description
Response.End
End If
%>
</select>
1.Select選項從數據庫中查詢的出,已經固定,文本框中輸入值,如果與選項一致,則選中
Query.asp
<input type=text name=txtQueryStr>
<input type=button value=Query onclick="QuerySel()"
<select id=SelOption>
<%
On Error Resume Next
Set Conn=Server.CreateObject("ADODB.Connection")
Set Rs=Server.CreateObject("ADODB.RecordSet")
Conn.Open "Provider=SQLOLEDB.1;Data Source=server;DataBase=database;UID=uid;PWD=pwd;"
Rs.ActiveConnection=Conn
Rs.Source="Select * from 表名 Where 字段='字符串'"
Rs.Open Rs.Source,Conn,1,1
While Not Rs.EOF
%>
<option value="<%=Rs("字段")%>"><%=Rs("字段")%></option>
<%
Rs.MoveNext
Wend
If Err Then
Response.Write Err.Description
Response.End
End If
%>
</select>
<script language=JavaScript>
<!--
function QuerySel()
{
var a=document.getElementById("SelOption");
for (i=0;i<a.length;i++)
{
if(a.options[i].value==document.getElementById("txtQueryStr").value)
{a.selectedIndex=i;break;}
}
}
//-->
</script>