How to merge two datasets?

[Lexa1983]

There is table with name TableName in first dataset Id Name Selected ---------------------- 1000 Name1 0 1001 Name2 0 1002 Name3 0 There is table with the same name in second dataset Id Name Selected ---------------------- 1000 Name1 1 How can I merge them to get this: Id Name Selected ---------------------- 1000 Name1 1 1001 Name2 0 1002 Name3 0 I prefer to do this by using Merge method, but not with foreach...

[Guffa]

Where do you get the datasets from? If you fetch them from a database, you can easily merge them in the query. Example: select Id, Name, Selected from Table1 union select Id, Name, Selected from Table2 order by Id --- b { font-weight: normal; }

[ayuba asia]

u can try to use the ADO dataset merge functin [URDATASET].Merge([URANOTHER DATASET] i may work and works for me last time

[Ista]

Merge will only merge tables into the dataset not the actual table. Calling ImportRow on the target table will do what you want. You much better off to put this action into a stored procedure get the result into a table. Your trying to do a set method in an ISAM structure. It wont work. I'm not an expert yet, but I play one at work. Yeah and here too. -- modified at 20:16 Sunday 11th December, 2005