I am trying to merge two dataset containing same datatype information.
One dataset is filled by adapter using SQLserver connection and other dataset is coming from oracle dataset.
i am using following code.

 Dim FinalDS As New DataSet()
 FinalDS.merge(SQLds)
 FinalDS.merge(Orads)

 but FinalDS at the end contains only SQlds data
(It contains only ORAds data if i merge that one first)

I checked the datatypes of columns in the datasets and those are identical. What else could be problem.

PS : i was able to merge two datasets if they both come from either Oracle or SQL server.

Thanks
Sanjay

perform your action as per following logic:
Dim FinalDS As New DataSet()
FinalDS.merge(SQLds)
FinalDS.merge(Orads, true)

Hope this will solve your problem

I tried that and it doesn't work; Same results.
Thanks
Sanjay