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.)
B. Chernick - 27 Aug 2007 20:40 GMT
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....)
> 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
[quoted text clipped - 13 lines]
> What would be a good approach to this problem? Anything I'm missing? (This
> feels like deja vu.)
Cor Ligthert[MVP] - 28 Aug 2007 04:55 GMT
B.
This is normal behaviour, delete (not remove that does not update the
database) them upwards.
Cor
> 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
[quoted text clipped - 18 lines]
> (This
> feels like deja vu.)