三级下拉框连动
'
'数据库：
'location
'表1 loaction 所在地表
' 字段
' loactionid
' loactionname 名字
'表2 district 所在的地区表
' 字段
' locationid
' districtid
' districtname
'表3 village 所在的县区表
' 字段
' districtid
' villageid
' villagename
<%Option Explicit%>
List <%
dim conn
dim rs
dim sql
dim count
dim rs1
dim sql1
dim rs2
dim sql2
dim count2
set conn=server.createobject("adodb.connection")
conn.open"provider=sqloledb;data source=192.168.0.33;uid=sa;pwd=;database=location;"
sql = "select * from district order by locationid asc"
set rs = conn.execute(sql)
%>
<%sql2 = "select * from village order by districtid asc"
set rs2 = conn.execute(sql2)
%>
