Search code examples
vb.netvisual-studio-2010datagridviewdatatable

VB: How to bind a DataTable to a DataGridView?


I know this is a basic question that has already been answered thousand times, but I can't make it work.

I am working in Visual Studio 2010 and have two forms in my Windows Application. In the first one (Main.vb), the user enters his inputs and the calculation takes place. In the second one (DataAnalysis.vb) the calculation results are displayed.

In Main.vb, I create the temp table that will contains all the intermediary calculation steps:

Dim tableTempJDL As DataTable = New DataTable("TempJDL")
Dim column As DataColumn

column = New DataColumn("ID", GetType(System.Int32))
tableTempJDL.Columns.Add(column)

column = New DataColumn("PthObjekt", GetType(System.Double))
tableTempJDL.Columns.Add(column)

'further columns are after created using the same method

Then, in DataAnalysis.vb, I try to display the DataTable tableTempJDL into the DataGridViewBerechnung:

Public bindingSourceBerechnung As New BindingSource()
Me.DataGridViewBerechnung.DataSource = Me.bindingSourceBerechnung

But then I don't understand how to fill the DataGridView...


Solution

  • Simply, you can make your table as the datasource of bindingsource in following way:

     Me.bindingSourceBerechnung .DataSource = tableTempJDL
    

    Later on, you can bind above binding source in your datagridview in following way:

     Me.DataGridViewBerechnung.DataSource = Me.bindingSourceBerechnung