Stored procedure w/multiple SPs - can I use DataSet Designer?

[Eddie]

I've got a SP that actually executes 7 other SP's. I'd like to use the
DataSet Designer to create the DAL for this app, but I'm not sure it can be
done with this type of SP? Right now all I get is the initial resultset
which is just authentication info. I had hoped to get a seperate DataTable
for each resultset (8 total). Does anyone know if this can be done and, if
so, what's the trick to getting it to work? If it can't be done, does anyone
have a suggestion on how to best implement the DAL using this type of SP?
It's only a select, this app won't be doing any inserts, updates or deletes,
just viewing data.

Thanks for your help!


eddie

 

[Sericinus hunter]

I've got a SP that actually executes 7 other SP's. I'd like to use the
DataSet Designer to create the DAL for this app, but I'm not sure it can be
done with this type of SP? Right now all I get is the initial resultset
which is just authentication info. I had hoped to get a seperate DataTable
for each resultset (8 total). Does anyone know if this can be done and, if
so, what's the trick to getting it to work?

It can be done. I remember having problems like this when
one (or more) of SPs used temp tables inside its code. Looks like
the designer cannot retrieve the result set schema in this scenario.
I changed SP code temporarily removing all references to temp tables,
re-created everything and then was able to drag and drop the SP
from Server Explorer to the dataset design surface.

 

[Eddie]

Hmmm.. I'll have to try that - sounds like that might be the trick. I know
we do use temp tables in the sp as well...

Thanks!

eddie