Nguyen_4

dateTimePicker1.DataBindings.Add("text", dataGridView1.DataSource, "Ngaysinh"); I try get dd/mm/yyyy from datagridview but datagirdview show mysql: ex: 12/02/1990 12:00:00. how to show datetimepicker when i click datagridview row

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 …

I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column …

i connect mysql using c# and show database in datagridview I want when i click the row in datagridview, textbox, combobox , datetimepicker will show form datagirdview But mysql datetime : yyyy/mm/dd 00:00:00 ( 00:00:00 will default if don't write) Datagridview : mm/dd/yyyy i used code: datetimepicker1.DataBindings.Add("text", dataGridView1.DataSource, "Birthday"); and …