Question

这段代码总是提示说WHERE 附近有语法错误，请高手帮忙，谢谢！

public static void Update(Employee ae)
{
SqlDataReader odr = null;
Employee cur = getcur();
string id = cur.Xuehao;
string sql = "UPDATE Employees SET ";
sql += " Xingming= " + "'" + ae.Xingming + "'" + ",";
sql += " Xuehao= " + "'" + ae.Xuehao + "'" + ",";
sql += " Banjig= " + "'" + ae.Banji + "'" + ",";
sql += " WHERE Xuehao= " + id;
try
{
getconnection();
SqlCommand ocmd = new SqlCommand(sql, con);
ocmd.Connection.Open();
odr = ocmd.ExecuteReader();

}
catch (Exception oe)
{
MessageBox.Show(oe.Message);

}

}

Answer 1

sql += " Banjig= " + "'" + ae.Banji + "'" + ",";

这个逗号多余了