¶ÔÊý¾Ý¿âÖеÄÊý¾ÝÐÞ¸Ä ±¨´í ÊÇaccessÊý¾Ý¿â£¡

C# code:
C# code string str1 = "provider=Microsoft.Jet.OLEDB.4.0;Data source=student1.mdb;User Id=admin;Jet OLEDB:Database Password=admin";
OleDbConnection conn = new OleDbConnection(str1);
string str4 = "update logn set password=¡¯" + textBox1.Text.Trim() + "¡® where id=1";
OleDbCommand cmd = new OleDbCommand(str4, conn);
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("ÃÜÂëÐ޸ijɹ¦£¡");




Õâ¶Î´úÂë  ´íÄÄÀïÁË  ΪʲôÀÏÊÇ˵updateÓï·¨´íÎó£¡

ÊÇaccessÊý¾Ý¿â£¡

---

SQL code:

string str4 = "update logn set password=''" + textBox1.Text.Trim() + "'' where id=1";


ÕâÑù¿´¿´£¿£¿£¿ÊDz»ÊÇÄãÕâ¸ö·ûºÅ¡¶¡¯¡·²»¶Ô°¡

---

ÒýÓÃ

SQL code
string str4= "update lognset password=''"+ textBox1.Text.Trim()+ "''where id=1";
ÕâÑù¿´¿´£¿£¿£¿ÊDz»ÊÇÄãÕâ¸ö·ûºÅ¡¶¡¯¡·²»¶Ô°¡

²»ÊÇ°¡  ÎÒÄǸöÓöÔÁË 

»¹ÓР ¾ÍÊÇ  ÎÒÖ±½Ó  '123¡®  »¹ÊDz»¿ÉÒÔ 
¡­¡­

---

ÄÄÀﱨµÄ´í??±¨µÄʲô´í?

---

ÄÇÄã°ÑS