Re: DataSet w/ many tables to one Datagrid
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 14:29:24 -0500
arun.hallan@xxxxxxxxx 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.
.
- References:
- DataSet w/ many tables to one Datagrid
- From: arun . hallan
- DataSet w/ many tables to one Datagrid
- Prev by Date: Logging into a separate application, then going to a specific page
- Next by Date: Using Request.Browser.Crawler - is it reliable?
- Previous by thread: DataSet w/ many tables to one Datagrid
- Next by thread: How do I Format Currency w/out decimals?
- Index(es):
Relevant Pages
|
