Copying a datatable from one dataset to another was not that straightforward as I thought.
Dim dsSource As New DataSet
Dim dsDestination As New DataSet
‘Your way to get data from XML or DB.
dsSource = object.getdata()
dsDestination = object.getmoredata()
‘This is important, without this it will result in error
‘when you try to copy the datatable from one dataset to another
dsSource.Tables(0).TableName = “NewTableName”
dsDestination.Tables(0).Tablename = “SomeTable”
dsDestination.Tables(1).Tablename = “NewTableName” ‘The one we copied from other Dataset
Note 1 : When you are using more than one datatable in a dataset it is advisable you name the datatables.
Note 2 : These kinds of scenarios arise, when you are trying to establish Relation between datatables in a dataset.
(Cascading master – detail relation)