On 4.4.2006 15:28 Charles Urbina wrote:
Hello Everyone.
I would like someone in this list if you could provide some sample code
of how to execute a stored procedure that returns a result into a
datagrid. (WebForm)
I'm using VS 2005 and Firebird 1.5
If it returns result, just use ExecuteScalar method and you will get the
result.
But I think, your SP returns results (multiple rows), so just use the
FbCommand and simple command like 'select * from procedure' or set
CommandType to StoredProcedure and run only the procedure.
Than you can use one of these Execute methods:
ExecuteReader Executes commands that return rows.
ExecuteNonQuery Executes commands such as SQL INSERT, DELETE, UPDATE,
and SET statements.
ExecuteScalar Retrieves a single value (for example, an aggregate
value) from a database.
Or maybe didn't understand. ;)
--
Jiri Cincura
http://www.cincura.net/
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
