Creating datatable from 2 datatables created at runtime VB.net

Question

I have a pretty long code which creates two datatables and fills them with data at runtime. And i need to create one table, but not the way merge does it but like adding columns from one datatable as new columns(but filled with data) to the other one. Best example i can thing of is Join in SQL but i will try to draw some example. I can not put my code here as i said it't too long.

Example: (only column names but imagine that under each |something| is a lot of rows)

Table1:

Date|AA|AA2|AA3|AA4|AA5|AA6|

Table2:

Date|BB|BB2|BB3|BB4|BB5|BB6|

Result:

Date|AA|AA2|AA3|AA4|AA5|AA6|BB|BB2|BB3|BB4|BB5|BB6|

There are a whole lot of "it depends" here. For example, is this a one to one relationship? Same number of rows in each table? I'm curious, why would you want to do this? — Prescott Chartier
– Prescott Chartier, Commented May 31, 2018 at 17:55
Welcome to Stack Overflow. Please read How to Ask and minimal reproducible example so that you will get better help. — pfx
– pfx, Commented May 31, 2018 at 18:08

TnTinMn · Accepted Answer · 2018-05-31 18:35:33Z

1

The DataTable.Merge method is perfectly capable of yielding your desired result. As your two tables have only one column in common Date, I am assuming that it is PrimaryKey of at least Table 1.

Dim dt1 As New DataTable
Dim pk As DataColumn = dt1.Columns.Add("Date", GetType(DateTime))
dt1.PrimaryKey = {pk}

dt1.Columns.Add("C1")
dt1.Columns.Add("C2")
dt1.Rows.Add(#1/1/2018#, "c1", "c2")

Dim dt2 As New DataTable
Dim pk2 As DataColumn = dt2.Columns.Add("Date", GetType(DateTime))

dt2.Columns.Add("C3")
dt2.Columns.Add("C4")
dt2.Rows.Add(#1/1/2018#, "c3", "c4")
dt2.Rows.Add(#1/2/2018#, "c3a", "c4a")

Dim dt3 As DataTable = dt1.Copy
dt3.Merge(dt2)
DataGridView1.DataSource = dt3

This code yield this result:

answered May 31, 2018 at 18:35

TnTinMn

11.8k3 gold badges21 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Creating datatable from 2 datatables created at runtime VB.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related