Re: SetModified not persisting to db.

Tech-Archive recommends: Speed Up your PC by fixing your registry



Also if I do the Update with the original table with the rows marked
Deleted still they are properly deleted from the database. Not what I
want obviously but it shows that the DataAdapter is functioning.

So here's new stuff I've tried with pulling the deleted rows out to a
new table still.

Marking as changed -> adapter.Update -> Operation succeeds but no
changes in db.

Setting data fields that I care about = to themselves ->
adapter.Update -> Operation succeeds but no changes in db.

Copy the 2 values out to temps -> Set the columns to bogus values ->
Accept changes on row -> Set column values back to originals (repeat
for all rows) -> adapter.Update (all rows @ once) -> Operation fails
with concurrency error that 0 of expected 1 rows were updated.



For the moment I'm going to Hack it by generating and executing UPDATE
statements directly. This seems it should be an easy operation
however, so it's frustrating me.


.



Relevant Pages