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.
--
Terry
"Cor Ligthert [MVP]" wrote:
Terry,
The first already gives your answer
http://groups.google.com/group/micro...8d87927915d6fe
Cor
"Terry" <Te***@nospam.nospamschreef in bericht
news:33**********************************@microsof t.com...
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,
--
Terry