protected void Country_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
if (Convert.ToInt32 (Country.SelectedValue) != 0)
{
StateProvincesSet.Clear ();
StateProvincesAdapter.SelectCommand.Parameters["@CountryID"].Value = Convert.ToInt32 (Country.SelectedValue);
//lock (CommonFunctions.Connection)
StateProvincesAdapter.Fill (StateProvincesSet);
}
else
StateProvincesSet.Clear ();
}
catch (Exception)
{
StateProvincesSet.Clear ();
}
StateProvince.DataBind ();
StateProvince_SelectedIndexChanged (StateProvince, EventArgs.Empty);
}
protected void CountryList_SelectedIndexChanged(object sender, System.EventArgs e)
{
foreach (DataRow datarow in CountriesSet.Tables["Countries"].Rows)
{
if (datarow.RowState != DataRowState.Deleted)
{
if ((int)datarow["ID"] == Convert.ToInt32(CountryList.SelectedValue))
{
if (datarow["RegionID"] is int)
{
RegionList2.SelectedValue = ((int)datarow["RegionID"]).ToString();
}
CountryName.Text = (string)datarow["Country"];
if (datarow["titleoverride"] != null)
{
Country_Title_OverRide.Text = datarow["titleoverride"].ToString();
}
if (datarow["descriptionoverride"] != null)
{
Country_description_override.Text = datarow["descriptionoverride"].ToString();
}
break;
}
}
}
StateProvincesSet.Clear();
try
{
if (Convert.ToInt32(CountryList.SelectedValue) != 0)
{
StateProvincesAdapter.SelectCommand.Parameters["@CountryID"].Value = Convert.ToInt32(CountryList.SelectedValue);
//lock (CommonFunctions.Connection)
StateProvincesAdapter.Fill(StateProvincesSet);
}
}
catch (Exception)
{
}
StateList.DataBind();
StateList2.DataBind();
StateList_SelectedIndexChanged(StateList, EventArgs.Empty);
}