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

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 (AT) yahoo (DOT) com> wrote