private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
DataTable datable = SqlHelper.ExecuteDataTable("select * from AreaFull where AreaPid=0");
List<Area> listProv = new List<Area>();
foreach (DataRow row in datable.Rows)
{
Area area = new Area();
area.AreaID = (int)row["AreaId"];
area.AreaName = (string)row["AreaName"];
listProv.Add(area);
}
listbox1.ItemsSource = listProv;
}
private void listbox2_SelectionChanged_1(object sender, SelectionChangedEventArgs e)
{
Area area = (Area)listbox2.SelectedItem;
DataTable dtCity = SqlHelper.ExecuteDataTable("select * from AreaFull where AreaPid=@pid",
new SqlParameter("@Pid", area.AreaID));
List<Area> listCity = new List<Area>();
foreach (DataRow row in dtCity.Rows)
{
Area areaCtiry = new Area();
areaCtiry.AreaID = (int)row["AreaId"];
areaCtiry.AreaName = (string)row["AreaName"];
listCity.Add(areaCtiry);
}
listbox3.ItemsSource = listCity;
}
