java的update语句出现错误,update语句中的语法错误 (Syntax error in update statement)

2009-05-19 08:26:25

0

code:

string query1 = @"UPDATE global_mapping set escape_id = " +

dataGridView1.Rows[i].Cells[2].Value + ",function_id = " +

dataGridView1.Rows[i].Cells[3].Value + ",function_name = '" +

dataGridView1.Rows[i].Cells[4].Value + "',parameter_name = '" +

dataGridView1.Rows[i].Cells[5].Value + "',parameter_validity = '" +

dataGridView1.Rows[i].Cells[6].Value + "',statusparameter_id = " +

dataGridView1.Rows[i].Cells[7].Value + ",acb_datatype = '" +

dataGridView1.Rows[i].Cells[8].Value + "',data_type_id = " +

dataGridView1.Rows[i].Cells[9].Value + ",bit_size = " +

dataGridView1.Rows[i].Cells[10].Value + ",validity_status ='" +

dataGridView1.Rows[i].Cells[11].Value + "',validity_func = '" +

dataGridView1.Rows[i].Cells[12].Value + "'WHERE global_mapping.parameter_id =" +

dataGridView1.Rows[i].Cells[1].Value + "";

OleDbCommand cmd1 = new OleDbCommand(query1, conn);

cmd1.ExecuteNonQuery();

code ends:

When I execute the above code I get an error stating "Syntax error in Update statement".

Can someone please tell me how to resolve this?