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" <riclo@trashnet.nl> wrote in message
news:3f17292f$0$153$edd6591c@news.versatel.net...

> 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
>
>
>
>

[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.

"Rick Spiewak" <rickspiewak@mindspring.com> schreef in bericht
news:OZPHAcSTDHA.3500@tk2msftngp13.phx.gbl...

> 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" <riclo@trashnet.nl> wrote in message
> news:3f17292f$0$153$edd6591c@news.versatel.net...

> > 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
> >
> >
> >
> >

>
>