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 ...
-
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...
-
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...
>
>
>
-
Re: parameter output
Similar Threads
-
By Application Development in forum ADO DAO RDO RDS
Replies: 1
Last Post: 10-29-2007, 12:38 PM
-
By Application Development in forum ADO DAO RDO RDS
Replies: 0
Last Post: 06-19-2007, 07:42 AM
-
By Application Development in forum DOTNET
Replies: 2
Last Post: 07-12-2006, 02:34 PM
-
By Application Development in forum ADO DAO RDO RDS
Replies: 0
Last Post: 06-03-2006, 04:48 PM
-
By Application Development in forum basic.visual
Replies: 1
Last Post: 06-01-2005, 11:24 AM