Append data to the already existing dataset?

[jmcilhinney]

If the two DataTables have the same schema you can use the ImportRow method of the target table to copy the contents of each row in the source table to a new row in the target.

For Each row As DataRow In sourceTable.Rows
    targetTable.ImportRow(row)
Next row