HighTechTalks DotNet Forums  

Populate Dataset with Parameterized Stored Procedure

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss Populate Dataset with Parameterized Stored Procedure in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Sheldon Penner
 
Posts: n/a

Default Populate Dataset with Parameterized Stored Procedure - 06-29-2005 , 12:59 PM






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?


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.