如何用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里那个日期控件比较绚,还支持多语言版本可惜的是速度慢 c#,mysql,自增长 asp.net使用ajax进行翻页 查询分类的方法 如何后台设置客户端文本框为只读属性? 请教一下,怎么样执行一条服务器端脚本,再执行一条客户端脚本,再执行一条服务器端的???????? 高分求救,在線等。。。。。。 请教通过验证后,验证失效的问题. 上传问题,请帮忙!!! 莱鸟问题,请各位朋友指点,关于asp数据库的问题 webservice发布在iis上不稳定 动态文本框的问题? 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来实现无刷新!
可惜的是速度慢