健康一贴灵,专注医药行业管理信息化

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";
}
}
复制代码

 

posted @   一贴灵  阅读(299)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单,K8s 太复杂?w7panel 让容器管理更轻松!
学以致用,效率第一
点击右上角即可分享
微信分享提示