关于asp的一个小问题

dogboxr 2003-12-25 04:58:06
我在sub里写了一个 下拉

'选择栏目上下级
sub car_Select(Name)
'Response.Write "<Select Name='"&Name&"'>"
set ljx=server.CreateObject("ADODB.RECORDSET")
ljx.Open "select distinct c_changjia from car",conn,1,1
Do while not ljx.eof
Response.Write "<Option value='"&ljx("c_changjia")&"' "&selected(ljx("c_changjia"))&">"&ljx("C_changjia")&"</option>"
ljx.movenext
Loop
ljx.close
set ljx=Nothing
'Response.Write "</Select>"
end sub

'选择栏目上下级
sub car_Select1(car,Name)
Response.Write "<Select Name='"&Name&"'>"
set ljx=server.CreateObject("ADODB.RECORDSET")
ljx.Open "select distinct c_carxi from car",conn,1,1
Do while not ljx.eof
Response.Write "<Option value='"&ljx("c_carxi")&"' "&selected(ljx("c_carxi"))&">"&ljx("C_carxi")&"</option>"
ljx.movenext
Loop
ljx.close
set ljx=Nothing
Response.Write "</Select>"
end sub


'select 选定函数
function selected(char1)
if trim(char1)<>"" then
selected=" selected"
else
selected=""
end if
end function
我想在选择第一个下拉框的时候 第二个下拉框的下拉列表的值可以变
...全文
38 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
nchen123 2003-12-25
  • 打赏
  • 举报
 回复
上面这两个文件你只要按我写的文件名保存到同一个目录就行了， 不会 xml 也没关系的。
你能看懂就行了。

如果用纯 asp , 你一样要从数据库里面去读， 原理是一样的。
dogboxr 2003-12-25
  • 打赏
  • 举报
 回复
对不起啊 楼上几位大哥 我不会用 xml

可不可以帮忙用 asp写一下

或许 告诉我 那里有 这方面的 实例啊
nchen123 2003-12-25
  • 打赏
  • 举报
 回复
<province name="内蒙古"><city>阿拉善盟</city><city>巴彦淖尔盟</city><city>包头市</city><city>赤峰市</city><city>呼和浩特市</city><city>呼伦贝尔市</city><city>乌海市</city><city>乌兰察布盟</city><city>锡林郭勒盟</city><city>兴安盟</city><city>鄂尔多斯市</city><city>通辽市</city></province><province name="宁夏"><city>固原市</city><city>石嘴山市</city><city>银川市</city><city>吴忠市</city></province><province name="青海省"><city>果洛自治州</city><city>海北自治州</city><city>海东地区</city><city>海南自治州</city><city>海西自治州</city><city>黄南自治州</city><city>西宁市</city><city>玉树自治州</city></province><province name="山东省"><city>滨州市</city><city>德州市</city><city>东营市</city><city>菏泽地区</city><city>济南市</city><city>济宁市</city><city>莱芜市</city><city>聊城市</city><city>临沂市</city><city>青岛市</city><city>日照市</city><city>泰安市</city><city>威海市</city><city>潍坊市</city><city>烟台市</city><city>枣庄市</city><city>淄博市</city></province><province name="山西省"><city>长治市</city><city>大同市</city><city>晋城市</city><city>晋中市</city><city>临汾市</city><city>吕梁地区</city><city>朔州市</city><city>太原市</city><city>忻州市</city><city>雁北地区</city><city>阳泉市</city><city>运城市</city></province><province name="陕西省"><city>安康市</city><city>宝鸡市</city><city>汉中市</city><city>商洛市</city><city>铜川市</city><city>渭南市</city><city>西安市</city><city>咸阳市</city><city>延安市</city><city>榆林市</city></province><province name="上海市"><city>上海市</city></province><province name="四川省"><city>阿坝自治州</city><city>巴中市</city><city>成都市</city><city>达州市</city><city>德阳市</city><city>甘孜自治州</city><city>广安市</city><city>广元市</city><city>乐山市</city><city>凉山自治州</city><city>眉山市</city><city>绵阳市</city><city>南充市</city><city>内江市</city><city>攀枝花市</city><city>遂宁市</city><city>雅安市</city><city>宜宾市</city><city>自贡市</city><city>泸州市</city><city>资阳市</city></province><province name="台湾"><city>高雄市</city><city>高雄县</city><city>花莲县</city><city>基隆市</city><city>嘉义市</city><city>嘉义县</city><city>苗栗县</city><city>南投县</city><city>澎湖县</city><city>屏东县</city><city>台北市</city><city>台北县</city><city>台东县</city><city>台南市</city><city>台南县</city><city>台中市</city><city>台中县</city><city>桃园县</city><city>新竹市</city><city>新竹县</city><city>宜兰县</city><city>云林县</city><city>彰化市</city><city>彰化县</city></province><province name="天津市"><city>天津市</city></province><province name="西藏"><city>阿里地区</city><city>昌都地区</city><city>拉萨市</city><city>林芝地区</city><city>那曲地区</city><city>日喀则地区</city><city>山南地区</city></province><province name="香港"><city>香港</city></province><province name="新疆"><city>阿克苏地区</city><city>阿勒泰地区</city><city>巴音郭楞州</city><city>博尔塔拉州</city><city>昌吉自治州</city><city>哈密地区</city><city>和田地区</city><city>喀什地区</city><city>克拉玛依市</city><city>克孜勒州</city><city>石河子市</city><city>塔城地区</city><city>吐鲁番地区</city><city>乌鲁木齐市</city><city>伊犁地区</city></province><province name="云南省"><city>保山市</city><city>楚雄自治州</city><city>大理自治州</city><city>德宏自治州</city><city>迪庆自治州</city><city>东川市</city><city>红河自治州</city><city>昆明市</city><city>丽江地区</city><city>临沧地区</city><city>怒江自治州</city><city>曲靖市</city><city>思茅地区</city><city>文山自治州</city><city>西双版纳州</city><city>玉溪市</city><city>昭通市</city></province><province name="浙江省"><city>杭州市</city><city>湖州市</city><city>嘉兴市</city><city>金华市</city><city>丽水市</city><city>宁波市</city><city>绍兴市</city><city>台州市</city><city>温州市</city><city>舟山市</city><city>衢州市</city></province><province name="重庆市"><city>重庆市</city></province></data></xml>
nchen123 2003-12-25
  • 打赏
  • 举报
 回复
