Joining two tables from different databases

microsoft.public.dotnet.framework.adonet

7 Nov 2005 8:39 PM

Dean Perry

I have a table from a SQL Server database and a table from a Foxpro
database loaded into a dataset. There is a one-to-one relationship
between the tables although there may not be a record in the SQL table.
I would like to display the Foxpro data in a datagrid and mark the row
if there is a matching record in the SQL table.

Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***

11 Nov 2005 3:03 PM

Mary Chipman [MSFT]

I'd write a stored procedure in SQL Server that returns the rows.
Whenever you're performing heterogeneous joins you have to pull in all
of the rows for both tables. This will likely go faster if you do it
on the server.

--Mary

On Mon, 07 Nov 2005 12:39:09 -0800, Dean Perry
<dean.pe***@verichipcorp.com> wrote:

Show quote

>I have a table from a SQL Server database and a table from a Foxpro
>database loaded into a dataset. There is a one-to-one relationship
>between the tables although there may not be a record in the SQL table.
>I would like to display the Foxpro data in a datagrid and mark the row
>if there is a matching record in the SQL table.
>
>Any ideas?
>
>
>*** Sent via Developersdex http://www.developersdex.com ***