parameter from store procedure

  • Thread starter Thread starter Hrvoje Voda
  • Start date Start date
Hrvoje said:
How to get a parameter from store procedure ?

Hrcko
Click to expand...

Do you mean an output parameter?

You need to add that to the Parameters collection before you
execute the command. Be sure to set the Direction to Output.
After the command has executed, you can read that parameter again to
retrieve the output value.

If it's the *return value* that you are interested in, it's almost the
same, just use ReturnValue as Direction. (I don't think the name matters
in this case)
 
Back
Top