如何用Dropdownlist来实现年月日的三级联动? 如题,如何在Asp.net中实现年月日的三级联动呢?问题主要在月日上面? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //绑定省 OleDbDataAdapter odr = new OleDbDataAdapter("select * from SMT_ypaddone", con); DataSet ds = new DataSet(); odr.Fill(ds, "SMT_ypaddone"); this.DropDownList1.DataSource = ds.Tables["SMT_ypaddone"]; this.DropDownList1.DataTextField = "SMT_addone"; this.DropDownList1.DataValueField = "SMT_addone_id"; this.DropDownList1.DataBind(); //绑定市 OleDbDataAdapter oda = new OleDbDataAdapter("select * from SMT_ypaddtwo", con); DataSet dt = new DataSet(); oda.Fill(dt, "SMT_ypaddtwo"); this.DropDownList2.DataSource = dt.Tables["SMT_ypaddtwo"]; this.DropDownList2.DataTextField = "SMT_addtwo"; this.DropDownList2.DataValueField = "SMT_addtwo_ID"; this.DropDownList2.DataBind();protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string id = this.DropDownList1.SelectedValue.ToString(); OleDbConnection con = DB.getConnection(); con.Open(); OleDbDataAdapter odr = new OleDbDataAdapter("select * from SMT_ypaddtwo where SMT_addone_id=" + id, con); DataSet ds = new DataSet(); odr.Fill(ds, "SMT_ypaddtwo"); this.DropDownList2.DataSource = ds.Tables["SMT_ypaddtwo"]; this.DropDownList2.DataTextField = "SMT_addtwo"; this.DropDownList2.DataValueField = "SMT_addtwo_ID"; this.DropDownList2.DataBind(); } 还是用日历控件好些知道两级怎么做就知道三级了啊,不就是写在selectIndexchanged事件嘛! http://www.cnblogs.com/meetweb/archive/2007/03/16/677271.html 的确日历控件比较方便!实在要使用dropdownlist的话也不是很麻烦不过最好用js来实现联动!用js的话网上很多代码一搜就搜到了!如果不想用js的话用UpdatePanel和ScriptManager来实现无刷新! 微软的ajax里那个日期控件比较绚,还支持多语言版本可惜的是速度慢 一起讨论下这段简单的代码 关于WEB.CONFIG的问题 新手求教关于DATAGRID翻页问题啊 怎么隐藏MagicAjax中的Loading...? 存放在数据库中的文件作为邮件附件的问题,请指点。 怎么改变treeview 控件中字体的大小及颜色 请问datagrid中edit后,整个表格就变形了,变得很长,这应该怎么控制啊? 手机微网站,这是怎么做的 如何捕抓选择Datagrid所选择的第几列? 匹配任何一个字符的正则表达式要怎么写 动态文本框的问题? href问题
OleDbDataAdapter odr = new OleDbDataAdapter("select * from SMT_ypaddone", con);
DataSet ds = new DataSet();
odr.Fill(ds, "SMT_ypaddone");
this.DropDownList1.DataSource = ds.Tables["SMT_ypaddone"];
this.DropDownList1.DataTextField = "SMT_addone";
this.DropDownList1.DataValueField = "SMT_addone_id";
this.DropDownList1.DataBind(); //绑定市
OleDbDataAdapter oda = new OleDbDataAdapter("select * from SMT_ypaddtwo", con);
DataSet dt = new DataSet();
oda.Fill(dt, "SMT_ypaddtwo");
this.DropDownList2.DataSource = dt.Tables["SMT_ypaddtwo"];
this.DropDownList2.DataTextField = "SMT_addtwo";
this.DropDownList2.DataValueField = "SMT_addtwo_ID";
this.DropDownList2.DataBind();protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string id = this.DropDownList1.SelectedValue.ToString();
OleDbConnection con = DB.getConnection();
con.Open();
OleDbDataAdapter odr = new OleDbDataAdapter("select * from SMT_ypaddtwo where SMT_addone_id=" + id, con);
DataSet ds = new DataSet();
odr.Fill(ds, "SMT_ypaddtwo");
this.DropDownList2.DataSource = ds.Tables["SMT_ypaddtwo"];
this.DropDownList2.DataTextField = "SMT_addtwo";
this.DropDownList2.DataValueField = "SMT_addtwo_ID";
this.DropDownList2.DataBind();
}
知道两级怎么做就知道三级了啊,不就是写在selectIndexchanged事件嘛!
实在要使用dropdownlist的话也不是很麻烦不过最好用js来实现联动!
用js的话网上很多代码一搜就搜到了!
如果不想用js的话用UpdatePanel和ScriptManager来实现无刷新!
可惜的是速度慢