Updating with a Typed Dataset

[liam]

Hi,

My situation is this...

I have a webservice which returns a typed dataset
containing information that is to be used to update a
database on the client. The database on the server is
the same as the database on the client (except for the
data, of course).

My problem is that I don't know how to get the new
information into the database.

My approach so far is to create a dataset on the client
which contains the current information and then get a
dataset from the server which contains the updated
information. I could then theoretically merge the
datasets so that I have a dataset with the all the
changes.

I would then need to update the database through a
dataadaptor. This is the part that I am stuck at. I'm
not sure how to set up the dataadaptor properly. The
data contained in the dataset is generated from a number
of stored procedures and I don't know how to set the
Update command on the dataadaptor to reflect this.

Any suggestions on how to proceed would be appreciated.

liam

 

[Cor Ligthert]

Liam,

That it is a typed dataset is in my opinion not important.

Your problem lies in the update state of the rows on the client side
database (assuming it are not only inserts).

I think that I would tackle your problem by reading first on the client the
same dataset.

Update that using the retrieved one from the webservice (can probably very
much generic when you not use the strongly typed commands)

And than update my database again

Just my thought,

Cor