Public Class Latihan_44_46110021
Dim Jalan As New
OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source =" & Application.StartupPath & "\Datachart_46110021.ACCDB")
Dim gitik As New DataTable
Private Sub Latihan44_083_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim
kacci As New
OleDb.OleDbDataAdapter
kacci = New
OleDb.OleDbDataAdapter("select * from
qpembelianperbulanan", Jalan)
gitik.Rows.Clear()
kacci.Fill(gitik)
kacci.Dispose()
DataGridView1_46110021.DataSource =
gitik
chart_46110021.RowCount =
gitik.Rows.Count
chart_46110021.ColumnCount = 3
'memasukkan
data ke setiap baris dan setiap kolom dari tabel keuangan
Dim
sekarang As Integer
= 0
For Each kake As DataRow In gitik.Rows
sekarang = sekarang + 1
chart_46110021.Row = sekarang
chart_46110021.RowLabel = kake("Bulan")
chart_46110021.Column = 1
chart_46110021.Data = kake("Unit")
chart_46110021.Column = 2
chart_46110021.Data = kake("Rata-Rata Harga") / 10000
chart_46110021.Column = 3
chart_46110021.Data = kake("Jumlah") / 10000
Next
End Sub
Private Sub GB1_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles batang_46110021.Click
chart_46110021.chartType =
MSChart20Lib.VtChChartType.VtChChartType2dBar
End Sub
Private Sub GL_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles line_46110021.Click
chart_46110021.chartType =
MSChart20Lib.VtChChartType.VtChChartType2dLine
End Sub
Private Sub GLK_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles
lingkaran_46110021.Click
chart_46110021.chartType =
MSChart20Lib.VtChChartType.VtChChartType2dPie
End Sub
Private Sub GB2_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles
batang3d_46110021.Click
chart_46110021.chartType =
MSChart20Lib.VtChChartType.VtChChartType3dBar
End Sub
Private Sub GL3_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles line3d_46110021.Click
chart_46110021.chartType =
MSChart20Lib.VtChChartType.VtChChartType3dLine
End Sub
End Class
LANGKAH UNTUK MENJALANKAN FORM
Untuk memudahkan pakailah navigator
Pilih tombol start debugging lalu pilih form Latihan_44_46110021, maka jendela Latihan_44_46110021 akan muncul. dan chart akan terbentuk sesuai dengan data yang ada pada datagridview dan sesuai dengan button yang anda pilih