Dataset.merge() Question

[binayak]

I have a table A in a db which has only one column. I want to merge this table with with table B which has the same column and 3 other columns.
I want to merge B into A and populate the changes in the A table in the db.
Is this possible (changing schema of the table) using dataset.merge method?

Please send me some sample code or pointers.

Binayak

[binayak]

Well, if I specify the MissingSchemaAction.Add then I can see in the watch window the schema for the table A is changed. BUT, if I use the adapter.update (ds, "datatablename"). the schema change is not reflected in the db?

Can anyone tell me why?