multiple select
-
Using .net 2.0 Is it possible to have a stored procedure with several select statements so that a dataset can be populated with all of the select statements. So the dataset will end up with several tables (One table for one select statement). At present I use the dataadapter to fill the dataset. I do this for each stored procedure which holds a select statement each. But rather than repeating this method several times (One for each select), I would like to do all this in one stored procedure and populate a dataset with the results of these tables. Is this to do with MultipleResultSet (MRS)? Any suggestions please? Thanks
-
Using .net 2.0 Is it possible to have a stored procedure with several select statements so that a dataset can be populated with all of the select statements. So the dataset will end up with several tables (One table for one select statement). At present I use the dataadapter to fill the dataset. I do this for each stored procedure which holds a select statement each. But rather than repeating this method several times (One for each select), I would like to do all this in one stored procedure and populate a dataset with the results of these tables. Is this to do with MultipleResultSet (MRS)? Any suggestions please? Thanks
-
Using .net 2.0 Is it possible to have a stored procedure with several select statements so that a dataset can be populated with all of the select statements. So the dataset will end up with several tables (One table for one select statement). At present I use the dataadapter to fill the dataset. I do this for each stored procedure which holds a select statement each. But rather than repeating this method several times (One for each select), I would like to do all this in one stored procedure and populate a dataset with the results of these tables. Is this to do with MultipleResultSet (MRS)? Any suggestions please? Thanks
Shouldn't that work? Rather than a stored procedure simply have several selects in one statement? CommandText="select blah blah blah ; select something else" ; (With SQL server anyway, not all engines support it.)
