joining two tables

[=?Utf-8?B?QVZM?=]

Hi,
Ive two data tables..I need to perform a join on these datatables..
and fetch the data..I need to do it programaticlaly..
How can I acheive it...any sample code wpuld be of great help..

[Patrice]

Try :
http://www.microsoft.com/downloads/d...displaylang=en
It talks about DataRelations that allwos to bnavigate between parent and
child rows...

JOIN is rather a SQL notion. So you may want to be a bit more specific about
what you are trying to do( or you want to create a third table)...

--
Patrice

"AVL" <AV*@discussions.microsoft.coma écrit dans le message de groupe de
discussion : B1**********************************@microsoft.com...

Hi,
Ive two data tables..I need to perform a join on these datatables..
and fetch the data..I need to do it programaticlaly..
How can I acheive it...any sample code wpuld be of great help..

[Christiano Donke]

do you mean you wanna merge the tables??

dim ds, ds2 as new dataset

ds.readxml(xmlfile)

for i as integer=0 to 5
ds2.readxml(xmlfile & i)
ds.merge(ds2)
next

gridview.datasource=ds.tables(0).defaultview
gridview.databind

this worked for me when i had to do it with xml files...
to do with sql might be pretty close...
just remember, the tables must have the very same schema...
christiano.
"Patrice" <http://www.chez.com/scribe/escreveu na mensagem
news:93**********************************@microsof t.com...

Try :
http://www.microsoft.com/downloads/d...displaylang=en
It talks about DataRelations that allwos to bnavigate between parent and
child rows...

JOIN is rather a SQL notion. So you may want to be a bit more specific
about what you are trying to do( or you want to create a third table)...

--
Patrice

"AVL" <AV*@discussions.microsoft.coma écrit dans le message de groupe de
discussion : B1**********************************@microsoft.com...

>Hi,
Ive two data tables..I need to perform a join on these datatables..
and fetch the data..I need to do it programaticlaly..
How can I acheive it...any sample code wpuld be of great help..