Update table

[Tapiwa (TapiwaMakamure)]

I got 2 same tables from 2 different databases. Table 1 database 1 changes everyday with new details. I update tble 2 database 2 with details which are in table 1 database1. Whats the easier way of updating table 2 frequently withought dublicating records.

[hasib08 (Motiwala Hasib)]

You can use the Default view for Datatable 1 and get the unique rows and append that rows in second Datatable.

datatable1.DefaultView.ToTable(True,“Column Name”)

Thanks