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?

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

Adding Columns to Jet/Access database
System.Type - structure
Accessing dll
Line across form
Text Box only allow numbers.
Deployment packages
Resize only the height of Form
How to: Printer Driver
avicap32.dll issues (Is Ken Tucker Around?)
Event Log Object