Prosedur Penyelesaian Latihan_44_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_44_36110048

    Dim bridgeRio As New OleDb.OleDbConnection(" Provider = microsoft.ace.oledb.12.0; data source = " & Application.StartupPath & "\Data Grafik.accdb")

    Dim tableRio As New DataTable

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

        Dim truckRio As New OleDb.OleDbDataAdapter

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

        tableRio.Rows.Clear()

        truckRio.Fill(tableRio)

        DGV_36110048.DataSource = tableRio

        truckRio.Dispose()

        GRAFIK_36110048.RowCount = tableRio.Rows.Count

        GRAFIK_36110048.ColumnCount = 3

        Dim Posisi As Integer = 0

        For Each BarisX As DataRow In tableRio.Rows

            Posisi = Posisi + 1

            GRAFIK_36110048.Row = Posisi

            GRAFIK_36110048.RowLabel = BarisX("Bulan")

            GRAFIK_36110048.Column = 1

            GRAFIK_36110048.Data = BarisX("Unit")

            GRAFIK_36110048.Column = 2

            GRAFIK_36110048.Data = BarisX("Rata-Rata Harga") / 1000

            GRAFIK_36110048.Column = 3

            GRAFIK_36110048.Data = BarisX("Jumlah") / 10000

        Next

    End Sub

    Private Sub BATANG_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BATANG_36110048.Click

        GRAFIK_36110048.chartType = MSChart20Lib.VtChChartType.VtChChartType2dBar

    End Sub

    Private Sub BATANG3D_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BATANG3D_36110048.Click

        GRAFIK_36110048.chartType = MSChart20Lib.VtChChartType.VtChChartType3dBar

    End Sub

    Private Sub LINE_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LINE_36110048.Click

        GRAFIK_36110048.chartType = MSChart20Lib.VtChChartType.VtChChartType2dLine

    End Sub

    Private Sub LINE3D_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LINE3D_36110048.Click

        GRAFIK_36110048.chartType = MSChart20Lib.VtChChartType.VtChChartType3dLine

    End Sub

    Private Sub LINGKAR_36110048_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles LINGKAR_36110048.Click

        GRAFIK_36110048.chartType = MSChart20Lib.VtChChartType.VtChChartType2dPie

    End Sub

End Class

6.      Setelah itu, jalankan programnya.