Public Class Latihan35 Dim A As New OleDb.OleDbConnection("Provider=microsoft.ACE.OLEDB.12.0;data source=" & Application.StartupPath & "\DATAMAJEMUK.accdb") Dim dt As New DataTable Private Sub Latihan35_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim X As New OleDb.OleDbDataAdapter X = New OleDb.OleDbDataAdapter("Select KODEBARANG, UNIT, HARGA from DETAILTRANSAKSI WHERE NOTRANS= '" & nt070.Text & "'", A) X.Fill(dt) X.Dispose() dgv070.DataSource = dt End Sub Private Sub Tambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Tambah.Click 'a' If kb070.Text.Length = 0 Then MsgBox("Kode barang sudah ada") Exit Sub End If If Val(unit070.Text) = 0 Then MsgBox("Masukkan Harga barang") ...
Komentar
Posting Komentar