joining datatables

[bbdobuddy]

Hi,

I have two datatables that I want to left outer join and then do some
queries on but I having a hard time figuring out how to join the datatables
together. One of the datatables comes from a sql database and one comes
from an .dbf file

Any help would be greatly appreciated

Thanks

[ignacio machin]

Hi,

I don;t think you can do something like that in ADO.NET

What you can do is an iterative process:
loop in the rows of the first table
get the "children" rows from the second table, for this you will need a FK
relationship between the tables
That's the only way I can think of.

"bbdobuddy" wrote:

Hi,

I have two datatables that I want to left outer join and then do some
queries on but I having a hard time figuring out how to join the datatables
together. One of the datatables comes from a sql database and one comes
from an .dbf file

Any help would be greatly appreciated

Thanks

[bbdobuddy]

Am I going to have a problem with speed by doing this iterative process?

"ignacio machin" wrote:

Hi,

I don;t think you can do something like that in ADO.NET

What you can do is an iterative process:
loop in the rows of the first table
get the "children" rows from the second table, for this you will need a FK
relationship between the tables
That's the only way I can think of.

"bbdobuddy" wrote:

Hi,

I have two datatables that I want to left outer join and then do some
queries on but I having a hard time figuring out how to join the datatables
together. One of the datatables comes from a sql database and one comes
from an .dbf file

Any help would be greatly appreciated

Thanks

[Cor Ligthert [MVP]]

Am I going to have a problem with speed by doing this iterative process?

If you can not spare let say more than 100 nanoseconds for two tables from
100 rows, than you are probably in trouble, but it will definitely be very
much quicker than trying to do this over your Lan and disk and than over two
separated databases.

Cor

"bbdobuddy" <bb*******@discussions.microsoft.comschreef in bericht
news:A1**********************************@microsof t.com...

Am I going to have a problem with speed by doing this iterative process?

"ignacio machin" wrote:

>Hi,

I don;t think you can do something like that in ADO.NET

What you can do is an iterative process:
loop in the rows of the first table
get the "children" rows from the second table, for this you will need a
FK
relationship between the tables
That's the only way I can think of.

"bbdobuddy" wrote:

Hi,

I have two datatables that I want to left outer join and then do some
queries on but I having a hard time figuring out how to join the
datatables
together. One of the datatables comes from a sql database and one
comes
from an .dbf file

Any help would be greatly appreciated

Thanks