ado.net flag an existing row as a new row
Posted on 2011-09-15
I wish to read in an order from last week, change the date and maybe a couple of other things then write it out as a new order.
I have tried setting the Id to -1 but that doesn't work - all that I get is Error Concurrency Violation.
It does work if I manually create a new datatable using NewRow which I can continue to do if necessary, but it would be a lot easier if I could simply fill the DataTable, change my values and apply the Update() method.