How can I execute a stored procedure in .net?

[FireListen]

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.

 

[James J. Foster]

A starting point:

http://www.dotnetcoders.com/web/Articles/ShowArticle.aspx?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