DataAdapter Update

[Jim Heavey]

I have an update screen which is designed such that the user makes a few
selection and then the data that matches that selection criteria is
retrieved using the DataAdapter.

The user is then free to make adds/changes/deletes as necessary. They then
can make additional selections which will require the retrieval of data
which matches that criteria.

If I want to delay making any updates to the table until the user logs out,
how can this be done if I am "constantly" refreshing the contents of the
data table with new rows.

Should I copy the update rows into another Table which accumulates all
changes to date? If this is the approparch to take, if the user makes
selection again to bring back rows which are already in the "holding"
table, how can I merge the two tables giving the appearance that the
updates have already been made to the table?

Thanks for your assistance!!!

 

[Miha Markic]

Hi Jim,

I have an update screen which is designed such that the user makes a few
selection and then the data that matches that selection criteria is
retrieved using the DataAdapter.

The user is then free to make adds/changes/deletes as necessary. They then
can make additional selections which will require the retrieval of data
which matches that criteria.

If I want to delay making any updates to the table until the user logs out,
how can this be done if I am "constantly" refreshing the contents of the
data table with new rows.

IMO you should load new data into a clone table and then do the Merge with
preserveChanges = true.
It won't touch the edited rows.

Should I copy the update rows into another Table which accumulates all
changes to date? If this is the approparch to take, if the user makes
selection again to bring back rows which are already in the "holding"
table, how can I merge the two tables giving the appearance that the
updates have already been made to the table?

See above