Well DataSet is more like 3 dimensional object compared to datagrid  which is 2d like. In order to get the data  from all 3 tables  into te same datagrid I'd use DataView on those and try assemble all data to be presenred in a single datagrid. Could do that in the first place and have one table  with all data and use DataViews to look at it with different criteria. Just use union all on all 3 tables with dataview and you will have all info for your datagrid to display. Not sure you can BIND them directly thou. Just don't see how.

There is no binding between different tables  via DataSet object for viewing purposes. You can only filter and sort them via DataViews and regarding to parent table's data.
I would also like to have DataSet capability like SQL Query to join tables and get out exactly what I want, which would BTW be also VERY VERY fast, while all data  resides in-memory. Like DataSet Query. No Procedures or any of the other other SQL capabilities, but only pure SELECTING, DELETING, INSERTING, UPDATING and DROPING.