<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="CustomManager.company.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<LINK href="../css/style.css" type="text/css" rel="stylesheet">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:dropdownlist id="DropDownList1" style="Z-INDEX: 101; LEFT: 40px; POSITION: absolute; TOP: 168px"
runat="server"></asp:dropdownlist>
<!--以下的label中隐藏存放一级栏目和二级栏目对应的内容-->
<asp:label id="Label1" style="display:none;" runat="server">Label</asp:label>
<asp:DropDownList id="DropDownList2" style="Z-INDEX: 104; LEFT: 40px; POSITION: absolute; TOP: 264px"
runat="server"></asp:DropDownList></form>
<script LANGUAGE="javascript">
//将隐藏的字符串取出来，然后分割到一个数组中去
var str = document.getElementById("Label1").innerText;
arr=str.split(",");
a=arr.length
ar=new Array()
for (i=0;i<a;i++){
ar[i]=arr[i].split("-");
}
onecount=ar.length;
//此处实现联动
function ld() {
document.Form1.DropDownList2.length=0
lid=Form1.DropDownList1.value;
for (i=0;i<onecount;i++) {
if (ar[i][0] == lid) {
document.Form1.DropDownList2.options.add(new Option(ar[i][2], ar[i][1]));
}
}
}
function showMsg()
{
alert(document.Form1.DropDownList1.value);
alert(document.Form1.DropDownList2.value);
}
</script>
</body>
</HTML>
以下是WebForm1.aspx.cs
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace CustomManager.company
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
static protected DataTable tb1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
}
//给DropDownList1设置onchange事件
DropDownList1.Attributes.Add("onchange","ld();");
string strConn,strSql;
System.Data.SqlClient.SqlDataAdapter da;
//从数据库中取出一级栏目，绑定到 DropDownList1
strConn = "server=localhost;database=custom;uid=custom;pwd=a;";
strSql = "select * from custom.bigcalling;";
da = new System.Data.SqlClient.SqlDataAdapter(strSql,strConn);
DataTable tb3 = new DataTable();
da.Fill(tb3);
DropDownList1.DataSource = tb3;
DropDownList1.DataTextField = "BIGCALLNAME";
DropDownList1.DataValueField= "BIGCALLID";
DropDownList1.DataBind();
//取出二级栏目数据，存放到一个DataTable()中
strSql = "select * from custom.smallcalling;";
da = new System.Data.SqlClient.SqlDataAdapter(strSql,strConn);
tb1 = new DataTable();
da.Fill(tb1);
//以下就是将一级和二级菜单的内容，分别以"-"和","隔开
//然后存放到 Label1中,这样客户端就可以通过脚本取得所需要的数据了
Label1.Text = "";
foreach(DataRow row in tb1.Rows)
{
Label1.Text = Label1.Text + row["BIGCALLID"] + "-" +row["SMALLCALLID"] + "-"+row["SMALLCALLNAME"] + ",";
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
实例二:javascrip实现
<script language="javascript">
<!--
var where = new Array(36);
function comefrom(loca,locacity) { this.loca = loca; this.locacity = locacity; }
where[0]= new comefrom("==请选择==","==请选择==");
where[1] = new comefrom("北京","|东城|西城|崇文|宣武|朝阳|丰台|石景山|海淀|门头沟|房山|通州|顺义|昌平|大兴|平谷|怀柔|密云|延庆");
where[2] = new comefrom("上海","|黄浦|卢湾|徐汇|长宁|静安|普陀|闸北|虹口|杨浦|闵行|宝山|嘉定|浦东|金山|松江|青浦|南汇|奉贤|崇明");
where[3] = new comefrom("天津","|和平|东丽|河东|西青|河西|津南|南开|北辰|河北|武清|红挢|塘沽|汉沽|大港|宁河|静海|宝坻|蓟县");
where[4] = new comefrom("重庆","|万州|涪陵|渝中|大渡口|江北|沙坪坝|九龙坡|南岸|北碚|万盛|双挢|渝北|巴南|黔江|长寿|綦江|潼南|铜梁|大足|荣昌|壁山|梁平|城口|丰都|垫江|武隆|忠县|开县|云阳|奉节|巫山|巫溪|石柱|秀山|酉阳|彭水|江津|合川|永川|南川");
where[5] = new comefrom("河北","|石家庄|邯郸|邢台|保定|张家口|承德|廊坊|唐山|秦皇岛|沧州|衡水");
where[6] = new comefrom("山西","|太原|大同|阳泉|长治|晋城|朔州|吕梁|忻州|晋中|临汾|运城");
where[7] = new comefrom("内蒙古","|呼和浩特|包头|乌海|赤峰|呼伦贝尔盟|阿拉善盟|哲里木盟|兴安盟|乌兰察布盟|锡林郭勒盟|巴彦淖尔盟|伊克昭盟");
where[8] = new comefrom("辽宁","|沈阳|大连|鞍山|抚顺|本溪|丹东|锦州|营口|阜新|辽阳|盘锦|铁岭|朝阳|葫芦岛");
where[9] = new comefrom("吉林","|长春|吉林|四平|辽源|通化|白山|松原|白城|延边");
where[10] = new comefrom("黑龙江","|哈尔滨|齐齐哈尔|牡丹江|佳木斯|大庆|绥化|鹤岗|鸡西|黑河|双鸭山|伊春|七台河|大兴安岭");
where[11] = new comefrom("江苏","|南京|镇江|苏州|南通|扬州|盐城|徐州|连云港|常州|无锡|宿迁|泰州|淮安|丹徒|丹阳|张家港|太仓|昆山|吴江|海门|如皋|如东|扬中|东台|溧阳|武进|江阴|锡山|宜兴|金坛");
where[12] = new comefrom("浙江","|杭州|宁波|温州|嘉兴|湖州|绍兴|金华|衢州|舟山|台州|丽水");
where[13] = new comefrom("安徽","|合肥|芜湖|蚌埠|马鞍山|淮北|铜陵|安庆|黄山|滁州|宿州|池州|淮南|巢湖|阜阳|六安|宣城|亳州");
where[14] = new comefrom("福建","|福州|厦门|莆田|三明|泉州|漳州|南平|龙岩|宁德");
where[15] = new comefrom("江西","|南昌市|景德镇|九江|鹰潭|萍乡|新馀|赣州|吉安|宜春|抚州|上饶");
where[16] = new comefrom("山东","|济南|青岛|淄博|枣庄|东营|烟台|潍坊|济宁|泰安|威海|日照|莱芜|临沂|德州|聊城|滨州|菏泽");
where[17] = new comefrom("河南","|郑州|开封|洛阳|平顶山|安阳|鹤壁|新乡|焦作|濮阳|许昌|漯河|三门峡|南阳|商丘|信阳|周口|驻马店|济源");
where[18] = new comefrom("湖北","|武汉|宜昌|荆州|襄樊|黄石|荆门|黄冈|十堰|恩施|潜江|天门|仙桃|随州|咸宁|孝感|鄂州");
where[19] = new comefrom("湖南","|长沙|常德|株洲|湘潭|衡阳|岳阳|邵阳|益阳|娄底|怀化|郴州|永州|湘西|张家界");
where[20] = new comefrom("广东","|广州|深圳|珠海|汕头|东莞|中山|佛山|韶关|江门|湛江|茂名|肇庆|惠州|梅州|汕尾|河源|阳江|清远|潮州|揭阳|云浮");
where[21] = new comefrom("广西","|南宁|柳州|桂林|梧州|北海|防城港|钦州|贵港|玉林|南宁地区|柳州地区|贺州|百色|河池");
where[22] = new comefrom("海南","|海口|三亚");
where[23] = new comefrom("四川","|成都|绵阳|德阳|自贡|攀枝花|广元|内江|乐山|南充|宜宾|广安|达川|雅安|眉山|甘孜|凉山|泸州");
where[24] = new comefrom("贵州","|贵阳|六盘水|遵义|安顺|铜仁|黔西南|毕节|黔东南|黔南");
where[25] = new comefrom("云南","|昆明|大理|曲靖|玉溪|昭通|楚雄|红河|文山|思茅|西双版纳|保山|德宏|丽江|怒江|迪庆|临沧");
where[26] = new comefrom("西藏","|拉萨|日喀则|山南|林芝|昌都|阿里|那曲");
where[27] = new comefrom("陕西","|西安|宝鸡|咸阳|铜川|渭南|延安|榆林|汉中|安康|商洛");
where[28] = new comefrom("甘肃","|兰州|嘉峪关|金昌|白银|天水|酒泉|张掖|武威|定西|陇南|平凉|庆阳|临夏|甘南");
where[29] = new comefrom("宁夏","|银川|石嘴山|吴忠|固原");
where[30] = new comefrom("青海","|西宁|海东|海南|海北|黄南|玉树|果洛|海西");
where[31] = new comefrom("新疆","|乌鲁木齐|石河子|克拉玛依|伊犁|巴音郭勒|昌吉|克孜勒苏柯尔克孜|博尔塔拉|吐鲁番|哈密|喀什|和田|阿克苏");
where[32] = new comefrom("香港","");
where[33] = new comefrom("澳门","");
where[34] = new comefrom("台湾","|台北|高雄|台中|台南|屏东|南投|云林|新竹|彰化|苗栗|嘉义|花莲|桃园|宜兰|基隆|台东|金门|马祖|澎湖");
where[35] = new comefrom("国外","|北美洲|南美洲|亚洲|非洲|欧洲|大洋洲");
function select()
{
// var obj=document.getElementById("Lable1");
// obj.Text="dssd";
//document.all.
// obj.Text=province.options[province.selectedIndex].value;
with(document.all.Form1.province)
{
var loca2 = options[selectedIndex].value;
document.all.HiddenValue.value = loca2;
}
for(i = 0;i < where.length;i++)
{
if (where[i].loca == loca2)
{
loca3 = (where[i].locacity).split("|");
for(j = 1;j < loca3.length;j++)
{
with(document.all.Form1.city)
{
length = loca3.length;
options[j].text = loca3[j];
options[j].value = loca3[j];
}
}
break;
}
}
with(document.all.Form1.city)
{
options[0].selected = true;
}
//document.creator.address.value=loca2+loca4;
}
function select1() {
with(document.all.Form1.city)
{
var loca4=options[selectedIndex].value;
document.all.HiddenValueshi.value = loca4;
}
}
function init() {
var cprin;
with(document.all.Form1.province)
{
length = where.length;
for(k=0;k<where.length;k++)
{
options[k].text = where[k].loca;
options[k].value = where[k].loca;
if (where[k].loca==document.all.HiddenValue.value)
cprin=where[k].locacity;
}
if (document.all.HiddenValue.value=="")
{options[selectedIndex].text = where[0].loca;
options[selectedIndex].value = where[0].loca;
}
else
{
options[selectedIndex].text=document.all.HiddenValue.value;
options[selectedIndex].value=document.all.HiddenValue.value;
}
}
with(document.all.Form1.city)
{
if (document.all.HiddenValueshi.value=="")
{
loca3 = (where[0].locacity).split("|");
length = loca3.length;
for(l=0;l<length;l++)
{
options[l].text = loca3[l]; options[l].value = loca3[l];
}
options[selectedIndex].text = where[0].loca; options[selectedIndex].value = where[0].loca;
}
else
{
loca3 = cprin.split("|");
length = loca3.length;
for(l=0;l<length;l++)
{
options[l].text = loca3[l]; options[l].value = loca3[l];
}
options[selectedIndex].text=document.all.HiddenValueshi.value;
options[selectedIndex].value=document.all.HiddenValueshi.value;
}
}
}
-->
</script>
<body MS_POSITIONING="GridLayout" onload="init();">
<form id="Form1" method="post" runat="server">
<asp:dropdownlist id="province" Runat="server"></asp:dropdownlist><asp:dropdownlist id="city" Runat="server"></asp:dropdownlist></SELECT><asp:button id="Button1" style="Z-INDEX: 101; LEFT: 240px; POSITION: absolute; TOP: 48px" runat="server"
Text="Button"></asp:button><asp:label id="Label1" style="Z-INDEX: 102; LEFT: 280px; POSITION: absolute; TOP: 136px" runat="server">Label</asp:label><input id="HiddenValue" type="hidden" name="HiddenValue" runat="server">
<input id="HiddenValueshi" type="hidden" name="HiddenValueshi" runat="server">
</form>
</body>
Private Sub Page_Load()Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'If Not Page.IsStartupScriptRegistered("init") Then
' Page.RegisterStartupScript("init", "<script>init();</script>")
'End If
If Not IsPostBack Then
province.Attributes.Add("onchange", "select()")
city.Attributes.Add("onchange", "select1()")
End If
End Sub
Private Sub Button1_Click()Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Response.Write(HiddenValue.Value)
Response.Write(HiddenValueshi.Value)
End Sub