Merge wont work??

[venerable bede]

I have the following code to write an xml file from "rsPick" and then merge "rsPick" with "rsArchive"


'''''''''''''code''''''''''''''''''
dsPick.WriteXml("C:\mydata.xml")

daArchive.FillSchema(dsArchive,SchemaType.Source, "tblPick")
daArchive.Fill(dsArchive, "tblPick")

dsArchive.Merge(dsPick)
daArchive.Update(dsArchive, "tblPick")
'''''''''''''''''''''''''''''''''''''


The xml file is written away succesfully but when I look at "tblPick" which is the access table acting as the source for dsArchive no new rows have been added!

What am I doing wrong?

Both schemas are similar.
This is driving me nuts.

[Edneeis]

a dataset can have multiple tables, see if it added another table to the dataset with the other datasets info.

[venerable bede]

I know this is going to sound pig ignorrant Edneeis
but how?

I am not sure what you mean. Where do the tables come into play. I thought we where dealing directly with datasets.

[Edneeis]

A dataset is a collection of datatables which is a collection of datarows which is a collection of datacolumns.

One way to find out is to call:
Msgbox(dsPick.Tables.Count)

before the merge and then again after.

[venerable bede]

I tried your messagebox :

Msgbox(dsPick.Tables.Count)

the result was 2. What does this mean? I am still struggling with this.

[venerable bede]

What I mean to say is that before the merge operation I have 1 table, and after I have 2 but the underlying database remains unchanged!

[Edneeis]

See it is merging the datasets not the tables. Also the database wouldn't be updated until you used the dataadapter again to update it, since all data is by default disconnected. You may want to loop through and add all the rows in the one to the table in the other.

'something like this
dim dr as DataRow
For Each dr in ds1.Tables(0).Rows
  ds2.Tables(0).Rows.Add(dr)
Next