省市县联动问题 - 黑马程序员技术交流社区

public partial class 省市县联动 : Window
{
public 省市县联动()
{
InitializeComponent();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
DataTable table = SqlHelper.ExecuteDataTable("select * from Data_Province");
List<Area> list = new List<Area>();
foreach(DataRow row in table.Rows)
{
Area area=new Area();
area.Id=(string)row["ProvinceCode"];
area.Name=(string)row["ProvinceName"];
list.Add(area);
}
lbProv.ItemsSource=list;
}
private void lbProv_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Area area=(Area)lbProv.SelectedItem;
DataTable table=SqlHelper.ExecuteDataTable("select * from Data_City where ProvinceCode=@prov ",
new SqlParameter("@prov",area.Id));
List<Area> list=new List<Area>();
foreach (DataRow row in table.Rows)
{
Area city=new Area();
city.Id=(string)row["CityCode"];
city.Name=(string)row["CityName"];
list.Add(city);
}
lbCity.ItemsSource = list;
}
private void lbCity_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Area area = (Area)lbCity.SelectedItem;
DataTable table = SqlHelper.ExecuteDataTable("select * from Data_County where CityCode=@city",
new SqlParameter("@city",area.Id));
List<Area> list = new List<Area>();
foreach (DataRow row in table.Rows)
{
Area county = new Area();
county.Id = (string)row["CountyCode"];
county.Name = (string)row["CountyName"];
list.Add(county);
}
lbCounty.ItemsSource = list;
}
}
}

复制代码