In the code below I wanted to display the strAssistanceDesc in the combo box but have the lngAssistanceid as the value that is reterived. this code is displaying 1 which is the lngAssitanceid, how can I get it to display the name instead.
Dim cmd6 As New SqlClient.SqlCommand("Select * from tbllkpMHCPAssistance", Connection1)
Catch ex As Exception
Dim da As New SqlDataAdapter(cmd6)
Dim ds As New DataSet
me.ComboBox5.DataSource = ds.Tables("tbllkpMHCPAssistance")
Me.ComboBox5.DisplayMember = "strAsstistanceDesc"
Me.ComboBox5.ValueMember = "lngAssistanceid"