Multiple select statements in a single stored procedure.

[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,

 

[Cor Ligthert [MVP]]

Terry,

The first already gives your answer

http://groups.google.com/group/micr...st&q=multiple+select+&rnum=1#eb8d87927915d6fe

Cor

 

[Guest]

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.