Click here to Skip to main content
15,913,944 members
Search within:


With dataset How to retrieve data from two databases like oracle and sql server and merge them in one dataset ?
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
With dataset How to retrieve data from two databases like oracle and sql server and merge them in one dataset ?
Posted
Add a Solution
Comments
OriginalGriff 14-Aug-13 14:45pm    
Please do not post teh same question twice - I have deleted the spare.
[no name] 14-Aug-13 14:55pm    
Get dataset from Oracle, get dataset from SQL Server, merge dataset.

1 solution

Step 1: Execute Oracle query and load the result in one dataset
Step 2: Execute SQL Server query and load the result in another dataset
Step 3: Create Third Dataset and manually merge both oracle and sql server dataset
Step 4: Return the dataset result to Presentation layer
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to return dataset from Oracle Database
How to receive two sql statement in one dataset with one table
Viewing Data from two datasets in Report
How to retrieve data from two tables merge in SQL server?
Merging two datatable in one dataset
C# dataset data filtering
Is it possible two datasets for One Tablix In SSRS
Merging dataset of Diffferent Datasources into one DataSet
need help to merge two datasets
Data Adapter unable to update after Dataset Merge method

Advertise
Privacy
Cookies
Terms of Use
Last Updated 15 Aug 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-05-30:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900