Show data from a SqlConnection and a OleDbConnection in one table

  • Thread starter Thread starter Torben Laursen
  • Start date Start date
T

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
 
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.
 
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)
 
Back
Top