应一个朋友的要求, 一个ComboBox 控件里的内容改变 ,另外一个ComboBox控件根据 类型相应改变.
数据库
cmbType的数据绑定 type表的typename, 在cmbType的SelectedIndexChanged事件里写如下代码
Code
1 private void cmbType_SelectedIndexChanged(object sender, EventArgs e)
2 {
3 try
4 {
5 SqlConnection con = new SqlConnection("server=.;database=textDb;uid=sa;pwd=");
6 SqlCommand cmd1 = new SqlCommand("select * from type where typename='" + cmbType.Text + "'", con);
7 con.Open();
8 SqlDataReader sdr1 = cmd1.ExecuteReader();
9 sdr1.Read();
10 string str = sdr1["type"].ToString();
11 sdr1.Close();
12 SqlCommand cmd = new SqlCommand("select * from name where type='" + str + "'", con);
13 SqlDataReader sdr = cmd.ExecuteReader();
14 cmbName.Items.Clear();
15 while (sdr.Read())
16 {
17 cmbName.Items.Add(sdr["name"].ToString());
18 }
19 sdr.Close();
20 con.Close();
21 cmbName.SelectedIndex = 0;
22 }
23 catch (System.Exception ex)
24 {
25 MessageBox.Show(ex.Message.ToString());
26 }
27 }
希望此对初学的朋友有帮助.