Show data from a SqlConnection and a OleDbConnection in one table

[Torben Laursen]

Hi

I have some data in a access database and some in a sqldatabase. Both us the
same index.
I can connect to both and display the results.
However now I would like to pick 2 columns from each and show the 4 columns
in one table.

Can anyone show me how to do that?

Thanks Torben

 

[Robbe Morris - [MVP] C#]

The option with the least likely instances of failure due to linking
sql server and access is to populate a DataTable for each. Then,
manually add two DataColumns to one of the DataTables and add
the values from the second.

 

[William Vaughn]

If you build a Reporting Services (or simply a ReportViewer) RDL report it
can reference as many data sources as you like and the report engine handles
the details.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)