private void Grid_Loaded(object sender, RoutedEventArgs e)
{
DataTable table = SqlHelper.ExecuteDataset
("select * from AreaFull where AreaPid=@AreaPid", new SqlParameter("@AreaPid", "0"));
List<Area> ListProv = new List<Area>();
foreach (DataRow row in table.Rows)
{
Area area = new Area();
area.AreaId =(int) row["AreaId"];
area.AreaName = (string)row["AreaName"];
ListProv.Add(area);
}
lbProv.ItemsSource = ListProv;
}
private void lbCity_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Area areaCity = (Area)lbCity.SelectedItem;
List<Area> ListCountry = new List<Area>();
DataTable table = SqlHelper.ExecuteDataset
("Select * from AreaFull where AreaPid=@AreaPid", new SqlParameter("@AreaPid", areaCity.AreaId));
foreach (DataRow row in table.Rows)
{
Area area = new Area();
area.AreaId = (int)row["AreaId"];
area.AreaName = (string)row["AreaName"];
ListCountry.Add(area);
}
lbCountry.ItemsSource = ListCountry;
}