省市联动下拉框：(两个文件)

province.htm
---------------------------

<body>

<xml id="doc" src="prov_city.xml"></xml>

<select id=prov name=prov onchange="docity()">
<option value="0">--- 请选择省份 ---</option>
</select>
<select id=city name=city></select>

<script language="JavaScript">
function init(){
var v1 = doc.getElementsByTagName("province");
for(var i =0; i<v1.length;i++){
var e = document.createElement("OPTION");
e.innerText = e.value = v1[i].getAttribute("name");
prov.appendChild(e);
}
}

function docity(){
var sf = prov.value;
var str="//province[@name='"+sf+"']";
var v = doc.selectSingleNode(str);
if(!v){ alert("没有符合条件的记录！");return;}
city.innerHTML = "";
var v1 = v.selectNodes("city")
for(var i =0; i<v1.length;i++){
var e = document.createElement("OPTION");
e.innerText = e.value = v1[i].text;
city.appendChild(e);
}
}
init();
</script>
</body>

prov_city.xml
------------------------------

<?xml version="1.0" encoding="GB2312"?>
<xml><data><province name="安徽省"><city>安庆市</city><city>蚌埠市</city><city>巢湖市</city><city>池州市</city><city>滁州市</city><city>阜阳市</city><city>毫州市</city><city>合肥市</city><city>淮北市</city><city>淮南市</city><city>黄山市</city><city>六安市</city><city>马鞍山市</city><city>宿州市</city><city>铜陵市</city><city>芜湖市</city><city>宣州市</city></province><province name="澳门"><city>澳门</city></province><province name="北京市"><city>北京市</city></province><province name="福建省"><city>福州市</city><city>龙岩市</city><city>南平市</city><city>宁德市</city><city>莆田市</city><city>泉州市</city><city>三明市</city><city>厦门市</city><city>漳州市</city></province><province name="甘肃省"><city>白银市</city><city>定西地区</city><city>甘南自治州</city><city>嘉峪关市</city><city>金昌市</city><city>酒泉地区</city><city>兰州市</city><city>临夏自治州</city><city>陇南地区</city><city>平凉地区</city><city>庆阳地区</city><city>天水市</city><city>武威市</city><city>张掖地区</city></province><province name="广东省"><city>深圳市</city><city>潮州市</city><city>东莞市</city><city>佛山市</city><city>广州市</city><city>河源市</city><city>惠州市</city><city>江门市</city><city>揭阳市</city><city>茂名市</city><city>梅州市</city><city>清远市</city><city>汕头市</city><city>汕尾市</city><city>韶关市</city><city>阳江市</city><city>云浮市</city><city>湛江市</city><city>肇庆市</city><city>中山市</city><city>珠海市</city></province><province name="广西"><city>百色地区</city><city>北海市</city><city>防城港市</city><city>桂林地区</city><city>桂林市</city><city>贵港市</city><city>河池地区</city><city>柳州地区</city><city>柳州市</city><city>南宁市</city><city>南宁地区</city><city>钦州市</city><city>贺州地区</city><city>梧州市</city><city>玉林市</city></province><province name="贵州省"><city>安顺市</city><city>毕节地区</city><city>贵阳市</city><city>六盘水市</city><city>黔东南自治州</city><city>黔南自治州</city><city>黔西南自治州</city><city>铜仁市</city><city>遵义市</city></province><province name="海南省"><city>海口市</city><city>三亚市</city></province><province name="河北省"><city>保定地区</city><city>保定市</city><city>沧州地区</city><city>沧州市</city><city>承德地区</city><city>承德市</city><city>邯郸市</city><city>衡水市</city><city>廊坊市</city><city>秦皇岛市</city><city>深州市</city><city>石家庄市</city><city>唐山市</city><city>邢台地区</city><city>邢台市</city><city>张家口地区</city><city>张家口市</city></province><province name="河南省"><city>安阳市</city><city>鹤壁市</city><city>焦作市</city><city>开封市</city><city>洛阳市</city><city>南阳市</city><city>平顶山市</city><city>三门峡市</city><city>商丘市</city><city>新乡市</city><city>信阳市</city><city>许昌市</city><city>郑州市</city><city>周口市</city><city>驻马店市</city><city>漯河市</city><city>濮阳市</city></province><province name="黑龙江"><city>大庆市</city><city>大兴安岭</city><city>哈尔滨市</city><city>鹤岗市</city><city>黑河地区</city><city>黑河市</city><city>鸡西市</city><city>佳木斯市</city><city>牡丹江市</city><city>七台河市</city><city>齐齐哈尔市</city><city>双鸭山市</city><city>松花江地区</city><city>绥化市</city><city>伊春市</city></province><province name="湖北省"><city>鄂州市</city><city>恩施自治州</city><city>黄冈市</city><city>黄石市</city><city>荆门市</city><city>荆州市</city><city>十堰市</city><city>随州市</city><city>武汉市</city><city>咸宁市</city><city>襄樊市</city><city>孝感地区</city><city>孝感市</city><city>宜昌地区</city><city>宜昌市</city><city>郧阳地区</city></province><province name="湖南省"><city>常德市</city><city>长沙市</city><city>郴州地区</city><city>张家界市</city><city>衡阳市</city><city>怀化市</city><city>永州市</city><city>娄底市</city><city>邵阳市</city><city>湘潭市</city><city>湘西自治区</city><city>益阳市</city><city>岳阳市</city><city>株洲市</city></province><province name="吉林省"><city>白城地区</city><city>白城市</city><city>白山市</city><city>长春市</city><city>浑江市</city><city>吉林市</city><city>辽源市</city><city>四平市</city><city>松原市</city><city>通化市</city><city>延边自治区</city></province><province name="江苏省"><city>常州市</city><city>淮阴市</city><city>连云港市</city><city>南京市</city><city>南通市</city><city>苏州市</city><city>宿迁市</city><city>泰州市</city><city>无锡市</city><city>徐州市</city><city>盐城市</city><city>扬州市</city><city>镇江市</city></province><province name="江西省"><city>抚州市</city><city>赣州市</city><city>吉安市</city><city>景德镇市</city><city>九江市</city><city>南昌市</city><city>萍乡市</city><city>上饶市</city><city>新余市</city><city>宜春市</city><city>鹰潭市</city></province><province name="辽宁省"><city>鞍山市</city><city>本溪市</city><city>朝阳市</city><city>大连市</city><city>丹东市</city><city>抚顺市</city><city>阜新市</city><city>葫芦岛市</city><city>锦州市</city><city>辽阳市</city><city>盘锦市</city><city>沈阳市</city><city>铁岭市</city><city>营口市</city></province>
ying1234 2003-12-25
  • 打赏
  • 举报
 回复
