C#关于winform combobox联动问题;
c#,winform,combobox联动 - Virus-BeautyCode - 博客园 (cnblogs.com)
关于winform combobox联动问题;
//注意以下两行代码,估计人的错误就在这里 DataRowView drv = (DataRowView)comboBox1.SelectedItem; string gId = drv.Row["group_id"].ToString();
我就是直接用
parentId = cbxCategory2.SelectedValue.ToString();
造成一直提示出错,但又找不到原因,只好try catch ...
private void RegisterForm_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection("server=root_db;database=users;uid=sa;password="); SqlDataAdapter da = new SqlDataAdapter("select group_id, group_name from mygroup", con); DataSet ds = new DataSet(); da.Fill(ds, "group"); DataTable dtGroup = ds.Tables["group"]; comboBox1.DataSource = dtGroup; comboBox1.DisplayMember = "group_name"; comboBox1.ValueMember = "group_id"; } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.SelectedIndex > -1) { //注意以下两行代码,估计人的错误就在这里 DataRowView drv = (DataRowView)comboBox1.SelectedItem; string gId = drv.Row["group_id"].ToString(); SqlConnection con = new SqlConnection("server=root_db;database=users;uid=sa;password="); SqlDataAdapter da = new SqlDataAdapter("select user_id, user_name from myuser where group_id='" + gId + "'", con); DataSet ds = new DataSet(); da.Fill(ds, "user"); DataTable dtUser = ds.Tables["user"]; comboBox2.DataSource = dtUser; comboBox2.DisplayMember = "user_name"; comboBox2.ValueMember = "user_id"; } }
活到老,学到老。

浙公网安备 33010602011771号