Combobox SelectedValueChanged ValueMember
I have a combobox that I have filled with employees. I want to to query my database based on the selected employees ID. I have
VB Code:
Private Sub ComboBoxSetup()
Dim strDSN As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = _
" & Application.StartupPath & "\myDB.mdb"
Dim myConnectionString As New OleDbConnection(strDSN)
Dim sql As String = "SELECT EmployeeID, Surname FROM EmployeeDetails WHERE _
CompanyID=" & CurrentCompanyID & " ORDER BY Surname"
Dim myDataAdapter As New OleDbDataAdapter(sql, myConnectionString)
Dim myDataSet As New DataSet
myDataAdapter.Fill(myDataSet, "Employees")
Dim myTable As DataTable
Dim myRow As DataRow
myTable = myDataSet.Tables("Employees")
For Each myRow In myTable.Rows
cmbSurname.ValueMember = myRow("EmployeeID")
cmbSurname.DisplayMember = myRow("Surname")
cmbSurname.Items.Add(myRow("Surname"))
Next
cmbSurname.SelectedIndex = -1
End Sub
In my SelectedIndexChanged event handler how do I reference the ID corresponding to the selected surname? I have tried a few things.
VB Code:
Public Sub cmbSurname_SelectedIndexChanged(ByVal sender As System.Object, ByVal _
e As System.EventArgs) Handles cmbSurname.SelectedIndexChanged
Dim SelectedID as Integer = cmbSurname.ValueMember
MsgBox(SelectedID)
End Sub
pulls out the ID matching the last employee to be loaded into the combobox
Wood...Trees...thanks in advance