Deskripsi_Latihan_44_36110054

Cara Membuat Progam/Apliaksi Latihan 44

Dengan Software Microsoft Visual Basic 2008

Form Latihan 44 terdapat tiga object yaitu Microsoft Chart Control, Button dan Dategridview

Object  Microsoft chart control
Terdapat satu buah MicrosofChartControl digunakan untuk menampilkan chart atau diagram dari database
 
Object  DateGridView
Terdapat satu object DataGridView digunakan untuk menampilkan  field  QpembelianPerBulanan yang terdapat dalam data D:\RusLan\Materi Kuliah\Apkom 4\LATIHAN 41-44 GRAFIK\Data Grafik.accdb")

 
Object  Button
Terdapat lima object button (grafik batang, grafik line, grafik lingkar, grafik batang 3D, dan grafik line 3D).

Even

FromLoad

ButtonClick

 Langkah 1 :

Buka Aplikasi Visual Basic 2008/Visual Studio 2008

Langkah 2 :

   Buat Project Baru dengan Cara,

-          File| New Project | Windows From Application,

-          Dan Nama Project Tersebut.

-          Lihat Gambar Berikut :

Langkah 3 :

Rancanglah Form Seperti Gambar Berikut Berikut :

    Langkah  4 :

Masukkan Rumus untuk menjalankan form di atas .

Berikut ini Rumus untuk menjalankan form :

Public Class Latihan_44_36110054

    Dim cullank As New OleDb.OleDbConnection(" Provider = microsoft.ace.oledb.12.0; data source = D:\RusLan\Materi Kuliah\Apkom 4\LATIHAN 41-44 GRAFIK\Data Grafik.accdb")

    Dim ruslan As New DataTable

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

        Dim ruru As New OleDb.OleDbDataAdapter

        ruru = New OleDb.OleDbDataAdapter("Select * From QPembelianPerBulanan", cullank)

        ruslan.Rows.Clear()

        ruru.Fill(ruslan)

        dgv_36110054.DataSource = ruslan

        ruru.Dispose()

        chart_36110054.RowCount = ruslan.Rows.Count

        chart_36110054.ColumnCount = 3

        Dim Posisi As Integer = 0

        For Each BarisX As DataRow In ruslan.Rows

            Posisi = Posisi + 1

            chart_36110054.Row = Posisi

            chart_36110054.RowLabel = BarisX("Bulan")

            chart_36110054.Column = 1

            chart_36110054.Data = BarisX("Unit")

            chart_36110054.Column = 2

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

            chart_36110054.Column = 3

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

        Next

    End Sub

    Private Sub gb1_36110054_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles gb1_36110054.Click

        chart_36110054.chartType = MSChart20Lib.VtChChartType.VtChChartType2dBar

    End Sub

    Private Sub line1_36110054_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles line1_36110054.Click

        chart_36110054.chartType = MSChart20Lib.VtChChartType.VtChChartType2dLine

    End Sub

    Private Sub gl_36110054_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles gl_36110054.Click

        chart_36110054.chartType = MSChart20Lib.VtChChartType.VtChChartType2dPie

    End Sub

    Private Sub gb2_36110054_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles gb2_36110054.Click

        chart_36110054.chartType = MSChart20Lib.VtChChartType.VtChChartType3dBar

    End Sub

    Private Sub line2_36110054_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles line2_36110054.Click

        chart_36110054.chartType = MSChart20Lib.VtChChartType.VtChChartType3dLine

    End Sub

End Class