cmd.ExecuteReader();//查询似乎存在延时性,即已经修改的记录值,但查询的还是老记录。
如下代码中,CallNum已经update,但是查询的结果有延时?????
string strSql = "select * from " + TableName1 + " where CCharacter='" + iString[i] + "'";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = strSql;
OleDbDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
ID = Convert.ToInt32(reader["ID"]);
CallNum = Convert.ToInt32(reader["CallNum"]);
WordString = reader["WordString"].ToString();
}
//----修改访问次数
string strSql1 = "update " + TableName1 + " set CallNum='" + (CallNum+1) + "' where ID=" + ID;
int num= d.AccessOperation(strSql1);