sql = "insert into Sy_Data(Bdz_ID,Leixing_ID,Shebei_ID,RTime,DType,data) values("
+intBdz.ToString()+","+intLeixing.ToString()+","+intShebei.ToString()+",\'"
+strRtime.ToString()+"\',"+sDType+",@a)"; //",null)";
gDbConn.Open(); //使用ODBC的数据库连接,数据库是SQL Server
OdbcCommand cmd = new OdbcCommand(sql,gDbConn);
cmd.Parameters.Add("@a",OdbcType.Image).Value = dataArray; //byte[] dataArray = new DataArray[256];
try
{
cmd.ExecuteNonQuery();
}
catch (Exception er)
{
MessageBox.Show("执行恢复的SQL语句出错误,错误信息为:"+er.ToString());
}出现错误,提示“必须声明变量@a”。
+intBdz.ToString()+","+intLeixing.ToString()+","+intShebei.ToString()+",\'"
+strRtime.ToString()+"\',"+sDType+",@a)"; //",null)";
gDbConn.Open(); //使用ODBC的数据库连接,数据库是SQL Server
OdbcCommand cmd = new OdbcCommand(sql,gDbConn);
cmd.Parameters.Add("@a",OdbcType.Image).Value = dataArray; //byte[] dataArray = new DataArray[256];
try
{
cmd.ExecuteNonQuery();
}
catch (Exception er)
{
MessageBox.Show("执行恢复的SQL语句出错误,错误信息为:"+er.ToString());
}出现错误,提示“必须声明变量@a”。
CREATE TABLE MyTable (col1 int, col2 smallmoney, col3 decimal)
CREATE PROC MyProc (@p1 int, @p2 smallmoney, @p3 decimal) AS INSERT INTO MyTable VALUES (@p1, @p2, @p3)
public void CreateMyProc(OdbcConnection connection)
{
OdbcCommand command = myConnection.CreateCommand(); command.CommandText = "{ call MyProc(?,?,?) }";
command.Parameters.Add("", OdbcType.Int).Value = 1;
command.Parameters.Add("", OdbcType.Decimal).Value = 2;
command.Parameters.Add("", OdbcType.Decimal).Value = 3;
}
还是原来的亲切些。