protected void RegionList_SelectedIndexChanged(object sender, System.EventArgs e)
{
foreach (DataRow datarow in RegionsSet.Tables["Regions"].Rows)
{
if (datarow.RowState != DataRowState.Deleted)
{
if ((int)datarow["ID"] == Convert.ToInt32(RegionList.SelectedValue))
{
RegionName.Text = (string)datarow["Region"];
break;
}
}
}
CountriesSet.Clear();
try
{
if (Convert.ToInt32(RegionList.SelectedValue) != 0)
{
CountriesAdapter.SelectCommand.Parameters["@RegionID"].Value = Convert.ToInt32(RegionList.SelectedValue);
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill(CountriesSet);
}
}
catch (Exception)
{
}
CountryList.DataBind();
CountryList2.DataBind();
CountryList_SelectedIndexChanged(CountryList, EventArgs.Empty);
}
protected void Region_SelectedIndexChanged(object sender, System.EventArgs e)
{
CountriesSet.Clear ();
CountriesAdapter.SelectCommand.Parameters["@RegionID"].Value = Convert.ToInt32 (Region.SelectedValue);
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill (CountriesSet);
Country.DataBind ();
Country_SelectedIndexChanged (Country, EventArgs.Empty);
}