Problem with data table manipulation prior to update

[Guest]

I'm passing a data table to a form. This table is then bound to a binding
source which is in turn bound to a datagridview so that only a subset of the
table is ever displayed (filters by key). This form is your basic dialog
with OK/Cancel buttons.

For reasons too complicated to explain, what I need to do is be able to pass
this same data table multiple times to this same form, make multiple
adds/mods to the table (for a given key) and then either accept or reject
each batch of adds/mods. All of this is to take place without updates to the
database. The update is supposed to happen only once much later on.

When I simply try to loop through the datatable and removing unwanted new
rows, I get RowNotInTableException errors (This row has been removed from a
table and does not have any data. etc...)

What would be a good approach to this problem? Anything I'm missing? (This
feels like deja vu.)

 

[Guest]

OK. Cancel this. I'm going to answer my own question (I hope)

After passing the datatable to the form, I copied it, so that all
manipulation is with the copy. If the user hits OK, the duplicate table is
copied back the original.

(Of course, I'm assuming a relatively small table, hopefully no more than a
few hundred records. Seems to work, so far....)

 

[Cor Ligthert[MVP]]

B.

This is normal behaviour, delete (not remove that does not update the
database) them upwards.

Cor