Populate Dataset with Parameterized Stored Procedure

[Sheldon Penner]

I have been trying to build a web form using the SQL Data Adapter
Configuration Wizard to create a dataset based on a parameterized stored
procedure. I find that if I select "Use existing stored procedure" on the
"Choose a query type" screen, the following screen allows me to choose only
one parameter, and the parameter must be selected from the output fields of
the procedure. My proc has two parameters and neither one is returned in the
output. If I select "Use SQL Statements", the wizard will not accept
"execute uspApptmtsOnDate ?, ?" or "uspApptmtsOnDate @OwnerID, @Dt", nor any
other variation I have tried.

Can this be done?

[Cor Ligthert]

Sheldon,

Populating a dataset using a stored procedure has no difference with
populating a dataset using a textstring.

Therefore in these kin of questions I have forever the same advice. Try your
problem first without the stored procedure. Mostly is it than a piece of
case to set the SQL textstring in your procedure and to change the command
in Execute.

I hope this helps,

Cor