Question

我数据添加成功了,但cmd.ExecuteNonQuery() =-1,请问谁遇到过这种情况，怎么回事

protected bool ExecuteNonQuery(String sql, CommandType cmdtype, SqlTransaction trans, params SqlParameter[] parms)
{
bool result = false;
SqlCommand cmd = null;
if (trans != null)
cmd = PreparedCommand(sql, trans.Connection, cmdtype, trans, parms);
else
cmd = PreparedCommand(sql, con, cmdtype, null, parms);
try
{
string a = cmd.ExecuteNonQuery().ToString();
if (cmd.ExecuteNonQuery() > 0)
{
result = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return result;
}
意思就是增删改成功与否永远都返回false请问怎么办

Answer 1

注释掉string a = cmd.ExecuteNonQuery().ToString();
如果还不行，看看是不是数据库nocount开关是不是打开了
把nocount设置成off就OK