Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
For i = 0 To YourDataTable.Rows.Count - 1
YourNewDataTable.Rows.Add(YourDataTable.Copy.Rows(i))
Next
...
And another loop here for the second datatable.
''Add datatables to the datasets, one table per dataset.
Dim ds1 As New DataSet
ds1.Tables.Add(dt1)
Dim ds2 As New DataSet
ds2.Tables.Add(dt3)
''This is the final dataset with the merged rows.
Dim dsNew As New DataSet
dsNew.Merge(ds1)
dsNew.Merge(ds2)
''Now create a final datatable from the final dataset.
Dim dtNew As New DataTable
dtNew = dsNew.Tables(0)