How to Fill ComboBox with DataTable Column Names in VB.NET?

Question

I need to fill a combobox on a form with the column names from an existing data table. I don't want to manually enter the column names in case they change in the future. I also want to keep my code tidy, so I don't want a standard loop. How can I fill a combobox with the column names most efficiently?

score 2 · Accepted Answer · answered Jan 07 '19 at 19:24

Thanks to examples from here, here, and here, I was able to piece together the following LINQ query and set it directly to the data source on the combobox when the form loads.

Private Sub Form_Load(sender As Object, e As EventArgs) Handles Me.Load
    comboBox.DataSource = (From dc In dataTable.Columns
                             Select dc.ColumnName).ToArray()
End Sub

How to Fill ComboBox with DataTable Column Names in VB.NET?

1 Answers1