I have two datasets with identical schema. Each one is filled by a separate DataAdapter. When the first dataset is filled by its DataAdapter, it contains a table with rows of values. The second dataset, after it is filled, contains an empty table (i.e. there is no data in the backend database yet).
What is the best way to get all the rows from the table in the first dataset into the empty table in the second dataset?
What is the best way to get all the rows from the table in the first dataset into the empty table in the second dataset?