Query tables from multiple data sources

[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

 

[Miha Markic [MVP C#]]

Hi Jitendra,

HOW TO: Implement a Custom DataView Class in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;325682

HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326080