Question

C#Update的时候ExecuteNonQuery 出现语法错误

private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
string updata = string.Format("UPDATE Student SET LoginId = '{0}' LoginPwd = '{1}' studentName = '{2}', sex = '{3}', major = '{4}' Phone = '{5}' WHERE studentId = {6}",
txbLoginId.Text, txbPwd.Text, txbName.Text, txbSex.Text, txbMajor.Text, txbPhone.Text, txbId.Text);

SqlCommand command = new SqlCommand(updata,DBHelper.conn);
DBHelper.conn.Open();
int result = command.ExecuteNonQuery();
if (result > 0)
MessageBox.Show("{0} row has been updatad!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
MessageBox.Show("User info is not updated!", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
DBHelper.conn.Close();
}
}
int result = command.ExecuteNonQuery();就是这句报错说LoginPwd附近出现语法错误

Answer 1

你的LoginId = '{0}' LoginPwd = '{1}' studentName = '{2}', sex = '{3}', major = '{4}' Phone = '{5}'中间为什么有些加了逗号有些没有？

Answer 2

UPDATE Student SET LoginId = '{0}' ,LoginPwd = '{1}', studentName = '{2}', sex = '{3}', major = '{4}' ,Phone = '{5}' WHERE studentId = {6}