Cloning rows in a dataset/datatable.
C#
1
Posts
1
Posters
0
Views
1
Watching
-
I'm literally trying to clone data rows, nothing very complicated, infact, they aren't even going to be changed during this section of the project. I've captured the rows I want to clone using a custom SQL query, but I'm not sure how to insert them back into the database with new ID's(primary key is autonumber)... can't I just run a .update of some sort? I've tried copying the data table from results of my query and merging into the complete table, that doesn't make any change. I dont seem to be able to .insert anything other then independant values for each column. I'm using VS 2005 and C#. Thanks.