Append data to the already existing dataset?

[samkud]

Hi folks,

I have a dataset(global) which has already got some data in it. After some processing I get the new set of data in a new dataset, and the datatable has go the same structure as the global dataset table. I want to append this new set of data in the global dataset table. i.e if there are already 5 records in the global dataset table and now if there are 3 new records, I want to add these 3 records to the global dataset table so that there are total 8 records in the global dataset table.

Please let me know.

Thanx in advance.

Regards,

Samir.

[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

[samkud]

Thanx a lot jmcilhinney. I will try it out.

Regards,

Samir.