Hi all.
I'm trying to insert some data into a stored procedure. It doesn't work.
Either I'm doing it wrong or the stored procedure doesn't work (I didn't
write it). My DAL is pretty generic but my code is kinda like this:
Command.CommandText = "BE_BOOKING_INSERT(@EventID, @BookingID, @UserID,
@DateFrom, @DateTo, @TimeFrom, @TimeTo, @Comments, @LocationName,
@LocationAddress, @LocationZipcode, @LocationCity, @ContactName,
@ContactPhone, @ContactEmail, @EventContactName, @EventContactPhone)";
Command.CommandType = CommandType.StoredProcedure;
return (this.Command.ExecuteNonQuery()) == -1 ? false : true;
I even tried the following syntax which of course throws an error:
INSERT INTO BE_BOOKING_INSERT(EventID, BookingID, UserID, DateFrom, DateTo,
TimeFrom, TimeTo, Comments, LocationName, LocationAddress, LocationZipcode,
LocationCity, ContactName, ContactPhone, ContactEmail, EventContactName,
EventContactPhone) VALUES (@EventID, @BookingID, @UserID, @DateFrom,
@DateTo, @TimeFrom, @TimeTo, @Comments, @LocationName, @LocationAddress,
@LocationZipcode, @LocationCity, @ContactName, @ContactPhone, @ContactEmail,
@EventContactName, @EventContactPhone)
The question is what is the right syntax and do I need to set anything else
on Command object?
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
