Copy a row using ADO.Net

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.
thanks,
pat
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.
mpdillonAsked:
Who is Participating?
 
rawinnlnx9Commented:
In this part 2: http://www.4guysfromrolla.com/articles/071002-1.2.aspx of a 2 part article what you want is discussed in detail. If you need to know how to set the whole thing up start here: http://www.4guysfromrolla.com/articles/071002-1.aspx
0
 
mpdillonAuthor Commented:
RawinnInx9,
I looked at the articles, they seem to focus on datagrids which I am not using. My program does not have any user interaction and does not use datagrids.
0
 
mpdillonAuthor Commented:
It is the end of the day now and the client is kicking me out. But that looks like it will work. It will be next Monday before I return to test it.
thanks,
pat
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.