Input string was not in a correct format.该怎么处理

Input string was not in a correct format.

CREATE DEFINER=`crm`@`%` PROCEDURE `pre_delDataByTbName`(

in_table VARCHAR(128),

in_column VARCHAR(128),

in_new_value VARCHAR(10),

in_where VARCHAR(40)

)

BEGIN

  DECLARE l_sql VARCHAR(400);

  SET l_sql= CONCAT(‘ ‘,

  ‘DELETE FROM ‘,in_table,

  ‘ WHERE’,in_where);

  SET @sql=l_sql;

  PREPARE s1 FROM @sql;

  EXECUTE s1;

  DEALLOCATE PREPARE s1;

END;

C#的调用的参数：

  MySqlParameter[] mySqlParameter = new MySqlParameter[4];

  mySqlParameter[0] = new MySqlParameter(“in_table”, SqlDbType.VarChar);

  mySqlParameter[0].Value = “t1”;

  mySqlParameter[1] = new MySqlParameter(“in_column”, SqlDbType.VarChar);

  mySqlParameter[1].Value = “ss”;

  mySqlParameter[2] = new MySqlParameter(“in_new_value”, SqlDbType.VarChar);

  mySqlParameter[2].Value = “dd”;

  mySqlParameter[3] = new MySqlParameter(“in_where”, SqlDbType.VarChar);

  mySqlParameter[3].Value = ” tID=123″;

不知道为什么报：Input string was not in a correct format.

存储过程执行有问题吗？如没有问题c#调用存储过程中有问题。




在mysql客户端执行下call pre_delDataByTbName看看