Advertisement
JonathanYofi

Untitled

Jul 20th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. 'Button simpan
  2. Private Sub Bt_simpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bt_simpan.Click
  3. Try
  4. For Each row As DataGridViewRow In dg_normalisasi.Rows
  5. Call mengkoneksikan()
  6. Dim simpan As String = String.Empty
  7. simpan = "insert into tb_normalisasi (tgl_penilaian,kd_alter,Nama,nilai_timework,nilai_mskrj,nilai_presensi,nilai_kreatif, nilai_total) values ('" & tgl_input.Text & _
  8. "','" & Convert.ToString(row.Cells(0).Value) & "','" & Convert.ToString(row.Cells(1).Value) & _
  9. "','" & Convert.ToString(row.Cells(2).Value) & "','" & Convert.ToString(row.Cells(3).Value) & _
  10. "','" & Convert.ToString(row.Cells(4).Value) & "','" & Convert.ToString(row.Cells(5).Value) & _
  11. "','" & Convert.ToString(row.Cells(6).Value) & "')"
  12.  
  13. CMD = New OdbcCommand(simpan, CONN)
  14. CMD.ExecuteNonQuery()
  15. CMD.Dispose()
  16. Next
  17. '====================
  18. 'Pesan Jika Berhasil
  19. '====================
  20. MessageBox.Show("Data Perhitungan Baru Berhasil Di Simpan")
  21.  
  22. Catch ex As Exception
  23. '=================
  24. 'Pesan Jika Gagal
  25. '=================
  26. MessageBox.Show("Data Perhitungan Sudah Ada Tolong Di Cek Kembali, Mohon Di Cek Kembali")
  27. End Try
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement