存储过程如下:
CREATEPROCEDURETestSP
@IDint
AS
RETURN@@ERROR
GO
网上的例子都是用Sql的对象来传参数的,于是使用相同的格式写了代码,结果不能传参数,代码如下:
try
{
OdbcConnectionm_cConn=newOdbcConnection();
OdbcCommandm_cCommand=newOdbcCommand();
OdbcParametercParam=newOdbcParameter("@ID",OdbcType.Int,4);
m_cConn.ConnectionString="Dsn=MySQLServer;trusted_connection=Yes;wsid=BINARYTREE;database=SimpleProjectDB";
m_cConn.Open();
m_cCommand.Connection=m_cConn;
m_cCommand.CommandText="TestSP";
m_cCommand.CommandType=CommandType.StoredProcedure;
m_cCommand.Parameters.Add(cParam);
m_cCommand.ExecuteNonQuery();
}
catch(ExceptioncEx)
{
return;
}
上面的代码运行到m_cCommand.ExecuteNonQuery(); 时出异常,说是参数没有找到,问题出在CommandText属性的设置上。正确的格式应该如下:
m_cCommand.CommandText="{CALL TestSP(?)}";