Query tables from multiple data sources

J

Jitendra Patil

How to fire a query on tables from multiple data sources?

For example:

ORACLE database contains Employee table: EmpID, EmpName
SQL Server Contains EmployeeSalary table: EmpID, Salary

I want to fire a query to select EmpID, EmpName, Salary from the above
2 tables residing on different databases.

I tried using ADO.Net Dataset. Create 2 DataAdapters, one for Oracle
and another for SQL Server. Populated the DataSet with the 2 tables.
Now, the problem with DataSet is that you can't create DataView from
multiple tables. Is anybody having idea how can I query the resulting
DataSet?

Thanks and Regards,

Jitendra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dataadapter.Update() multiple table update strategies 3
fill a multi-table dataset for Oracle 1
Combining results from three sources 7
Query using two tables 8
Join tables in DataSet 1
Create DataView or DataTable from DataSet 1
Multiple Data Sources 3
Compute By SQL Statement 3

Top