JOIN on 2 datasets?

[mirax_00]

Can I code a JOIN on 2 datasets the same as 2 tables in a database or
do I have to retrieve the table by index or something of the table and
JOIN those? There's only 1 table in each ds...

 

[Cor Ligthert [MVP]]

Mirax,

You cannot join 2 datasets, however you can fake it.

http://www.vb-tips.com/default.aspx?ID=5fd5a8cf-54dc-4946-a193-8a9529b2b38b

I hope this helps,

Cor

 

[W.G. Ryan - MVP]

Can I code a JOIN on 2 datasets the same as 2 tables in a database or
do I have to retrieve the table by index or something of the table and
JOIN those? There's only 1 table in each ds...

--There's really nothing to "Join" in respect to a dataset so if I
understand you correctly, the short answer is 'no'. You always relate
tables, datasets are just containers for tables so there's nothing to relate
them on per se. The way you'd get at that functionality though is to either
have all the tables contained in the same collection(DataSet) . If you
don't mind me asking, what specifically are you trying to accomplish, maybe
I can help you get there with a different approach.

HTH,

Bill

 

[Jayyde]

For clarification each dataset only had 1 table returned in it and I
needed to join them. Thanx btw Cor, that's similar to what I ended up
doing to get it to work. Ended up copying the single tables returned
in those datasets and adding them to a master dataset and relating them
in it...as long as it works that was no biggie to me

Jayyde