Merging typed datasets

[liam]

I have two typed datasets, ds1 and ds2.

ds1 is the original dataset.

ds2 is another dataset with some updates.

I call:

ds1.Merge(ds2, False)
ds1.AcceptChanges()

But the information in ds2 has not be transferred to
ds1! Is there anything that I am missing here?

thanks,

liam

 

[Sahil Malik]

Really can't tell why exactly why this is happening without being able to
see datasets. But ds1 will sort of "override" ds2's changes. So you might
want to tweak primary keys, rowstates etc to get the desired results.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Guest]

hello

You can try looking at the link i have below, i had the same trouble and
there was something about giving both datsets the same name before they would
merge,

MyCommand = new SqlDataAdapter("exec s_get_table1", MyConnection)
DS1 = new DataSet()
MyCommand.Fill(DS1, "MyTable")

MyCommand = new SqlDataAdapter("exec s_get_table2", MyConnection)
DS2 = new DataSet()
MyCommand.Fill(DS2, "MyTable")

ds1.merge(ds2)



http://aspalliance.com/articleViewer.aspx?aId=148&pId