{
string strConnection = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = " + Server.MapPath("./");
strConnection += @"Database.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
string sqlQuery = "Select * From [Contacts] Where [PIN] = '" + Request["PIN"] + "'";
DataSet objDataSet = new DataSet();
OleDbDataAdapter objDataAdapter = new OleDbDataAdapter(sqlQuery, objConnection);
OleDbCommandBuilder objCommandBuilder = new OleDbCommandBuilder(objDataAdapter);
objDataAdapter.Fill(objDataSet, "Contacts");
objDataSet.Tables["Contacts"].Rows[0]["Name(ENG)"] = Request["Name(ENG)"];
objDataSet.Tables["Contacts"].Rows[0]["Cell Phone"] = Request["Cell_Phone"];
objDataSet.Tables["Contacts"].Rows[0]["Backup Phone"] = Request["Backup_Phone"];
objDataSet.Tables["Contacts"].Rows[0]["Location"] = Request["Location"];
objDataSet.Tables["Contacts"].Rows[0]["Notes"] = Request["Notes"];
objDataAdapter.Update(objDataSet, "Contacts");
objConnection.Close();
}
“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------
UPDATE 语句的语法错误。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.OleDb.OleDbException: UPDATE 语句的语法错误。
源错误:
行 115: objDataSet.Tables["Contacts"].Rows[0]["Location"] = Request["Location"];
行 116: objDataSet.Tables["Contacts"].Rows[0]["Notes"] = Request["Notes"];
行 117: objDataAdapter.Update(objDataSet, "Contacts");
行 118: objConnection.Close();
前来请教大家！谢谢！
