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