两个下拉菜单的二级联动
来源:互联网 发布:linux内核裁剪流程 编辑:程序博客网 时间:2024/04/29 11:23
<form name="form1" action="search.asp" method="post" >
请选择
<select name="selBigCategory" onChange="TypeChange(this);" >
<%m_SQL="Select ID,Value From CityType order by ID"
Set rs = conn.Execute(m_SQL)
mBigArray = rs.GetRows()
for i=0 to ubound(mBigArray,2)
m_SQL2="Select * From AreaType Where CityTypeID="&mBigArray(0,i)&" order by Grade"
Set rs = conn.Execute(m_SQL2)
strSmallCategory = mBigArray(0,i)&"-"
Do While not rs.Eof
strSmallCategory = strSmallCategory & rs("ID")&"+"&rs("Value")+"-"
rs.Movenext
Loop
Response.write "<option value="&strSmallCategory&">"&mBigArray(1,i)&"</option>"
next
%>
</select>
<script language="javascript">
function TypeChange(theSelect)
{
var sTemp,sString,i,sBigTypeID;
sValue=theSelect.value;
sSubTypeArray=sValue.split("-");
sBigTypeID = sSubTypeArray[0];
sString="<select name='TypeID'>";
sString+="<option value='"+sBigTypeID+":0'>全部</option>";
for(i=1;i<sSubTypeArray.length-1;i++)
{
sTemp=sSubTypeArray[i].split("+");
sString+="<option value='"+sBigTypeID+":"+sTemp[0]+"'>"+sTemp[1]+"</option>";
}
// sString+="<option value='"+sBigTypeID+":0'>全部</option>";
sString+="</Select>"
form1.TypeID.outerHTML=sString;
}
</script>
<select name="TypeID" >
</select>
<script language="javascript">TypeChange(form1.selBigCategory);</script>
</form>
请选择
<select name="selBigCategory" onChange="TypeChange(this);" >
<%m_SQL="Select ID,Value From CityType order by ID"
Set rs = conn.Execute(m_SQL)
mBigArray = rs.GetRows()
for i=0 to ubound(mBigArray,2)
m_SQL2="Select * From AreaType Where CityTypeID="&mBigArray(0,i)&" order by Grade"
Set rs = conn.Execute(m_SQL2)
strSmallCategory = mBigArray(0,i)&"-"
Do While not rs.Eof
strSmallCategory = strSmallCategory & rs("ID")&"+"&rs("Value")+"-"
rs.Movenext
Loop
Response.write "<option value="&strSmallCategory&">"&mBigArray(1,i)&"</option>"
next
%>
</select>
<script language="javascript">
function TypeChange(theSelect)
{
var sTemp,sString,i,sBigTypeID;
sValue=theSelect.value;
sSubTypeArray=sValue.split("-");
sBigTypeID = sSubTypeArray[0];
sString="<select name='TypeID'>";
sString+="<option value='"+sBigTypeID+":0'>全部</option>";
for(i=1;i<sSubTypeArray.length-1;i++)
{
sTemp=sSubTypeArray[i].split("+");
sString+="<option value='"+sBigTypeID+":"+sTemp[0]+"'>"+sTemp[1]+"</option>";
}
// sString+="<option value='"+sBigTypeID+":0'>全部</option>";
sString+="</Select>"
form1.TypeID.outerHTML=sString;
}
</script>
<select name="TypeID" >
</select>
<script language="javascript">TypeChange(form1.selBigCategory);</script>
</form>
- 两个下拉菜单的二级联动
- 基于Ajax的二级联动下拉菜单
- 基于Ajax的二级联动下拉菜单
- 二级联动下拉菜单写法
- ASP二级联动下拉菜单
- Yii二级联动下拉菜单
- PHP二级联动下拉菜单
- jquery二级联动下拉菜单
- 下拉菜单--二级联动菜单练习
- 基于Ajax(DWR)的二级联动下拉菜单
- javascript支持区号输入的省市二级联动下拉菜单
- 一个FLEX4 二级联动 下拉菜单的例子
- js关于省市的二级下拉菜单联动
- PHP&MySQL基于数据库的二级联动下拉菜单
- 一个简单的Ajax二级联动下拉菜单
- [js]实现简单的省市二级联动下拉选择菜单
- ajax无刷新二级联动下拉菜单
- 城市/区域 二级联动下拉菜单
- CUDA VS2005 Wizard
- 在java中如何约束条件限制文本框接受的字符
- Mysql 何去何从
- 使用C#创建Excel文档
- 使用Rome实现网站RSS发布的简单步骤
- 两个下拉菜单的二级联动
- 有史以来批处理最完整人性化教程1
- 使用C#创建Word文档
- swt中限制文本框接受的字符
- SSI--什么是SHTML?
- Concept-第9章翻译
- 使用exchange 和split partition 来将一个非分区表转换为分区表
- 一道IBM笔试题 按季度统计
- 倒水问题