[Firebird-net-provider] Stored Procedure select ...

[Eduardo Beninca]

I have a stored procedure that returns to me an entire table..

I tried 2 ways to execute this procedure im my c# code...

fbDA fbDataAdapter = new FbDataAdapter();
fbDA.SelectCommand = new FbCommand("EXECUTE PROCEDURE CONSULTA_SEMEN", fbConnection);


FbTransaction ft = fbConnection.BeginTransaction();
FbCommand fc = new FbCommand("EXECUTE PROCEDURE CONSULTA_SEMEN", fbConnection, ft);
fc.CommandType = CommandType.StoredProcedure;
fc.ExecuteReader();


this 2 ways returned to me nothing and when i execute this procedure in firebird its works fine...

Anyone can help ??


----------------------------------------------------------
"I throw myself into the sea
Release the wave, let it wash over me
To face the fear I once believed
The tears of the dragon, for you and for me"

Bruce Dickinson - Tears of the Dragon

§€NT€NC€Ð - MSN - [EMAIL PROTECTED]
[EMAIL PROTECTED]
----------------------------------------------------------