插入成功最新的值就是你插的值!失败了你在按时间取最新的Name SELECT addtime FROM warnTable WHERE addtime=(SELECT MAX(addtime) FROM warnTable )
插入成功最新的值就是你插的值!失败了你在按时间取最新的Name SELECT addtime FROM warnTable WHERE addtime=(SELECT MAX(addtime) FROM warnTable ) 谢谢大侠,现在看来myCommand.CommandText = "SELECT * FROM warnTable WHERE datatime=(SELECT MAX(datatime) FROM warnTable )";蛮简单的。问题一个个解决了~很感谢。可能我还没入门吧 继续加油! 谢谢大家
运行错误 不能找到刚插入的值
1.查看value字段是不是int类型,如果不是int类型强转肯定会报错
2.查看getValue["value"]的值是否为null,如果为null,.ToString()肯定也会报错MySqlDataReader getValue = myCommand.ExecuteReader();
if (getValue.Read())
{
dataValue = Convert.ToInt32(getValue["value"].ToString().Trim());
}
getValue.Close();
SELECT addtime FROM warnTable WHERE addtime=(SELECT MAX(addtime) FROM warnTable )
SELECT addtime FROM warnTable WHERE addtime=(SELECT MAX(addtime) FROM warnTable )
谢谢大侠,现在看来myCommand.CommandText = "SELECT * FROM warnTable WHERE datatime=(SELECT MAX(datatime) FROM warnTable )";蛮简单的。问题一个个解决了~很感谢。可能我还没入门吧 继续加油!
谢谢大家