If you bind a DataSet then you need to set the DataMember to specify the DataTable to display.

The DataGridView does not support relationship navigation at all. The DataGrid does but will still only display data from one table at a time. You'd need to create your own customised grid, which would be a lot of work, or use a third party control if you want more.