Hello!

I am fairly new to VB, but I am picking things up quickly and very much enjoying coding with VB 2005.

I have a problem populating a Listbox... I wish to populate this listbox using a sql command. I have a feeling it maybe the event which is wrong but being a newb I'm sure someone will correct me.

Code:
    Private Sub lstEngineer_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstEngineer.SelectedIndexChanged

        sql = "select * from Engineers where Engineers.Busy = '0'"

        Dim commandUpdate As New OdbcCommand(sql)
        Using connection As New OdbcConnection(constring)

            commandUpdate.Connection = connection
            connection.Open()
            commandUpdate.ExecuteNonQuery()

        End Using
Thanks very much!