Is there a way to clone/duplicate a table row in asp.net using a row as default data?

I basically want to take a row of data, in a number of tables with different schema, and call it the "default" and clone it each time as a starting point, simply giving it a new primary key and then offer it up as the default if you do nothing in that table.  I want to do this in codebehind and don't want to use any datacontrols like gridview,etc.
So say I have Table1, Table2, Table3, Table4
Table 1 Row1: PKey,Col1,Col2,Col3,Col4
Table 2 Row1: Pkey,ColA,ColB
I want to duplicate it as:
Table 1 Row500: 500,Col1,Col2,Col3,Col4
-and
Table2 Row 224: 224,ColA,ColB
Table3 something else, Table4 something else, etc.
I saw this thread http://forums.asp.net/t/1429981.aspx?Clone+Copy+existing+table+row.  However, it is closed and the link in th ...