Stacking/Joining Two Datasets

Hi Thanks for clicking.

We have two Datasets with exactly the same schema!

Dataset1 contains, lets say 10 records.
Dataset2 contains, lets say 20 records.

We would like to join these together to create a Dataset of 30 records thats bound to a DataGrid. ( a bit like UNION in sql). This way we can see all the records in the DataGrid.

The importance of this is, we can update Dataset1, Dataset2 or Dataset1 AND Dataset2 depending on certain conditions. Allows complete flexability!

Can anyone help??

Thanks Rob
Who is Participating?
dampseyConnect With a Mentor Commented:
if the column names are equal (same with using union)
you can use merge function

RobKearneyAuthor Commented:
Perfect. thank you
All Courses

From novice to tech pro — start learning today.