Merging 2 datasets: Want Union of both

  • Thread starter Thread starter akeserla
  • Start date Start date
A

akeserla

I wanted to know the easy/right way to accomplish the task of creating
a union of 2 datasets.

I have 2 dataset of the same type and I want to merge them to create an
union of both. I want to create a dataset that contains the union of
both. I have tried searching for this but with no much success. Merge
just overwrites the target dataset with the source dataset

The dataset has primarykeys/relations etc. I dont plan to update it
back to the database (it is used in a read only fashion).

Afaik at this moment AddRows or ImportRows is the only logical thing I
can see..
 
You might be interested in the assembly I've been working on at
http://www.queryadataset.com. It lets you perform complex SQL SELECT
statements including UNION, JOINS, GROUP BY, HAVING, ORDER BY, sub-queries,
etc against the tables in a dataset.

While it is currently limited to querying a single DataSet, if this assembly
looks like something useful for you, I can probably find a solution to solve
your problem.

Contact me if you are interested.
Adrian Moore
http://www.queryadataset.com
 
Back
Top