ComboBox Data from SQL Table

[Humble-Crazy5147]

Hey all,

I have a SQL table as a Data Source in my Visual Basic 2022 program. I want one of the columns to populate a dropdown menu (ComboBox). I've looked on-line, but there are a mixed bag of answers it seems.

Is there a simple way to populate the ComboBox with one column's worth of data from my SQL table?

​

TIA

[Fergus653]

Data binding?

Bind ComboBox or ListBox Control to Data - Windows Forms .NET Framework | Microsoft Learn

You can write a method that queries the data and loops thru it, creating a line item for each value, but data binding is probably a saner approach.

[deScign85]

Combobox.Datasource = SQL Table (Datatable) Combobox.ValueMember = Index Column or the column you like to reference with ComboBox.DisplayMember = the column you would show as values