Question

为什么总提示 System.Data.OleDb.OleDbException: UPDATE 语句的语法错误。

OleDbConnection cn = new OleDbConnection(string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", Server.MapPath(".") + "\\app_data\\" + "partyhistory.mdb;"));
cn.Open();
string sql = "update manager set password='" + TextBox9.Text + "'where name='" + TextBox8.Text + "'";
OleDbCommand cmd = new OleDbCommand(sql, cn);
cmd.ExecuteNonQuery();
cn.Close();
GridView1.DataBind();

Answer 1

你注意一下你写的格式　string sql = "update manager set password='" + TextBox9.Text + "'　where name='" + TextBox8.Text + "'";　空格这些你检查一下