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?

phrebh · Accepted Answer · 2019-01-07 19:24:51Z

2

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

answered Jan 7, 2019 at 19:24

phrebh

1602 gold badges4 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related