关于两个ListBox绑定数据库后的联动问题（我先抛块砖）

来源：互联网发布：加盟编程猫培训编辑：程序博客网时间：2024/05/17 05:51

绑定数据：

DBAccess dBAccess = new DBAccess();
   string SQLStr = "select * from Users";
   UserDs = dBAccess.dsExecuteSql(SQLStr,"users");
   this.listBox_User.DataSource = UserDs.Tables["users"];
   this.listBox_User.DisplayMember = "char_UID";
   this.listBox_User.ValueMember = "int_GroupID";

   SQLStr = "select * from Groups where char_Isuse = '1'";
   GrpupDs = dBAccess.dsExecuteSql(SQLStr,"groups");
   this.listBox_Group.DataSource = GrpupDs.Tables["groups"];
   this.listBox_Group.ValueMember = "int_ID";
   this.listBox_Group.DisplayMember = "char_Note";

----------------------------------------------------------------------------------------------

foreach(System.Data.DataRowView DR in this.listBox_Group.Items)
    {
     if(DR.Row["int_ID"].ToString() == ((System.Data.DataRowView)listBox_User.SelectedItem).Row["int_GroupID"].ToString())
     {
      this.listBox_Group.SelectedIndex = i;

break;

}

i++;

}

我暂时没有找到好的办法，那位找到了可以发上来