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"));
}
}
}
}
}
}
