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]

Re: joining two tables

Try :

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&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" <AVL@discussion s.microsoft.com a écrit dans le message de groupe de
discussion : B1A71ABD-E0AA-463D-A4A1-667E1A43EC4B@mi crosoft.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]

Re: joining two tables

do you mean you wanna merge the tables??



dim ds, ds2 as new dataset

ds.readxml(xmlf ile)

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

gridview.dataso urce=ds.tables( 0).defaultview
gridview.databi nd



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:93E335F4-85E6-4474-B3E5-2326EDEEB729@mi crosoft.com...

Try :

http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&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" <AVL@discussion s.microsoft.com a écrit dans le message de groupe de
discussion : B1A71ABD-E0AA-463D-A4A1-667E1A43EC4B@mi crosoft.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..
>>

>