Copy a row using ADO.Net
Posted on 2011-02-22
I need to duplicate an existing row in a table. Before finishing the Insert of the new row, I need to change a few fields. Also, I do not want to copy the last field in the row as it is an Identity field.
I would like to use a For Next loop so I do not have to write out all the field names.
I would like to ADO.Net to do this.
Is there an ADO.net ZONE on Experts Exchange? I looked but could not find it. If there is would you please post the path.