เพิ่มค่าจาก GridView ลง ฐานข้อมูลทีละหลายๆค่าไม่ได้อ่ะครับ

Try

cmd.CommandType = CommandType.Text;
            
            string ID = txtid.Text;

            cmd.CommandText = " insert into Order_1 (Date,ID,com_name) values('" + dtp1.Value.ToString("MM-dd-yyyy") + "','" + ID + "','" + cboCom.SelectedValue + "')";
           cmd.Connection = Conn;
           cmd.ExecuteNonQuery();
           ;

            foreach (DataGridViewRow gvr in GridView1.Rows)
            {
               
                cmd.CommandText = "insert into Order_detail(Order_id,Pro_id,Order_Size,Order_Qualty,Order_Price)values ('" +txtid.Text +"','" + gvr.Cells[0].Value + "','" + gvr.Cells[1].Value + "','" + gvr.Cells[2].Value+ "','" + gvr.Cells[3].Value + "')";
                
                cmd.Connection = Conn;
                cmd.ExecuteNonQuery();
             
            }
            MessageBox.Show("ทำรายการสำเร็จ");

Catch ex As Exception

MsgBox(ex.Message)

End Try

string ID = txtid.Text;
cmd.CommandText = " insert into Order_1 (Date,ID,com_name) values('" + dtp1.Value.ToString("MM-dd-yyyy") + "','" + ID + "','" + cboCom.SelectedValue + "')";
cmd.CommandText = "insert into Order_detail(Order_id,Pro_id,Order_Size,Order_Qualty,Order_Price)values ('" +txtid.Text +"','" + gvr.Cells[0].Value + "','" + gvr.Cells[1].Value + "','" + gvr.Cells[2].Value+ "','" + gvr.Cells[3].Value + "')";