DataSet and Join

[Bob Rundle]

I've been using the dataset for months now and I have just now discovered
that it is not capable of a JOIN!

For example

Table1:
TimeID
Date

Table2:
TimeID
Pressure
Flow

Apparently there is no simple way to create a view of these two tables:

View1:
Date
Pressure
Flow

What am I missing here? Surely this is a common need.

Regards,
Bob Rundle

 

[Miha Markic [MVP C#]]

Hi Bob,

You might either use computed columns (Expression property) or a workaround,
like:
Joinview
http://support.microsoft.com/default.aspx?scid=kb;en-us;325682&Product=adonet
It is in vb.net but it shouldn't be too difficult to port it to c# if you
need to.