Professional Web Applications Themes

How can I execute a stored procedure in .net? - ASP.NET General

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

  1. #1

    Default How can I execute a stored procedure in .net?

    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 Guest

  2. #2

    Default Re: How can I execute a stored procedure in .net?

    A starting point:

    [url]http://www.dotnetcoders.com/web/Articles/ShowArticle.aspx?article=14[/url]

    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
    [url]http://www.dotnetcoders.com[/url]



    "FireListen" <FireListenhotmail.com> wrote in message
    news:uvIJuCLPDHA.2224TK2MSFTNGP10.phx.gbl...
    > 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 Guest

Similar Threads

  1. execute stored procedure
    By Buda123 in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 29th, 09:26 PM
  2. Execute permission denied on 'stored procedure' dbo
    By Prasath in forum ASP.NET Web Services
    Replies: 0
    Last Post: October 13th, 08:57 AM
  3. Problem with execute to make a stored procedure
    By Cecil Westerhof in forum ASP Database
    Replies: 6
    Last Post: March 1st, 05:29 PM
  4. Replies: 2
    Last Post: October 21st, 08:01 AM
  5. Cannot execute dynamic query in stored procedure
    By Net in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 09:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139