Let's say that I am having two Dataset objects ds1 and ds2. These DataSets have exactly the same schema. Same DataTable (only one) in each DataSet and same DataColumns. Can anyone tell me, how can I join these two DataSets into a third one, so that the new one will have the DataRows of ds1.Tables[0] followed by the DataRows of ds2.Tables[0]?

The language I am writing the project is C#.

.::YF::.

I think if you have all of your table in a unique DataSet object then you can work with them better and easier...
i.e you can make a relation(DataRealation object)between two DataTable objects in your unique dataset object then you can through two loops get your results in third DataTable object
I am not sure if its possible between two datatable objects in different dataset objects.
wait for other opinions.

--------------------------------------------
Mehdi.:)

Is there a reason why you don't join these in SQL?

J

I would recommend using the UNION function in SQL. That is,

SELECT column1, column2
FROM table1

UNION

SELECT column1, column2
FROM table2


That will append the rows from the second SELECT to the end of the first SELECT.

- - - - - - - - - - - - - - - - - - - - - - -
In God we trust, everything else we test.

Hi all,

I also have the similar requirement. I also want to add take the union of two data sets. One data set is the result of the stored procedure and another is the result of one API.

Kindly help me out.
Tushar