Prosedur Penyelesaian Latihan_34B_36110048

1.      Klik Start lalu pilih Microsoft Visual Studio 2008

2.      Lalu akan muncul jendela awal Microsoft Visual Studio seperti di bawah ini.

3.      Lalu pilih New Project dan beri nama serta pilih tempat folder untuk menyimpannya.

4.      Kemudian buat form sesuai dengan form di bawah ini.

5.      Berikut ini adalah rumus untuk menjalankan form di atas.

Public Class Latihan_34B_36110048

    Dim bridgeRio As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Rhyo\SEMESTER 5\Apkom 4\LATIHAN 27-34 SIMPAN EDIT DELETE DATA\DATABARANG.accdb")

    Dim tabelRio As New DataTable

    Public Sub isiRio()

        Dim truckRio As New OleDb.OleDbDataAdapter

        truckRio = New OleDb.OleDbDataAdapter("Select * From BARANG", bridgeRio)

        tabelRio.Rows.Clear()

        truckRio.Fill(tabelRio)

        truckRio.Dispose()

    End Sub

    Private Sub Latihan_34B_36110048_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        isiRio()

        DGV_36110048.DataSource = tabelRio

    End Sub

    Private Sub TAMBAH_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TAMBAH_36110048.Click

        If Latihan_34C_36110048.Visible = False Then

            Latihan_34C_36110048.MdiParent = Me.MdiParent

            Latihan_34C_36110048.Show()

        Else

            Latihan_34C_36110048.Activate()

            Latihan_34C_36110048.WindowState = FormWindowState.Normal

            Latihan_34C_36110048.TOOL2_36110048.Text = "-"

        End If

        Latihan_34C_36110048.KB_36110048.Text = ""

        Latihan_34C_36110048.NB_36110048.Text = ""

        Latihan_34C_36110048.HJ_36110048.Text = ""

        Latihan_34C_36110048.JB_36110048.Text = ""

        Latihan_34C_36110048.TOOL2_36110048.Text = "-"

    End Sub

    Private Sub EDIT_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles EDIT_36110048.Click

        If Latihan_34C_36110048.Visible = False Then

            Latihan_34C_36110048.MdiParent = Me.MdiParent

            Latihan_34C_36110048.Show()

        Else

            Latihan_34C_36110048.Activate()

            Latihan_34C_36110048.WindowState = FormWindowState.Normal

        End If

        Latihan_34C_36110048.KB_36110048.Text = DGV_36110048.CurrentRow.Cells("KODEBARANG").Value

        Latihan_34C_36110048.NB_36110048.Text = DGV_36110048.CurrentRow.Cells("NAMABARANG").Value

        Latihan_34C_36110048.HJ_36110048.Text = DGV_36110048.CurrentRow.Cells("HARGAJUAL").Value

        Latihan_34C_36110048.JB_36110048.Text = DGV_36110048.CurrentRow.Cells("JUMLAHBARANG").Value

        Latihan_34C_36110048.TOOL2_36110048.Text = DGV_36110048.CurrentRow.Cells("KODEBARANG").Value

    End Sub

    Private Sub HAPUS_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles HAPUS_36110048.Click

        Dim truckRio As New OleDb.OleDbCommand

        truckRio = New OleDb.OleDbCommand("Delete * From BARANG Where KODEBARANG = '" & DGV_36110048.CurrentRow.Cells("KODEBARANG").Value & "'", bridgeRio)

        If MsgBox("Apakah Anda Yakin Menghapusnya?", MsgBoxStyle.YesNo) = MsgBoxResult.Yes Then

            bridgeRio.Open()

            truckRio.ExecuteNonQuery()

            bridgeRio.Close()

            truckRio.Dispose()

            isiRio()

        End If

    End Sub

End Class

6.      Setelah itu, jalankan programnya.