Hi
Please find the SP
CREATE PROCEDURE INSERT_RESULTS(
OID INTEGER,
NR INTEGER,
STAT INTEGER )
AS
BEGIN
INSERT INTO RESULTSTABLE(OBJECTOID,NRDEST,STATUS)
VALUES(:OID,:NR,:STAT);
END
Thank You
N.Venkatesh
PMS,CT
Philips Electronics India Ltd.
Philips Innovation Campus,
MFAR Manyata Tech Park
Manyata Nagar, Nagavara,
Bangalore-560045.
Tel :91-80-41891011
intranet: ingbtcpic1ms404.blr.pin.philips.com
internet: www.bangalore.philips.com
--------------------------------------------------------------------------------------------------------------------------------------------------
"When you blame others, you give up your power to change."
"If you don't like something, change it. If you can't change it, change your attitude."
"Be prepared to ride the cycles and trends of life; success is never permanent and failure is never final."
"Yield not to unmanliness, Partha. It does not befit you to be a weak, chicken-hearted human being.Give up this mean cowardice and mental depression. Arise O hero! Stand up, do you duties manfully and cheerfully". - Bhagvad Gita
DataTable table = new DataTable("RESULTSTABLE");
table.Columns.Add("OBJECTOID", typeof(int));
table.Columns.Add("NRDEST", typeof(int));
table.Columns.Add("STATUS", typeof(int));
int start = System.Environment.TickCount;
for (int i = 0; i < 1; i++)
{
DataRow row = table.NewRow();
row["OBJECTOID"] = (int)(i + start);
row["NRDEST"] = (int)(i + start);
row["STATUS"] = (int)(i + start);
table.Rows.Add(row);
}
FbTransaction transaction = connection.BeginTransaction();
FbCommand command = new FbCommand("INSERT_RESULTS", connection, transaction);
command.CommandType = CommandType.StoredProcedure;
// command.Parameters.Add("@OBJECTOID", FbDbType.Integer, 4, "OBJECTOID").Direction = ParameterDirection.Input;
// command.Parameters.Add("@NRDEST", FbDbType.Integer, 4, "NRDEST").Direction = ParameterDirection.Input;
// command.Parameters.Add("@STATUS", FbDbType.Integer, 4, "STATUS").Direction = ParameterDirection.Input;
FbDataAdapter adapter = new FbDataAdapter(command);
adapter.InsertCommand = command;
adapter.Update(table);
transaction.Commit();
|
Carlos Guzmán Álvarez <[EMAIL PROTECTED]> Sent by:
11/10/2006 03:32 PM
|
|
Hello:
> Please suggest..
Please send the sp definition, are you adding parameters to the command
inthe same order as they appears in the sp code ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
