Hello everyone,
i have an store proceduer which return two result sets
example
create proc GetCompleteContractDetails
As
Begin
select * from contractState
select * from contractDetails
End
now when i want to call the store procduer in asp.net and i am storing the results in dataset and binding the gridview to the data set
the columns which are belongs to the second select query will be not available for gridview
now the question is how to combine the two result sets into single one and bind it to gridview
i tried this
da.fill(ds);
datatable table1 = ds.tables[0];
datatable table2 = ds.tables[1]
table1.merge(table2);
gridview1.datasource = table1;
gridview1.databing();
but it did'nt work for me
Note: the 1st select query has 3 columns and the 2nd one has one columns
Thanks in advance