搜索本版“联动”，好多例子可参考。
dogboxr 2003-12-25
  • 打赏
  • 举报
 回复
在调用这个下框的页面 有三个下拉框 第二个下拉框的值 取决于第一个下拉框的选择

所以 要在第一个下拉框选择后生效的

比如说 选择了省份 才能选择 地区
ASP.NET毕业设计食堂餐饮管理系统实战
基于ASP.NET食堂餐饮管理系统毕业设计的主要优势有以下几个方面： 1、学习难度低，满足大多数应届毕业生和对编程了解程度较低人群的学习要求。 2、侧重点突出，通过系统化和流程化的方式进行信息管理。 3、实现对菜...
有关asp.net网站管理工具的一个小问题
昨天在vs2005中使用asp.net2.0网站管理工具时出了一点小问题。首先我用aspnet_regsql来注册asp.net网站数据库，我是指定的本机上sqlserver2000中的fw数据库，注册完成后在库中自动生成了11张表这些表是给成员资格、...
折腾：一个小破ASP程序也能浪费不少时间
1. 在网上闲逛，搜来一个作业一样的ASP小程序；2. 解压看了看，一共没有几个ASP文件，加上一个几个表的小Access数据库；3. 发现Windows XP上没有装IIS，于是装上；4. 在IIS中部署上这个小网站；5. 在IE8中去访问以下...
VS2019关于新建项目中没有ASP.NET空网站解决
今天开始学习新的知识，每当开始一个新的知识的时候总会遇到一些小问题，每次进行一个新知识点的学习都需要对软件进行一次配置工作。此次学习ASP.NET也是不例外的，此次遇到的问题是：当新建网站的时候，发现没有此...
Asp常见问题(新手)
ASP提供了一个在服务器端执行指令的环境，它利用了特殊的符号（）来区分HTML与必须经过服务器翻译才能送往客户端的命令。它可以执行的指令包括HTML语言， Microsoft VBScript和 Microsoft Jscript等，因此可以制作...
ASP

28,390

社区成员

357,068

社区内容

发帖
与我相关
我的任务
社区描述
ASP即Active Server Pages，是Microsoft公司开发的服务器端脚本环境。
社区管理员
  • ASP
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章