I have a typed data set, with two tables.  This is an in memory data set,
that is there is no underlying database.  I would like to duplicate a record
in one of the tables and append this record back to the same table.  The idea
is to duplicate the data and have a new key is added.  The key is
auto-generated.  Is there a way to do this with out generating a new record
and then transferring the data one field at a time?

Change Connection String at runtime.
CLR Trigger Rollback
Clearing row selected from DataGridView
Provider independant Data Access
Access Autonumber problem