objConn.ConnectionString = myDbManager.GetConnectionString(); //获取连接语句
objConn.Open();
objCmd.Connection = objConn;
for (int i = 0; i < arrCompanyList.Count; i++)
{
arrCompany = (String[])arrCompanyList[i];
objCmd.CommandText = "UpDate tblDataTemp Set CompanyName = '" + arrCompany[0] + "' Where CompanyID = " + arrCompany[4];
objCmd.ExecuteNonQuery();
}
objConn.Close();
objConn.Dispose();上面的语句数据库只更新了一次,比如有10次的话,就只更新了一条,请问何解?
如果每次都要CLOSE和OPEN,那不是很费资源了?有什么解决办法?
objConn.Open();
objCmd.Connection = objConn;
for (int i = 0; i < arrCompanyList.Count; i++)
{
arrCompany = (String[])arrCompanyList[i];
objCmd.CommandText = "UpDate tblDataTemp Set CompanyName = '" + arrCompany[0] + "' Where CompanyID = " + arrCompany[4];
objCmd.ExecuteNonQuery();
}
objConn.Close();
objConn.Dispose();上面的语句数据库只更新了一次,比如有10次的话,就只更新了一条,请问何解?
如果每次都要CLOSE和OPEN,那不是很费资源了?有什么解决办法?
=>
objCmd.CommandText = "UpDate tblDataTemp Set CompanyName = '" + arrCompany[i] + "' Where CompanyID = " + arrCompany[i];
这一句有重赋值的哦
然后跟一下arrCompany[0] 和arrCompany[4]的值是不是都变了:)
如果都是,再讨论,呵呵。