Stored Procedure Parameters

  • Thread starter Thread starter Chris Kennedy
  • Start date Start date
C

Chris Kennedy

In my ASP.net book it says you can put the sql of a stored procdure in which
you use parameters in the commandtext property in the designer and it will
automatically generate the code for adding the parameter objects to the
command objects. All's I get is an unable to parse update statement error.
What am I doing wrong, as it would save so much code if you didn't have to
manually add the paramters. Regards, Chris.
 
It was copy and pasted from the query analyser. By the way I am using VB.net standard but I can't see that being a problem.
Chris,

Can you test your query in Query Analyser? Sounds like maybe there is something wrong there?

-Calvin Luttrell
www.projectthunder.com
Enter to win a XBOX or a Portable DVD Player
Monitored forums www.projectthunder.com/forums
 
Back
Top