How can I execute a stored procedure in .net?

Discussion in 'ASP .Net' started by FireListen, Jun 27, 2003.

  1. FireListen

    FireListen Guest

    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.
     
    FireListen, Jun 27, 2003
    #1
    1. Advertising

  2. 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

    --
    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.
    >
    >
     
    James J. Foster, Jun 27, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeff Thur
    Replies:
    2
    Views:
    1,044
    Guest
    Feb 7, 2005
  2. =?Utf-8?B?SklNLkgu?=

    Stored Procedure vs direct execute SQL

    =?Utf-8?B?SklNLkgu?=, May 27, 2005, in forum: ASP .Net
    Replies:
    7
    Views:
    5,057
    Robbe Morris [C# MVP]
    May 27, 2005
  3. nicholas
    Replies:
    7
    Views:
    601
    John.Net
    Aug 3, 2005
  4. Replies:
    1
    Views:
    451
    Bjorn Abelli
    Oct 17, 2005
  5. Mike P
    Replies:
    0
    Views:
    3,309
    Mike P
    Jun 19, 2006
Loading...

Share This Page