Multiple select statements in a single stored procedure.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have coded multiple select statements in a single stored procedure, and
when I execute this procedure on SQL Server Management Express, I correctly
get multiple result sets. But, if I try to add a new Data Source to to my VB
2005 project, and point to this stored procedure, the data source wizard only
sees the 'first' select statement. Is there a way to load multiple tables in
a DataSet from a single stored procedure with multiple select statements?
TIA,
 
Hi Cor,
Thank you for yopur responce, but, the link you sent me to is in fact
wrong! At least as far as VS2005 is concerned. Under VS2003, when you drag
a stored procedure on the the form and generate a dataset, you get a table
for each select statement. Under VS2005 you only get a table for the first
select statement. Is this change in behavior intentional? If so, I wonder
why. It sounds like a bug to me.
 
Back
Top