Copy record from one table adapter to another table adapter RRS feed

  • Question

  • I'm looking for suggestions on the best way to copy a record/row from one table adapter to a second table adapter. The second table adapter is a superset of the first. (The purpose is to archive rows from the first to the second).


    I could just take each column from the first table and  push it to the equivalent column in the second but I am hoping to do it in a more flexible way to take into account the fact that the table schemas will most likely change over time. (They will still be a subset/superset of each other)


    I tried a foreach approach but the row in the table adapter doesn't have an enumerator.


    I suspect that there may be a simple/obvious way but I am missing it.





    Tuesday, April 29, 2008 2:16 PM