«

Hello all,
Is there anyone who can tell me how to execute a stored procedure in .net.
More detailed, I want to pass some parameters to the procedure and the
procedure must return some value in the parameters and return a value
indicating whether the procedure is successful. The problem is how I can get
the new value in the parameters of the procedure and how I can get the value
returned by the procedure.

A starting point:

http://www.dotnetcoders.com/web/Arti...spx?article=14

After the execution of the stored procedure, you can get the values of out
params the same way you set the values, ie.
..Parameters["@VariableName"].Value

--
James J. Foster, DotNetCoders
http://www.dotnetcoders.com



"FireListen" <> wrote in message
news:...
> Hello all,
> Is there anyone who can tell me how to execute a stored procedure in .net.
> More detailed, I want to pass some parameters to the procedure and the
> procedure must return some value in the parameters and return a value
> indicating whether the procedure is successful. The problem is how I can
get
> the new value in the parameters of the procedure and how I can get the
value
> returned by the procedure.
>
>