System.Data.OleDb.OleDbException: UPDATE 语句的语法错误

[ara2011]

public int SaveValues()
{
if (RecordID > 0)
{
string sqlconnectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
OleDbConnection ASmdbCon;

//连接数据库
sqlconnectstr += System.Windows.Forms.Application.StartupPath + "\\DB.mdb";
ASmdbCon = new OleDbConnection(sqlconnectstr);

try
{
ASmdbCon.Open();
//MessageBox.Show("OK");
}
catch (System.Exception ex)
{

System.Windows.Forms.MessageBox.Show("打开数据库失败！\n\n详细信息如下：\n" + ex.ToString());
return -1;
}

try
{

string sqlcmd = "UPDATE List SET ";

sqlcmd += "A1 = '" + A1.ToString() + "', ";
sqlcmd += "A2 = '" + A2.ToString() + "', ";
。。。
。。。
sqlcmd += "HR = '" + HR.ToString() + "', ";
sqlcmd += "D5 = '" + D5.ToString() + "', ";

sqlcmd += "S1 = '" + S1.ToString() + "', ";
sqlcmd += "X1 = '" + X1.ToString() + "', ";
sqlcmd += "ProjectName = '" + ProjectName.ToString() + "', ";
sqlcmd += " WHERE ID = " + RecordID.ToString();



OleDbCommand dbCommand = new OleDbCommand(sqlcmd, ASmdbCon);
if (dbCommand.ExecuteNonQuery() > 0)
{
dbCommand.Dispose();
return 1;
}
else
{
dbCommand.Dispose();
return -1;
}
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show("出错啦！SAVE ID" + ex.ToString());
}
return -1;

程序运行到“ if (dbCommand.ExecuteNonQuery() > 0)”就出错啦，说是“System.Data.OleDb.OleDbException: UPDATE 语句的语法错误”，显示出错是“ if (dbCommand.ExecuteNonQuery() > 0）”。
到底是什么原因呢，还请各位大侠，多多指教，编程菜鸟的无奈呀~~
急急急~·

[ara2011]

问题解决啦，谢谢各位指点，尤其是一楼和四楼，果然是“逗号害死人呀”

[bdmh]

where前面就不要再有逗号了

[nube163]

"where ID='"+RecordID.ToString()+"'";
单步调，确定运行前sql语句没有错误!

[ycproc]

断点在 OleDbCommand dbCommand = new OleDbCommand(sqlcmd, ASmdbCon);

看看 sqlcmd是什么东西

直接粘贴到数据库执行

就知道是不是SQL的错误了

[飘零一叶]

sqlcmd += "A1 = '" + A1.ToString() + "', ";   
  sqlcmd += "A2 = '" + A2.ToString() + "', ";
  。。。
  。。。
  sqlcmd += "HR = '" + HR.ToString() + "', ";
  sqlcmd += "D5 = '" + D5.ToString() + "', ";
    
  sqlcmd += "S1 = '" + S1.ToString() + "', ";
  sqlcmd += "X1 = '" + X1.ToString() + "', ";
  sqlcmd += "ProjectName = '" + ProjectName.ToString() + "'"; //去掉这里的逗号
  sqlcmd += " WHERE ID = " + RecordID.ToString();