joining datatables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Am I going to have a problem with speed by doing this iterative process?
 
Am I going to have a problem with speed by doing this iterative process?
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linq to SQL - Return DataTable as a result of Linq query 3
SQL to Linq with join 2
Adding datatable data to sql database. 1
Parallel.For to retrieve DataTables 1
LINQ syntax question 1
DataTable Subset to new DataTable 1
help me use less memory! 6
Insert from a DataTable 1

Back
Top