Bind GridView to Multiple Tables

[VBAHole22]

I have an asp.net Atlas enabled 2.0 website that has a gridview control in it to bind results from a query I make.

The problem is that I'm tyring to bind it to a DataSet that has multiple DataTables with results in it. Only the first DataTable is bound so that:

 

myGridView.DataSource = myDataSet;
myGridView.DataBind();

 

is the functional equivalent of

 

myGridView.DataSource = myDataSet.Tables[0];
myGridView.DataBind();

 

Is there a way to bind all the tables? Or should I be looking at a better control for this.

I can dynamically add a new gridView for each Table but I want something a little more visually pleasing. Each of the Tables has different columns so there is only so much I can do I suppose.

[Nate Bross]

Because they the tables have different fields, you will most likely need to have a DGV for each table.