DbHelperMySQL.ExecuteSql()传参问题
MySqlParameter[] parameters = {new MySqlParameter("@Content", MySqlDbType.VarChar,1000) };
parameters[0].Value = model.Content;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
public static int ExecuteSql(string SQLString, params MySqlParameter[] cmdParms)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return rows;
}
catch (MySql.Data.MySqlClient.MySqlException e)
{
throw e;
}
}
}
}
上面是出问题的代码数据库中Content设置的类型是LongText,当model.Content的size超过1000,执行到“”int rows = cmd.ExecuteNonQuery();“”时,catch了一个异常:Data too long for column 'Content' at row 1;试过把1000这个数字改成2000,仍然超过1000就抛异常;把上面的VarChar换成LongText问题也仍然存在;
求大神解答