parameter output - DOTNET

This is a discussion on parameter output - DOTNET ; I have an stored procedure which has an OUTPUT parameter, how can i get it, it has to be through a DataReader or something like that???? or when i call it??? can you give me an example??? Any help will ...

+ Reply to Thread
Results 1 to 3 of 3

parameter output

  1. Default parameter output

    I have an stored procedure which has an OUTPUT parameter,
    how can i get it, it has to be through a DataReader or
    something like that???? or when i call it???

    can you give me an example???


    Any help will be welcome, thanX!!!!

    Regards...




  2. Default Re: parameter output

    Hi Miguel,

    You just read the value from the Parameters collection after calling
    IDbCommand.ExecuteNonQuery. If your stored procedure returns a resultset
    (through a DataReader) and output parameters and you use
    IDbCommand.ExecuteReader, the reader must be closed before you can fetch the
    output parameter value, in some providers (like the SQL Server data
    provider).

    Bob Beauchemin
    http://staff.develop.com/bobb


    "Miguel Pardo" <mpardot@yahoo.com> wrote in message
    news:038e01c3b608$301bfcc0$a301280a@phx.gbl...
    > I have an stored procedure which has an OUTPUT parameter,
    > how can i get it, it has to be through a DataReader or
    > something like that???? or when i call it???
    >
    > can you give me an example???
    >
    >
    > Any help will be welcome, thanX!!!!
    >
    > Regards...
    >
    >
    >




  3. Default Re: parameter output


    ThanX!!!!

+ Reply to Thread

Similar Threads

  1. Output parameter
    By Application Development in forum ADO DAO RDO RDS
    Replies: 1
    Last Post: 10-29-2007, 12:38 PM
  2. getting output parameter on access
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 06-19-2007, 07:42 AM
  3. Output Parameter - Return Value
    By Application Development in forum DOTNET
    Replies: 2
    Last Post: 07-12-2006, 02:34 PM
  4. cannot get TADOQuery output parameter
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 06-03-2006, 04:48 PM
  5. input/output parameter: howto get the output from VB6
    By Application Development in forum basic.visual
    Replies: 1
    Last Post: 06-01-2005, 11:24 AM