No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
we r trying to insert date from datetime picker into mssqlserver 2005 but it also enter defult time(00:00) with it in database. using we want only date... [CODE]& xyzdtp.value.date &[/CODE] 
|
|
|
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 … 
|