Member Avatar for NtheN 
SELECT        airplanes.ID_airplane
FROM            (airplanes LEFT OUTER JOIN
                         airplanes_hangar ON airplanes.ID_airplane = airplanes_hangar.ID_airplane)
WHERE        (airplanes_hangar.ID_airplane IS NULL)

This is the vb code.

Me.AirplanesTableAdapter.superawesome(Me.Hangar_DataSet.airplanes)

I want to pass the values returned to a combobox, or a string, doesn't matter i can take it from there.

Can someone tell me how can I do that?

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by poojavb
Member Avatar for poojavb

to pass the value in combo box u can use....

 Dim conn As New SqlConnection(ConnectionString)
        Dim strSQL As String = "your sql query"
        Dim da As New SqlDataAdapter(strSQL, conn)
        Dim ds As New DataSet
        da.Fill(ds, "Tablename")
        With ListBox1
            .DataSource = ds.Tables("Tablename")
            .DisplayMember = "ColumnName" 'column name to be displayed in combo box
            .SelectedIndex = 0
        End With
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.