cannot using Update

[Nguyen_4]

This is my code:
String cmdText = ("UPDATE sinhvien SET Ho= '" + HoSV + "',Ten = '" + TenSV + "', Ngaysinh= '" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "',Ghichu='" + GhiChu + "',Diemthi = '" + DiemThi + "' WHERE idSinhVien =" dataGridView1.SelectedRows[0].Cells[0].Value.ToString()IDSinhVien);
MySqlCommand cmd = new MySqlCommand(cmdText, constr);
cmd.ExecuteNonQuery();

I cannot update, if i change idsinhvien = int => success. but mysql idsinhvien= varchar => error

[DaveAmour]

Can you debug this and show what the SQL statement parses out to please?

[Nguyen_4]

unknown column 'user_id' in 'where clause'

[DaveAmour]

Where did user_id come from? I don't see that in your code which builds up the sql statement.

[JerrimePatient]

change the dateTimePicker1.Value.ToString("yyyy/MM/dd") to dateTimePicker1.Value.ToString("yyyy-MM-dd") and "' WHERE idSinhVien =" dataGridView1.SelectedRows[0].Cells[0].Value.ToString()IDSinhVien)"
to "' WHERE idSinhVien=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() +"')"

Note: dataGridView1.SelectionMode must be FullRowSelect.