Here's the situation:
I have two DB connections ConnA (DB2) and ConnB (SQL Server).
I need to bind a datagrid to the results of a query which joins a table from ConnA to a table from ConnB.
Can someone please tell me how I should be going about this?
I'm relatively new to asp.net so I'm only familiar with associating a Command object with a single DBconnection (then binding the datagrid with a datareader). It doesn't seem like the good old standby is going to work in this case...
I have two DB connections ConnA (DB2) and ConnB (SQL Server).
I need to bind a datagrid to the results of a query which joins a table from ConnA to a table from ConnB.
Can someone please tell me how I should be going about this?
I'm relatively new to asp.net so I'm only familiar with associating a Command object with a single DBconnection (then binding the datagrid with a datareader). It doesn't seem like the good old standby is going to work in this case...