Groups | Blog | Home
all groups > dotnet ado.net > august 2007 >

dotnet ado.net : Problem with data table manipulation prior to update



B. Chernick
8/27/2007 11:50:07 AM
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
B. Chernick
8/27/2007 12:40:03 PM
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....)

[quoted text, click to view]
Cor Ligthert[MVP]
8/28/2007 12:00:00 AM
B.

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

Cor



"B. Chernick" <BChernick@discussions.microsoft.com> schreef in bericht
news:4607FAAC-7B33-4356-BFA0-48DB51E48F56@microsoft.com...
[quoted text, click to view]
AddThis Social Bookmark Button