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