problems with datatable update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a datatable which is bound to a database table.
the table has a primary key on 1 field and i am using the machine
generated statements from the sql data adapter.

here is the scenario

two users are using different instances of the application

if I use the dataset.fill command,
i can propogate changes made by one user, to another user.
however, if a user deletes one of the primary keys, and inserts another in
it's place, the other users datatable has a phantom row.
has anyone noticed this problem and what is a good workaround
thanks
 
First off, I highly recommend you stop using the wizards to generate
statements for you.

Secondly, what you should do is inform user 2, that this row has changed
since the last snapshot of the data was taken. You may then want to present
some options of what to do next (refresh the screen, overwrite changes, etc)
depending on what makes sense in your situation.
 
Back
Top