Adding data to existing Datagrid

[TheWizardofInt]

I have a datagrid on my page

 

What I need to do is to fill it from different sources that have different fields, which means I have to change the column datasources

 

Am I totally out to lunch here, or is this something that can be done? All of the examples say that you create the datagrid and then fill it from the dataset, and then it auto-populates with the fields from the query that creates the dataset. I haven't been able to make that work.

 

Any help is greatly appreciated.

[Robby]

You can have multiple tables in one Dataset.

 

Then you can use the NavigateTo method to change from one table to another.