After update on Combo box [Resolved]

[Oliver1]

Hi I have a combo box, which is bound to some data like so.

Private Sub getmaindropdata()
        Try
            Dim dacontcom As New SqlDataAdapter
            ds.Tables("ContactsCom").Clear()
            Dim spgetconcom As New SqlCommand("spgetconcom", sqlcon, Nothing)
 
            spgetconcom.CommandType = CommandType.StoredProcedure
 
            dacontcom.SelectCommand = spgetconcom
 
            sqlcon.Open()
            dacontcom.Fill(ds, "ContactsCom")
 
 
            sqlcon.Close()
 
            Me.cbocompany.DataSource = ds
            Me.cbocompany.DisplayMember = "ContactsCom.CompanyName"
            Me.cbocompany.ValueMember = "ContactsCom.ContactID"
 
        Catch ex As Exception
            MsgBox(ex.ToString)
 
        End Try
    End Sub

Now I can't quite get my head out of a VBA mindset, but basically how do I do the below in .net

Private Sub cbocompany_AfterUpdate()
popfields(me.cbocompany) ' me.cbocompany would give me the contactid
End Sub

As always any help would be very much appricated.

[jmcilhinney]

What update is this event supposed to be raised after and what is popfields supposed to be doing? If you mean after the DataSource is assigned then there is a DataSourceChanged event. If you mean after the user selects an item then there is a SelectedIndexChanged event.

[Oliver1]

Sorry popfield is just a function that puts data in other fields depending on the item the user has selected from the combo box.

I got this far

Private Sub cbocompany_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbocompany.SelectedIndexChanged
        popfields(Me.BindingContext(ds, "ContactsCom.ContactID").Current())
    End Sub

But I think I should reference the value in the combo box rather than the datatable (even though i think the should be the same). My problem is the above works but it is always one record behind, eg the contactid is not the record that has just been selected, it's the previous record.

[Phill64]

you can use cbocompany.SelectedItem to get whatever item the user has selected. Although i havnt ever used binding so i dont know if that doesnt work with it, but in normal context hat is how to do it

[Oliver1]

Thanks
popfields(cbocompany.SelectedValue)
works and overcomes the other problem I had.