Join 2 datatables into one resultset

Question

Hi,

I have a dataset that contains 2 datatables they link together using a DataRelation.

it it possible to selet from those tables into into one result set?

thanks, Ofer

Answer 1

See example in forum post here

Answer 2

You can create JOIN tables with the VS DataSet editor, whcih combine your results - you can then write Select queries against that and call them from within your app.

To do it, simply create a new TableAdapter, then add BOTH tables into the editor (use the visual one), and select the fields you want to use from both tables, then write the relevant select functions.

Answer 3

Microsoft's suggestion is to create a helper class. See:

http://support.microsoft.com/kb/326080/en-us

This is a general purpose tool that can be used no matter what the source.

Answer 4

Thanks a lot! the helper class fixed this issue