Hello again,
Now that I've got a stored procedure to fill a DataSet I've moved onto
deriving the parameters for a stored procedure.
I've got a stored procedure that has two input and two output parameters.
The only way I've managed to derive the parameters is using the following
code...
FbTransaction transaction = connection.BeginTransaction();
FbCommand cmd = new FbCommand("execute procedure test_derive(?,?)",
connection, transaction);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
FbCommandBuilder.DeriveParameters(cmd);
Ideally I would like to be able to derive the parameters without having to
know anything about the parameters in advance, this is possible with the SQL
Server and Oracle data providers but I can't find a way to do it using
Firebird.
Many thanks
Rod.
---------------------------------------------------------------------------------------------------------------
Clearswift monitors, controls and protects all its messaging traffic in
compliance with its corporate email policy using Clearswift products.
Find out more about Clearswift, its solutions and services at
www.clearswift.com.
***********************************************************************************
This communication is confidential and may contain privileged
information intended solely for the named addressee(s). It may not
be used or disclosed except for the purpose for which it has been
sent. If you are not the intended recipient, you must not copy,
distribute or take any action in reliance on it. Unless expressly stated,
opinions in this message are those of the individual sender and not of
Clearswift. If you have received this communication in error, please
notify Clearswift by emailing su...@cl... quoting the
sender and delete the message and any attached documents. Clearswift accepts no liability or responsibility for any onward transmission or use of emails and attachments having left the Clearswift domain.
This footnote confirms that this email message has been swept by
MIMEsweeper for Content Security threats, including computer viruses.
|
