110,566
社区成员
发帖
与我相关
我的任务
分享
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";}
这段绑定到第一个combobox上的数据
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";}}
这段当第一个combobox选择往第二个combobox上面绑定数据