DataTable joins

[J055]

Hi

I have two different DataTables populated with rows from separate queries.
They both share the same column ID. I would like to create a new DataTable
where the rows in both tables match, i.e. like using an SQL inner join.

What would be a good approach to solving this?

Many thanks
Andrew

 

[Earl]

I would suggest using Merge. If merging the two tables does not give you
what you want, use a DataSet.Merge and MissingSchemaAction.Add.

 

[Cor Ligthert [MVP]]

The best is of course using a join if not you can fake it.

This is one of the possibilities to fake a join
http://www.vb-tips.com/dbPages.aspx?ID=5fd5a8cf-54dc-4946-a193-8a9529b2b38b

I hope this helps,

Cor

 

[Adrian Moore]

J055,

Try www.queryadataset.com. Its allows joining data in DataTables.

Ad.