Hi all,
I have 2 select statements in my Stored Proc.
I want to display the results of each query in my DataGridView.
However, only the data of the last select query is returned.
Why is this
Thanks.
Transact-SQL
Hi all,
I have 2 select statements in my Stored Proc.
I want to display the results of each query in my DataGridView.
However, only the data of the last select query is returned.
Why is this
Thanks.
At a time you can only bind one resultset. if you need both the resultset on your page, you need to have 2 datagrid view.
If you use dataset,
grid1.DataSource = dataset.Tables[0];
grid2.DataSource = dataset.Tables[1];
If you use datareader,
grid1.DataSource = datareader;
datareader.NextResultSet();
grid2.DataSource = datareader;
Ideally I want all data displayed in one DataGridView.
Each SELECT Query returns the exact same Columns but differing data.
As both queries return the same columns, could you use a union clause in your stored proc
eg
CREATE PROC proc
AS
SELECT col1, col2
FROM table1
UNION ALL
SELECT col1, col2
FROM table2
This would mean you'd have just one results set.
If its more complicated than that, you could put the results of each query into a temp table/variable and just select from that
HTH!
May be something like this...
Select 'Table 1' as Source, * From FirstTable
Union ALL
Select 'Table 2' as Source, * From SecondTable
Order By
Source, ....