Question

Vb.net中Combobox的问题?

Vb.net中Combobox1已经与Sql数据库的'部门'表连接上,下拉列表中有:财务部,采购部...等部门,现在我要在Combobox1下拉列表中选中财务部,在Combobox2中就显示财务部所有员工.如在Combobox1中选择其他部门也对应其部门下的员工,请教网络高手.最好具体的解决方案，在此感谢！

Answer 1

使用SelectedIndexChanged事件

Private Sub cbxBigDept_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
dim strBM as string
strBM=cbxBigDept.selectedValue ' 获得当前大部门名称
Dim myConn as SqlConnection = new sqlconnection(".......")
myConn.Open()
Dim myCmd as string = "select 小部门 from 小部门表 Where 大部门='" & strBM & "'"

Dim myAdapter as SqlDataAdapter = new SqlDataAdapter(myCmd,myConn)
Dim myDataSet as DataSet = new DataSet
myAdapter.Fill(myDataSet)
Me.cbxSonDept.DataSource = myAdapter.Table(0)
Me.cbxSonDept.ValueMember = "小部门"
myConn.Close

End Sub

祝你成功！

Answer 2

在Combobox1的SelectedIndexChanged事件中，根据数据库查询结果，改变Combobox2内容。