Please, read my comment to the question.
As per my understanding, you should bind all colums to result list, as MSDN states:
Quote:
The DataGridView class supports the standard Windows Forms data-binding model. This means the data source can be of any type that implements one of the following interfaces:
- The IList interface, including one-dimensional arrays.
- The IListSource interface, such as the DataTable and DataSet classes.
- The IBindingList interface, such as the BindingList(Of T) class.
- The IBindingListView interface, such as the BindingSource class.
This is how you can achieve that:
Dim table = (...).ToList()
DataGridView1.DataSource = table
See:
DataGridView.DataSource Property (System.Windows.Forms)[
^]