protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e) { string cityid = this.ddlcity.SelectedValue; T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 and CityID='" + cityid + "' order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtd.Rows) { string Id = dr["Id"].ToString(); string Title = dr["DisName"].ToString().Trim(); this.ddlarea.Items.Add(new ListItem(Title, Id)); } }
private void procityareabind(int _id) { tbl_product model1 = new tbl_product(); model1.GetModel(_id); T_Province bll = new T_Province(); DataTable dt = bll.GetList("1=1 order by ProSort").Tables[0]; this.ddlprov.Items.Clear(); this.ddlprov.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["ProID"].ToString(); string Title = dr["ProName"].ToString().Trim(); this.ddlprov.Items.Add(new ListItem(Title, Id)); } string proid = model1.province_id.ToString(); T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 and ProID='" + proid + "' order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtc.Rows) { string Id = dr["CityID"].ToString(); string Title = dr["CityName"].ToString().Trim(); this.ddlcity.Items.Add(new ListItem(Title, Id)); } string cityid = model1.city_id.ToString(); T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 and CityID='" + cityid + "' order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtd.Rows) { string Id = dr["Id"].ToString(); string Title = dr["DisName"].ToString().Trim(); this.ddlarea.Items.Add(new ListItem(Title, Id)); } }
protected void ddlprov_SelectedIndexChanged(object sender, EventArgs e) { string proid = this.ddlprov.SelectedValue; T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 and ProID='" + proid + "' order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dtc.Rows) { string Id = dr["CityID"].ToString(); string Title = dr["CityName"].ToString().Trim(); this.ddlcity.Items.Add(new ListItem(Title, Id)); } T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); }
private void procityareabind() { T_Province bll = new T_Province(); DataTable dt = bll.GetList("1=1 order by ProSort").Tables[0]; this.ddlprov.Items.Clear(); this.ddlprov.Items.Add(new ListItem("请选择...", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["ProID"].ToString(); string Title = dr["ProName"].ToString().Trim(); this.ddlprov.Items.Add(new ListItem(Title, Id)); } T_City bllc = new T_City(); DataTable dtc = bllc.GetList("1=1 order by CitySort").Tables[0]; this.ddlcity.Items.Clear(); this.ddlcity.Items.Add(new ListItem("请选择...", "")); //foreach (DataRow dr in dtc.Rows) //{ // string Id = dr["CityID"].ToString(); // string Title = dr["CityName"].ToString().Trim(); // this.ddlcity.Items.Add(new ListItem(Title, Id)); //} T_District blld = new T_District(); DataTable dtd = blld.GetList("1=1 order by DisSort").Tables[0]; this.ddlarea.Items.Clear(); this.ddlarea.Items.Add(new ListItem("请选择...", "")); //foreach (DataRow dr in dtd.Rows) //{ // string Id = dr["Id"].ToString(); // string Title = dr["DisName"].ToString().Trim(); // this.ddlarea.Items.Add(new ListItem(Title, Id)); //} }