在调试的时候这个函数出现了错误,本来是SQL数据库的,没有错误,改成ACCEESS数据库后出现了“必须使用可更新的查询”的异常错误 OleDbConnection myconn = conn();
myconn.Open();
OleDbCommand Click = new OleDbCommand("UPDATE News SET Hits = (SELECT Hits+1 FROM News WHERE NewsID ="+id.ToString()+" ) WHERE NewsID = "+id.ToString(), myconn);
Click.ExecuteNonQuery();
OleDbCommand GetOne = new OleDbCommand("SELECT * FROM News WHERE NewsID ="+id.ToString(), myconn);
OleDbDataReader OneNews = GetOne.ExecuteReader(CommandBehavior.CloseConnection); return OneNews;错误提示是《Click.ExecuteNonQuery();》中,感觉应该是我写的更新语句不能适合ACCESS数据库,那么要怎样改呢?
myconn.Open();
OleDbCommand Click = new OleDbCommand("UPDATE News SET Hits = (SELECT Hits+1 FROM News WHERE NewsID ="+id.ToString()+" ) WHERE NewsID = "+id.ToString(), myconn);
Click.ExecuteNonQuery();
OleDbCommand GetOne = new OleDbCommand("SELECT * FROM News WHERE NewsID ="+id.ToString(), myconn);
OleDbDataReader OneNews = GetOne.ExecuteReader(CommandBehavior.CloseConnection); return OneNews;错误提示是《Click.ExecuteNonQuery();》中,感觉应该是我写的更新语句不能适合ACCESS数据库,那么要怎样改呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货