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]]

ar*********@gmail.com wrote:

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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.