Merge in new data but keep existing changes

[Steve Amey]

Hi all

I have a function that gets information from a database and merges the
DataTable into a DataSet that some controls are bound to. What I would like
is for the information to be merged in but to retain any changes the user
has made to the local data. The reason being, I have a bunch of TextBoxes
and a list, the refresh function will need to update the list with any
changes that have been made in the database, but if the user has changed
some of the values in the TextBoxes, I would like to keep them.

Does anyone know what the best way to do this would be?

Regards,
Steve.

[Cor Ligthert]

Steve,

One of the strangest commands in ADONET is in my opinion the
Dataset.getchanges (Strange because mostly it is a reference however this
makes a copy of the changes that are done), can that be a solution for you
or do I understand your problem wrong?

http://msdn.microsoft.com/library/de...angestopic.asp

It is there as well as a datatable.getchanges

I hope this helps?

Cor

"Steve Amey" <stevea@centurion-ms_RemoveThis_.co.uk>

Hi all

I have a function that gets information from a database and merges the
DataTable into a DataSet that some controls are bound to. What I would
like
is for the information to be merged in but to retain any changes the user
has made to the local data. The reason being, I have a bunch of TextBoxes
and a list, the refresh function will need to update the list with any
changes that have been made in the database, but if the user has changed
some of the values in the TextBoxes, I would like to keep them.

Does anyone know what the best way to do this would be?

Regards,
Steve.