set up a datagrid of multiples datatables in 1 dataset

[Richard Loupatty]

I have a few tables consisting two columns each.
They all have the same first column (unique key)

What I want to do is show a datagrid, starting with the first column
followed
by the rest. Actually put the tables behind each other.

Is there anyone who could show me the way how to do this

I did manage but it has a bad performance.
What I did was filling up row by row

Richard Loupatty

 

[Rick Spiewak]

This sounds like it can be done with a Join in your select statement, to
build a result set according to what you want and putting it into a DataSet.

 

[Richard Loupatty]

This project works with DBF so I didn't know if the join works for this.
I solved it now with the joinview sample from Microsoft knowledge base.