我试图调用一个存储过程,但我对ASP.NET语法不太了解。
该项目使用:
OdbcConnection connection = new OdbcConnection(ConnectionString());
OdbcCommand ODBCCommand = new OdbcCommand("sp_insert_booking", connection);
ODBCCommand.CommandType = CommandType.StoredProcedure;
ODBCCommand.Parameters.AddWithValue("@project", "");
connection.Open();
ODBCCommand.ExecuteNonQuery();异常
Exception has occurred: CLR/System.Data.Odbc.OdbcException
An exception of type 'System.Data.Odbc.OdbcException' occurred in System.Data.Odbc.dll but was not handled in user code: 'ERROR [HY000] [ODBC InterBase Driver][InterBase]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 0
sp_insert_booking'我的问题是如何在项目结构中定义/创建spInsertBooking。
发布于 2021-11-30 20:49:26
试着使用这样的方法:
OdbcCommand ODBCCommand = new OdbcCommand("EXECUTE PROCEDURE spInsertBooking", connection);如果spInsertBooking命令需要参数,请执行以下操作:
OdbcCommand ODBCCommand = new OdbcCommand("EXECUTE PROCEDURE spInsertBooking 1001, 1002, 1003", connection);(以逗号分隔的项;使用单引号分隔字符串。)
更多信息可以在InterBase文档中找到。
https://stackoverflow.com/questions/69794608
复制相似问题