DataSet w/ many tables to one Datagrid

[arun.hallan]

I have a dataset that calls a stored procedure within our system.
The stored procedure saves each table into the dataset.

I want now to display each table one after the other, all in the same
datagrid.


I've tried: this.grdResults.DataSource = results.DefaultViewManager;

But that doesnt work.



Any ideas?

 

[Bob Barrows [MVP]]

I have a dataset that calls a stored procedure within our system.
The stored procedure saves each table into the dataset.

I want now to display each table one after the other, all in the same
datagrid.


I've tried: this.grdResults.DataSource = results.DefaultViewManager;

But that doesnt work.

If all the resultsets have the same number of columns, you can use a union
query to combine them into a single resultset.

If that is not feasible, then you are going to have to create a datatable or
collection class that combines all the resultsets and bind the grid to that
datatable.

Bob Barrows