Appending two data tables

[Guest]

Hi -

I'm looking for a code sample that will let me append a data table to a
second master data table. You can assume that the tables' structures are
identical.

Seems like there should be a method to do this, but I can't find one.

Thanks,
Mark

 

[Cor Ligthert [MVP]]

Mark,

DataTable.Merge

http://msdn2.microsoft.com/en-us/library/system.data.datatable.merge.aspx

Be aware that this works conform the constrains of that datatable, therefore
adding will only be if the keys of the new one are really different and
higher than the old one.

I hope this helps,

Cor

 

[Guest]

Merge works for .NET Framework 2.0. (I'm running 1.0)

I used the ImportRow method:

For i = 0 to dt.rows.count - 1
dtMain.ImportRow(dt.Rows(i))
next i


Thanks for your comments