¹ØÓÚAccess ÎÊÌâ¡£UPDATE Óï¾äµÄÓï·¨´íÎó¡£

public int UpdateUserPassword(string sname,string spassword)
        {
            strOleDb = new StringBuilder();
            strOleDb.Append("update FinanceUser set ");
            strOleDb.Append("name='" + sname + "',password='" + spassword + "'");
            strOleDb.Append(" where ID=1");

            int i = DB.DB_ExecuteNonQuery(strOleDb.ToString());
            return i;
        }


UPDATE Óï¾äµÄÓï·¨´íÎó¡£ÄÄÀïÓÐÎÊÌâ

---

SQL code:
update
FinanceUser set name=....
from
tb
where
id=1

---

ÒýÓÃ

SQL codeupdate
  FinanceUser set  name=....from
  tb where
  id=1

FinanceUser Õâ¸ö¾ÍÊDZíÃû°¡

---

SQL code:
---TRY
update
FinanceUser set name=....
from
FinanceUse
where
id=1

---

SQL code

---

Code highlighting produced b