namespace WebApplicationDlh { using System; using System.Data; using System.Drawing; using System.Web; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using Db; /// <summary> /// Area /// </summary> public class Area : System.Web.UI.UserControl { protected System.Web.UI.WebControls.DropDownList ddlProvince; protected System.Web.UI.WebControls.DropDownList ddlCity; public string strProvince { get { return ddlProvince.SelectedItem.Value; } set { ddlProvince.SelectedItem.Value = value; } } public string strCity { get { return ddlCity.SelectedItem.Value; } set { ddlCity.SelectedItem.Value = value; } } private void Page_Load(object sender, System.EventArgs e) { if(!IsPostBack) { ddlProvinceBind(); ddlCity.Items.Insert(0,"-City to choose-"); } } private void ddlProvinceBind() { Db.Area myArea = new Db.Area(); SqlDataReader dr = myArea.GetAllProvince(); if(dr.Read()) { ddlProvince.DataSource = dr; ddlProvince.DataTextField = "Province"; ddlProvince.DataValueField = "Province"; ddlProvince.DataBind(); ddlProvince.Items.Insert(0,"-Province to choose-"); } } #region Web override protected void OnInit(EventArgs e) { // // CODEGEN: // InitializeComponent(); base.OnInit(e); } /// <summary> /// /// /// </summary> private void InitializeComponent() { this.ddlProvince.SelectedIndexChanged += new System.EventHandler(this.ddlProvince_SelectedIndexChanged); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void ddlProvince_SelectedIndexChanged(object sender, System.EventArgs e) { if(ddlProvince.SelectedItem.Value == "-Province to choose-") { ddlCity.Items.Clear(); ddlCity.Items.Insert(ddlProvince.SelectedIndex,"-City to choose-"); } else { Db.Area myArea = new Db.Area(); SqlDataReader dr = myArea.GetAllCityWhereProvince(ddlProvince.SelectedItem.Value); if(dr.Read()) { ddlCity.DataSource = dr; ddlCity.DataTextField = "City"; ddlCity.DataValueField = "ID"; ddlCity.DataBind(); } } } } } =============================================================〉 using System; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace Db { /// <summary> /// Area /// </summary> public class Area:Base { public Area() { // // TODO: // } public SqlDataReader GetAllProvince() {