Can I join Datatables inside dataset to become a new datatable?

[hangdee]

I have 2 datatables (get from database) inside a dataset.
How can I create another datatable which is a result of
Select tb1.xxx, tb2.yyy from table1 as tb1 left join table2 as tb2 on tb1.id
= tb2.t1id

Is there any sample code for it?

[Cor Ligthert [MVP]]

Hangdee,

There will be Linq, as long as that not exist you have to do it with looping
by instance using this.

http://www.vb-tips.com/dbpages.aspx?...3-8a9529b2b38b

I hope this helps,

Cor

"hangdee" <ha*****@discussions.microsoft.comschreef in bericht
news:D5**********************************@microsof t.com...

>I have 2 datatables (get from database) inside a dataset.
How can I create another datatable which is a result of
Select tb1.xxx, tb2.yyy from table1 as tb1 left join table2 as tb2 on
tb1.id
= tb2.t1id

Is there any sample code for it?