protected void CCountryDDL_SelectedIndexChanged(object sender, EventArgs e) { if (CCountryDDL.SelectedItem.Text == "Canada" || CCountryDDL.SelectedItem.Text == "United States") { CProvince(sender, e); CProvinceDDL.Enabled = true; CProvinceDDL.Focus(); } else { CProvinceDDL.Enabled = false; CProvinceDDL.Items.Clear(); CProvinceDDL.Focus(); } }
//Database connection for Province/State information to bind it to the ProvinceState Dropdownlist in Add Contact protected void CProvince(object sender, EventArgs e) { string country = null; if (CCountryDDL.SelectedItem.Text == "Canada") { country = "C"; } else if (CCountryDDL.SelectedItem.Text == "United States") { country = "US"; } using (var conn = new MySqlConnection(strcon)) { conn.Open(); string Query = "SELECT * FROM ProvinceState WHERE SCountry = '" + country + "'"; using (var cmd = new MySqlCommand(Query, conn)) { using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { CProvinceDDL.DataSource = reader; CProvinceDDL.DataValueField = "StateName"; CProvinceDDL.DataTextField = "StateName"; CProvinceDDL.DataBind(); if (country == "C") { CProvinceDDL.Items.Insert(0, new ListItem("Province", "NA")); } else if (country == "US") { CProvinceDDL.Items.Insert(0, new ListItem("State", "NA")); } } } } } }