Hello all.
I need to pull data from two different databases in order to return some
results for a web page I am working on. How can I do this using the same sql
connection? Here's what my select statement looks like (pseudocode):
SELECT *
FROM db1.table1, db2.table1
WHERE db1.table1.UserID == db2.table1.UserID

Here is my code to connect to the database (I'm using MySQL);
string SQLQuery = "SELECT * FROM users";
OdbcConnection ODBCConnection = new OdbcConnection(connectionString);
try
{
  ODBCConnection.Open();
  OdbcDataAdapter ODBCAdapter = new OdbcDataAdapter(SQLQuery, ODBCConnection);
  DataTable dataTable = new DataTable();
  ODBCAdapter.Fill(dataTable);
}

SuperStruct -

You can acheive this by simply calling "Fill" using two different DataAdapters, with commands (and connections) pointing to two different databases. In other words, just call Fill twice.

Sahil Malik
http://blah.winsmarts.com