[RESOLVED] [2005] combobox databinding

[jlbantang]

im trying to bind dataset at runtime to combobox with the valuemember and displaymember column assign. im playing this code

ComboBox1.DataSource = ds.Tables(0)
        ComboBox1.ValueMember = "pk_clientID"
        ComboBox1.DisplayMember = "clientname"

to make the name appear in the combobox item list and on the other hand the ID will be use for details referencing.

tnx

[jmcilhinney]

Do you have a question?

[jlbantang]

oops why did i post that unfinish. anyway here the remaining part:

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
        MessageBox.Show(ComboBox1.ValueMember)
    End Sub

and this return the string "pk_clientID" regardless of what ive selected in the combobox item its return the same value.

[dolot]

Yes, the valuemember only gets/sets the field in the datasource to use for the value property. To get the value that is selected use combobox1.selectedvalue.

[riteshjain1982]

i think you are looking for

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged        

MessageBox.Show(ComboBox1.SelectedValue)    

End Sub

[jlbantang]

perfect!

tnx