Merging Datasets

[Jon Vaughan]

I have 2 datasets , one returned as a dataset from a webservice and one
created client side form the same stored procedure that is returned from the
webservice. I then try and merge the data, but they dont seem to merge.

When I return a single table , this method works fine, but im returning 3
tables and the merge isnt happening. Is there anyway to find out how I can
why a merge isnt occuring, as the merge doesnt return any errors,

 

[Cor Ligthert [MVP]]

Jon,

Be aware that the tables inside the dataset need equal table names and that
the datatables in that needs to have exactly the same description as well as
primary keys.

Here a simple sample.
http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a

I hope this helps,

Cor

 

[Jon Vaughan]

Cor,

can you dig out that link again, as its page cannot be displayed.

thanks

 

[Cor Ligthert [MVP]]

Jon,

For me it works completely

http://www.vb-tips.com/dbpages.aspx?ID=edb1409d-5394-468f-a63f-de3a5d92b14a


Cor

 

[adm]

Jon,

Here is the same link Cor posted:
http://tinyurl.com/g9ogz

I have had similar trouble merging datasets on occasion.

If you can't get the dataset to merge, try using the merge method of
the data tables rather than the dataset. Even if you only do so for
debugging purposes, it will help you narrow down where the problem
lies, and you can go from there.

adm

 

[Jon Vaughan]

great tip ad, thanks !

Jon,

Here is the same link Cor posted:
http://tinyurl.com/g9ogz

I have had similar trouble merging datasets on occasion.

If you can't get the dataset to merge, try using the merge method of
the data tables rather than the dataset. Even if you only do so for
debugging purposes, it will help you narrow down where the problem
lies, and you can go from there.

adm

 

[Jon Vaughan]

Seems merging tables is new to Framework 2

great tip ad, thanks !

 

[Cor Ligthert [MVP]]

Seems merging tables is new to Framework 2

Yes

Cor