grwallace
asked on
ado.net flag an existing row as a new row
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.