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 3,5 : date
This is my code:

for (int i = 0; i < dataGridView1.Rows.Count; i++) // dòng
                {
                        string str = "Server=localhost;Port=3306;Database=sinhvien;Uid=root;Pwd=1234;";
                        MySqlConnection constr = new MySqlConnection(str);
                        constr.Open(); 
                        String cmdText = "INSERT INTO danhsachsinhvien (idSinhVien, Ho, Ten, Ngaysinh, Ghichu,Ngaythi ,Buoithi) VALUES ('"
                                                   + dataGridView1.Rows[i].Cells[0].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[1].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[2].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[3].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[4].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[5].Value + "','"
                                                   + dataGridView1.Rows[i].Cells[6].Value + "')";
                        MySqlCommand cmd = new MySqlCommand(cmdText, constr);
                        cmd.ExecuteNonQuery();

                }

Recommended Answers

Darn it VB....

Jump to Post

All 3 Replies

Darn it VB....

dataGridView1.Rows[i].Cells[0].Value

Should be

Convert.ToDateTime(dataGridView1.Rows[i].Cells[0].Value).ToString("yyyy-MM-dd HH:mm:ss.fff")

You should follow the format of MySQL in order to save it from MySQL.

the format is yyyy-MM-dd HH:mm:ss ex. 2015-01-01 00:00:00
yyyy for four digit year
MM for two digit month
dd for two digit day
HH for two digit military hour time
mm for two digit minute
ss for two digit second

Please read string format for more info.

Sir. J.C. SolvoTerra is right. convert the data of datagrid to date in order to save it in MySQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.