Jiri,
This is great information which I will also need. But what I want is a Sample code of how do you configure the Provider to send the stores procedure params and get the result displayed on a dataview.
Tia
Charles
From: Jiri Cincura <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: [Firebird-net-provider] Executing Stored Procedure
Date: Tue, 04 Apr 2006 16:18:06 +0200
>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
