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

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

<mirax***@yahoo.com> wrote in message
--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

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

date/time fields
VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView
BEGIN TRANSACTION problem
new to .net and I want to throw it back
GridView DeleteCommand Erroring on StoredProcedure?