I am using Visual Studio 2012 (C#) and SQL Server 2008. I would like to create a single DataSet in Visual Studio (C#) that accesses and binds tables from both separate databases.
I tried doing this by ...
1. Creating a new DataSet in C# (VS 2012)
2. Added a connection to each Database in Server Explorer (VS2012)
3. Added the desired objects from each database on the DataSet palette.
VS didn't would only allow me to choose one of the Database objects at a time. In other words I could only choose one of the databases at a time.
Does anyone know how to do this?
would it be better to use the Linked server function in SQL Server?