控件联动（三级联动）

关联数据库

 

 

 1 public Form1()
 2         {
 3             InitializeComponent();
 4 
 5             //绑定省
 6             comboBox1.DataSource = new ChinaData().Select("0001");
 7             comboBox1.DisplayMember = "AreaName";
 8             comboBox1.ValueMember = "AreaCode";
 9 
10             //绑定市
11             comboBox2.DataSource = new ChinaData().Select(comboBox1.SelectedValue.ToString());
12             comboBox2.DisplayMember = "AreaName";
13             comboBox2.ValueMember = "AreaCode";
14 
15             //绑定区县
16             comboBox3.DataSource = new ChinaData().Select(comboBox2.SelectedValue.ToString());
17             comboBox3.DisplayMember = "AreaName";
18             comboBox3.ValueMember = "AreaCode";
19 
20         }
21 
22         private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
23         {
24             //绑定市
25             comboBox2.DataSource = new ChinaData().Select(comboBox1.SelectedValue.ToString());
26             comboBox2.DisplayMember = "AreaName";
27             comboBox2.ValueMember = "AreaCode";
28         }
29 
30         private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
31         {
32             //绑定区县
33             comboBox3.DataSource = new ChinaData().Select(comboBox2.SelectedValue.ToString());
34             comboBox3.DisplayMember = "AreaName";
35             comboBox3.ValueMember = "AreaCode";
36         }

 

posted @ 2016-12-13 10:10  浆糊033  阅读(396)  评论(0)  编辑  收藏  举报