aplikasi datasiwa
DESCRIPTION
tugas pemrograman database membuat aplikasi datasiswa dengan menggunakan vb.net 2005TRANSCRIPT
1
APLIKASI DATA SISWA
MENGGUNAKAN VB.NET 2005
Untuk memenuhi Tugas Pemrograman Database (Vb.Net 2005)
Dosen Sri Kuswayati
Penyusun
Mislena
114060002
IF / R4 / SI
STMIK JABAR SEKOLAH TINGGI MANAJEMEN INFORMATIKA DAN KOMPUTER JAWA BARAT
Jl. Soekarno-Hatta No. 775-777 Telp.Fax. (022)7335108, 73474775 Bandung 40293
Jl. Cisaranten Kulon No. 140 Soekarno – Hatta Bandung 40293
http://www.stmik-jabar.ac.id email: [email protected]
2
KATA PENGANTAR
Segala Puji dan Syukur penulis Panjatkan atas Kehadirot Allah SWT, karena berkat
Rahmat dan Hidayahnya la penulis bisa menyelesaikan makalah ini untuk mencoba ilmu–
ilmu yang di peroleh selama mengikuti mata kuliah Pemrograman Database VB.Net dengan
“Judul Aplikasi Data Siswa ”.
Dan tak lupa penulis ucapkan terima kasih kepada
1. Ibu Sri Kuswayati yang telah membimbing dan mengajar dengan penuh kesabaran
2. Dan teman-teman seperjuangan yang selalu membantu penulis, dan selalu mendukung
penulis dalam menyelesaikan tugas makalah ini sampai dengan selesai
Penulis menyadari di dalam makalah ini terlalu banyak kekurangan dan jauh dari
kesempurnaan, untuk itu penulis dengan kerendahan hati penulis mengharapkan masukan,
kritikan dan saran yang membangun agar penulis bisa memperbaiki diri.
Bandung, Juni 2012
Penulis
3
Daftar Isi
Kata Pengantar .................................................................................................................. 1
BAB I PENDAHULUAN.................................................................................................. 4
A. Latarbelakang.............................................................................................................. 4
B. Tujuan............ ...................................................................................................…… 4
BAB II PERANCANGAN PROGRAM .......................................................................... 5
A. Konsep Sistem Informasi ................................................................................... 5
1) Aplikasi ........................................................................................................... 5
3) Visual Basic Data .......................................................................................... 5
B. Rancangan Database.................................................................................................... 6
1) Struktur Tabel ................................................................................................ 6
2) Relationship Diagram ..................................................................................... 7
C. Rancangan Interface ....................................................... 7
1. Menu Login ................................................................................................. 8
2. Menu User / pengguna .................................................................................... 8
3. Menu Ganti Password .................................................................................... 9
4. Menu Utama ................................................................................................. 9
5. Form Data Siswa ........................................................................................... 10
6. Form Pembayaran ......................................................................................... 10
7. Form Angkatan ........................................................................................... 11
8. Laporan Data Siswa ...................................................................................... 11
4
9. Laporan Pembayaran ...................................................................................... 12
10. Laporan Angkatan ....................................................................................... 12
D. Coding (Kode Program) ....................................................................................... 13
1. Coding Login……………................................................................................ 13
2. Coding master Kasir…….................................................................................. 14
3. Coding ganti password..................................................................................... 16
4. Coding Menu Utama.............................................................................. 18
5. Coding Data Siswa.................................................................................. 19
6. Coding Pembayaran................................................................................ 22
7. Coding Angkatan.................................................................................... 26
BAB III PENUTUP ......................................................................................................... 29
A. Kesimpulan ..................................................................................................... 29
B. Saran ............................................................................................................... 29.
5
BAB I
PENDAHULUAN
A. Latar Belakang
Dengan adanya komputerisasi baik di dunia kerja maupun di dunia bisnis, efesiensi
dunia kerja dan waktu sangat di butuhkan agar dapat tercapai produktivitas yang
maksimal. Di dalam dunia kerja saat ini aplikasi komputerisasi sudah ada di setiap
bidang pekerjaan apalagi yang berkaitan dengan data-data yang penting baik bersifat
sementara atau tetap.
Laporan data siswa selama ini memang sudah terkomputerisasi, akan tetapi masih
tetap kurang efesien sehingga dapat di bangun suatu aplikasi perangkat lunak dengan
menggunkan basic data agar lebih efesien dan efektif. Dengan latar belakang di atas
penulis membuat makalah dengan judul “ Data Siswa “.
B. Tujuan
Secara umum tujuan pembuatan makalah pemrograman basic database VB.Net 2005 “
Data Siswa”ialah : untuk mengetahui bagaimana cara mengelolah data siswa dengan
mudah, dipahami oleh orang yang membutuhkan informasi tersebut.
6
BAB II
PERANCANGAN PROGRAM
A. Konsep Sistem Informasi
1. Aplikasi
adalah suatu subkelas perangkat lunak komputer yang memanfaatkan kemampuan
komputer langsung untuk melakukan suatu tugas yang diinginkan pengguna.
Biasanya dibandingkan dengan perangkat lunak sistem yang mengintegrasikan
berbagai kemampuan komputer, tapi tidak secara langsung menerapkan kemampuan
tersebut untuk mengerjakan suatu tugas yang menguntungkan pengguna. Contoh
utama perangkat lunak aplikasi adalah pengolah kata, lembar kerja, dan pemutar
media.
2. Visual Basic 2005
Visual besic 2005 (VB.Net) merupakan bahasa pemrograman berbasis GUI
(Graphical User Interface) atau program yang memungkinkan pengguna
berkomunikasi dengan computer menggunakan gambar atau grafik. Visual Basic
2005 adalah salah satu bahasa pemrograman yang di buat oleh Microsoft corporation
dan VB 2005 merupakan pengembangan dari Visual Basic 2006 (VB.6). Visual
Basic 2005 merupakan suatu pengambangan Aplikasi pemrograman Visual Studio
2005. Visual Basic 2005 menggunakan . NET Framework 2.0.
7
3. Rancangan database
a. Table data kasir
b. Tabel Data_siswa
c. Tabel Pembayaran
d. Tabel Angkatan
8
d. Table Angkatan
e. Relationship Diagram
Berikut ini adalah relationship
9
4. Menu Aplikasi Data_Siswa
a. Menu Login
b. Menu User
10
c. Ganti password
d. Menu Utama
11
e. Form Data_Siswa
f. Form Pembayaran_Siswa
12
g. Form Angkatan_Siswa
h. Laporan Data_Siswa
13
i. Laporan Pembayaran
j. Laporan Angkatan
14
5. Coding login
Public Class Login
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Or TextBox2.Text = "" Then
MsgBox("Data Login Belum Lengkap")
Exit Sub
Else
Call koneksi()
CMD = New OleDbCommand("select * from TBLKasir where
Nama_kasir='" & TextBox1.Text & "' and Pwd_kasir='" & TextBox2.Text & "'",
CONN)
RD = CMD.ExecuteReader
RD.Read()
If RD.HasRows Then
Me.Visible = False
MenuUtama.Show()
MenuUtama.Label1.Text = RD.Item("Kode_kasir")
MenuUtama.Label2.Text = RD.Item("Nama_kasir")
MenuUtama.Label3.Text = RD.Item("Status_kasir")
If MenuUtama.Label3.Text <> "ADMIN" Then
MenuUtama.UserToolStripMenuItem.Enabled = False
Else
MenuUtama.UserToolStripMenuItem.Enabled = True
End If
Else
MsgBox("Password Salah")
End If
End If
End Sub
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If e.KeyChar = Chr(13) Then TextBox2.Focus()
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox2.KeyPress
If e.KeyChar = Chr(13) Then Button1.Focus()
End Sub
Private Sub Label2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Label2.Click
End Sub
15
6. Coding master kasir
Imports System.Data.OleDb
Public Class MasterKasir
Sub TampilStatus()
Call koneksi()
CMD = New OleDbCommand("select distinct status_kasir from
tblkasir", CONN)
RD = CMD.ExecuteReader
ComboBox1.Items.Clear()
Do While RD.Read
ComboBox1.Items.Add(RD.Item("status_kasir"))
Loop
End Sub
Sub kosongkan()
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
ComboBox1.Text = ""
TextBox1.Focus()
End Sub
Sub TampilData()
DA = New OleDbDataAdapter("select * from tblkasir", CONN)
DS = New DataSet
DA.Fill(DS, "kasir")
dgv.DataSource = DS.Tables("kasir")
dgv.ReadOnly = True
End Sub
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
TextBox1.MaxLength = 5
If e.KeyChar = Chr(13) Then
Call koneksi()
CMD = New OleDbCommand("select * from tblkasir where
kode_kasir='" & TextBox1.Text & "'", CONN)
RD = CMD.ExecuteReader
RD.Read()
If Not RD.HasRows Then
TextBox2.Text = ""
TextBox3.Text = ""
ComboBox1.Text = ""
TextBox2.Focus()
Else
TextBox2.Text = RD.Item("nama_kasir")
TextBox3.Text = RD.Item("pwd_kasir")
ComboBox1.Text = RD.Item("status_kasir")
TextBox2.Focus()
End If
End If
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox2.KeyPress
TextBox2.MaxLength = 30
If e.KeyChar = Chr(13) Then TextBox3.Focus()
End Sub
Private Sub TextBox3_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox3.KeyPress
TextBox3.MaxLength = 15
16
If e.KeyChar = Chr(13) Then ComboBox1.Focus()
End Sub
Private Sub ComboBox1_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles ComboBox1.KeyPress
ComboBox1.MaxLength = 15
If e.KeyChar = Chr(13) Then Button1.Focus()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox3.Text = ""
Or ComboBox1.Text = "" Then
MsgBox("Data Belum Lengkap")
Exit Sub
Else
Call koneksi()
CMD = New OleDbCommand("select * from tblkasir where
kode_kasir='" & TextBox1.Text & "'", CONN)
RD = CMD.ExecuteReader
RD.Read()
If Not RD.HasRows Then
Dim Simpan As String = "insert into tblkasir values('" &
TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" &
ComboBox1.Text & "')"
CMD = New OleDbCommand(Simpan, CONN)
CMD.ExecuteNonQuery()
Else
Dim Edit As String = "update tblkasir set nama_kasir='" &
TextBox2.Text & "',pwd_kasir='" & TextBox3.Text & "',status_kasir='" &
ComboBox1.Text & "' where kode_kasir='" & TextBox1.Text & "'"
CMD = New OleDbCommand(Edit, CONN)
CMD.ExecuteNonQuery()
End If
Call TampilData()
Call kosongkan()
Call TampilStatus()
End If
End Sub
Private Sub MasterKasir_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Call koneksi()
Call TampilStatus()
Call kosongkan()
Call TampilData()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
If TextBox1.Text = "" Then
MsgBox("Kode kasir Masih Kosong, Silahkan diisi dulu")
TextBox1.Focus()
Exit Sub
Else
If MessageBox.Show("Yakin Data akan di Hapus ?? ..", "",
MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
Dim hapus As String = "delete * from tblkasir where
kode_kasir='" & TextBox1.Text & "'"
CMD = New OleDbCommand(hapus, CONN)
CMD.ExecuteNonQuery()
Call TampilData()
17
Call kosongkan()
Call TampilStatus()
Else
Call kosongkan()
End If
End If
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button3.Click
Call kosongkan()
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button4.Click
Me.Close()
End Sub
End Class
7. Coding ganti password
Imports System.Data.OleDb
Public Class GantiPassword
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
If e.KeyChar = Chr(13) Then
If TextBox1.Text <> MenuUtama.Label2.Text Then
MsgBox("Anda Tidak berhak mengganti Password")
Exit Sub
Else
TextBox2.Focus()
End If
End If
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox2.KeyPress
If e.KeyChar = Chr(13) Then
Call koneksi()
CMD = New OleDbCommand("select * from tblkasir where
nama_Kasir='" & TextBox1.Text & "' and Pwd_Kasir='" & TextBox2.Text & "'",
CONN)
RD = CMD.ExecuteReader
RD.Read()
If Not RD.HasRows Then
MsgBox("Password Salah")
Exit Sub
Else
TextBox3.Focus()
End If
End If
End Sub
18
Private Sub TextBox3_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox3.KeyPress
If e.KeyChar = Chr(13) Then
If TextBox3.Text = TextBox2.Text Then
MsgBox("Ganti Password yg Baru")
Exit Sub
Else
TextBox4.Focus()
End If
End If
End Sub
Private Sub TextBox4_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TextBox4.KeyPress
If e.KeyChar = Chr(13) Then
If TextBox4.Text <> TextBox3.Text Then
MsgBox("Konfirmasi beda dengan password yg baru")
Exit Sub
Else
If MessageBox.Show("Yakin akan ganti Password .. ?", "",
MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.Yes Then
Dim gantipwd As String = "update tblkasir set pwd_kasir
='" & TextBox3.Text & "' where kode_kasir='" & MenuUtama.Label1.Text & "'"
CMD = New OleDbCommand(gantipwd, CONN)
CMD.ExecuteNonQuery()
MsgBox("password sudah berubah")
Me.Close()
Else
Me.Close()
End If
End If
End If
End Sub
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Label1.Click
End Sub
End Class
19
9. Coding Menu Utama
Public Class MenuUtama
Private Sub KeluarToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
KeluarToolStripMenuItem.Click
End
End Sub
Private Sub DataSiswaToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
DataSiswaToolStripMenuItem.Click
datasiswa.Show()
End Sub
Private Sub AngkatanToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
AngkatanToolStripMenuItem.Click
Angkatan.Show()
End Sub
Private Sub PembayaranToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
PembayaranToolStripMenuItem.Click
Pembayaran.Show()
End Sub
Private Sub LaporanAngkatanToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
LaporanAngkatanToolStripMenuItem.Click
CR.ReportFileName = "LaporanAngkatan.rpt"
CR.WindowState = Crystal.WindowStateConstants.crptMaximized
CR.RetrieveDataFiles()
CR.Action = 1
End Sub
Private Sub LaporanSiswaToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
LaporanSiswaToolStripMenuItem.Click
CR.ReportFileName = "Laporandata_siswa.rpt"
CR.WindowState = Crystal.WindowStateConstants.crptMaximized
CR.RetrieveDataFiles()
CR.Action = 1
End Sub
20
Private Sub LaporanPembayaranToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
LaporanPembayaranToolStripMenuItem.Click
CR.ReportFileName = "Laporanpembayaran.rpt"
CR.WindowState = Crystal.WindowStateConstants.crptMaximized
CR.RetrieveDataFiles()
CR.Action = 1
End Sub
Private Sub LaporToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
LaporToolStripMenuItem.Click
End Sub
End Class
10. Coding form Data Siswa
Public Class datasiswa
Dim con As New
OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\belajar\project
v.net\WindowsApplication1\bin\Debug\Data_siswa.mdb"))
Dim dtsiswa As New DataTable()
Dim drsiswa As DataRow
Dim dasiswa As OleDb.OleDbDataAdapter
Function Koneksi(ByVal strDatabase As String) As String
Dim kalimat As String
kalimat = "Provider=Microsoft.Jet.OLEDB.4.0;"
kalimat &= "Data Source=" & strDatabase & ""
Return kalimat
End Function
Sub kosong()
txtnim.Text = ""
txtnama.Text = ""
txtalamat.Text = ""
txttelpon.Text = ""
Rblaki.Checked = False
RbPerempuan.Checked = False
txtnim.Focus()
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim dc(1) As DataColumn
Try
dasiswa = New OleDb.OleDbDataAdapter("select * from
DATA_SISWA", con)
dasiswa.Fill(dtsiswa)
dc(0) = dtsiswa.Columns("NIM")
dtsiswa.PrimaryKey = dc
21
Dgkursus.DataSource = dtsiswa
Catch errConn As OleDb.OleDbException
MsgBox(errConn.Message)
End Try
End Sub
Private Sub btncari_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btncari.Click
Try
drsiswa = dtsiswa.Rows.Find(txtnim.Text)
txtnim.Text = drsiswa("NIM").ToString
txtnama.Text = drsiswa("NAMA").ToString
txtalamat.Text = drsiswa("ALAMAT").ToString
txttelpon.Text = drsiswa("TELPON").ToString
If drsiswa("JENIS_KELAMIN").ToString = "Laki - Laki" Then
Rblaki.Checked = True
Else
RbPerempuan.Checked = True
End If
Catch errCari As Exception
MsgBox(errCari.Message)
End Try
End Sub
Private Sub btnselesai_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btnselesai.Click
Me.Close()
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnhapus.Click
Try
Dim cbsiswa As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(dasiswa)
drsiswa.Delete()
dasiswa.DeleteCommand = cbsiswa.GetDeleteCommand
dasiswa.Update(dtsiswa)
dtsiswa.AcceptChanges()
dasiswa.DeleteCommand.Connection.Close()
Catch errHapus As Exception
MsgBox(errHapus.Message)
22
End Try
End Sub
Private Sub btntambah_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btntambah.Click
Try
Dim cbsiswa As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(dasiswa)
drsiswa = dtsiswa.NewRow
drsiswa("NIM") = txtnim.Text
drsiswa("NAMA") = txtnama.Text
drsiswa("ALAMAT") = txtalamat.Text
drsiswa("TELPON") = txttelpon.Text
If Rblaki.Checked Then
drsiswa("JENIS_KELAMIN") = "Laki - Laki"
Else
drsiswa("JENIS_KELAMIN") = "Perempuan"
End If
dtsiswa.Rows.Add(drsiswa)
con.Open()
dasiswa.Update(dtsiswa)
dtsiswa.AcceptChanges()
con.Close()
Catch errTambah As Exception
MsgBox(errTambah.Message)
End Try
kosong()
End Sub
End Class
23
5. Form Coding Pembayaran
Public Class Pembayaran
Dim con As New
OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\belajar\project
v.net\WindowsApplication1\bin\Debug\Data_siswa.mdb"))
Dim dtkursus As New DataTable()
Dim drkursus As DataRow
Dim dakursus As OleDb.OleDbDataAdapter
Dim dtsiswa As New DataTable()
Dim drsiswa As DataRow
Dim dasiswa As OleDb.OleDbDataAdapter
Dim dtangkatan As New DataTable()
Dim drangkatan As DataRow
Dim daangkatan As OleDb.OleDbDataAdapter
Dim total, modul, spp, biayaujian As Integer
Function Koneksi(ByVal strDatabase As String) As String
Dim kalimat As String
kalimat = "Provider=Microsoft.Jet.OLEDB.4.0;"
kalimat &= "Data Source=" & strDatabase & ""
Return kalimat
End Function
Private Sub Form2_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim dc(1) As DataColumn
Try
dasiswa = New OleDb.OleDbDataAdapter("select * from
DATA_SISWA", con)
dasiswa.Fill(dtsiswa)
dc(0) = dtsiswa.Columns("NIM")
dtsiswa.PrimaryKey = dc
With listsiswa
.DataSource = dtsiswa
.DisplayMember = "NIM"
.ValueMember = "NIM"
End With
daangkatan = New OleDb.OleDbDataAdapter("select * from
ANGKATAN", con)
daangkatan.Fill(dtangkatan)
dc(0) = dtangkatan.Columns("NO_ANGKATAN")
dtangkatan.PrimaryKey = dc
With Lstprogramstudi
.DataSource = dtangkatan
.DisplayMember = "NO_ANGKATAN"
.ValueMember = "NO_ANGKATAN"
End With
dakursus = New OleDb.OleDbDataAdapter("select * from
PEMBAYARAN", con)
24
dakursus.Fill(dtkursus)
dc(0) = dtkursus.Columns("NO_PEMBAYARAN")
dtkursus.PrimaryKey = dc
gridbayar.DataSource = dtkursus
Catch errConn As OleDb.OleDbException
MsgBox(errConn.Message)
End Try
End Sub
Private Sub kosong()
txtno_pembayaran.Text = ""
txtnim.Text = ""
txtspp.Text = ""
txtmodul.Text = ""
txtbiayaujian.Text = ""
txtno_pembayaran.Focus()
End Sub
Private Sub lbxno_angkatan_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs)
End Sub
Private Sub lbxspp_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles lbxspp.Click
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnhapus.Click
Try
Dim cbkursus As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(dakursus)
drkursus.Delete()
dakursus.DeleteCommand = cbkursus.GetDeleteCommand
dakursus.Update(dtkursus)
dtkursus.AcceptChanges()
dakursus.DeleteCommand.Connection.Close()
Catch errHapus As Exception
MsgBox(errHapus.Message)
End Try
End Sub
Private Sub btnproses_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btntambah.Click
Try
Dim cbTambah As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(dakursus)
drkursus = dtkursus.NewRow
25
drkursus("NO_PEMBAYARAN") = txtno_pembayaran.Text
drkursus("NIM") = txtnim.Text
drkursus("NAMA") = txtnama.Text
drkursus("NO_ANGKATAN") = Lstprogramstudi.Text
drkursus("PROGRAM_STUDI") = txtprogramstudi.Text
drkursus("JENJANG") = txtjenjang.Text
drkursus("SPP") = txtspp.Text
drkursus("MODUL") = txtmodul.Text
drkursus("BIAYA_UJIAN") = txtbiayaujian.Text
drkursus("TOTAL") = txttotal.Text
dtkursus.Rows.Add(drkursus)
con.Open()
dakursus.Update(dtkursus)
dtkursus.AcceptChanges()
con.Close()
Catch errTambah As Exception
MsgBox(errTambah.Message)
End Try
kosong()
End Sub
Private Sub btncari_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btncari.Click
Try
drkursus = dtkursus.Rows.Find(txtno_pembayaran.Text)
txtno_pembayaran.Text = drkursus("NO_PEMBAYARAN").ToString
listsiswa.Text = drkursus("NIM").ToString
Lstprogramstudi.Text = drkursus("NO_ANGKATAN").ToString
txtspp.Text = drkursus("SPP").ToString
txtmodul.Text = drkursus("MODUL").ToString
txtbiayaujian.Text = drkursus("BIAYA_UJIAN").ToString
drkursus("TOTAL") = txttotal.Text
Catch errCari As Exception
MsgBox(errCari.Message)
End Try
End Sub
Private Sub btnselesai_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnselesai.Click
Me.Close()
End Sub
Private Sub Lstno_pembayaran_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Lstprogramstudi.SelectedIndexChanged
26
Try
drangkatan = dtangkatan.Rows.Find(Lstprogramstudi.Text)
txtprogramstudi.Text = drangkatan("PROGRAM_STUDI").ToString
txtjenjang.Text = drangkatan("JENJANG").ToString
Catch errTampil As Exception
End Try
End Sub
Private Sub ListBox1_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
listsiswa.SelectedIndexChanged
Try
drsiswa = dtsiswa.Rows.Find(listsiswa.Text)
txtnim.Text = drsiswa("NIM").ToString
txtnama.Text = drsiswa("NAMA").ToString
Catch errTampil As Exception
End Try
End Sub
Private Sub txtbiayaujian_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles txtbiayaujian.KeyPress
If e.KeyChar = Chr(13) Then
modul = txtmodul.Text
spp = txtspp.Text
biayaujian = txtbiayaujian.Text
total = txttotal.Text
total = modul + spp + biayaujian
txttotal.Text = total
btntambah.Focus()
End If
If Not ((e.KeyChar >= "0" And e.KeyChar <= "9") Or e.KeyChar =
vbBack) Then e.Handled = True
End Sub
Private Sub txtspp_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles txtspp.KeyPress
If e.KeyChar = Chr(13) Then
txtmodul.Focus()
End If
If Not ((e.KeyChar >= "0" And e.KeyChar <= "9") Or e.KeyChar =
vbBack) Then e.Handled = True
End Sub
Private Sub txtmodul_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles txtmodul.KeyPress
If e.KeyChar = Chr(13) Then
txtbiayaujian.Focus()
27
End If
If Not ((e.KeyChar >= "0" And e.KeyChar <= "9") Or e.KeyChar =
vbBack) Then e.Handled = True
End Sub
End Class
6. Form Coding Angkatan
Public Class Angkatan
Dim con As New
OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\belajar\project
v.net\WindowsApplication1\bin\Debug\Data_siswa.mdb"))
Dim dtangkatan As New DataTable()
Dim drangkatan As DataRow
Dim daangkatan As OleDb.OleDbDataAdapter
Function Koneksi(ByVal strDatabase As String) As String
Dim kalimat As String
kalimat = "Provider=Microsoft.Jet.OLEDB.4.0;"
kalimat &= "Data Source=" & strDatabase & ""
Return kalimat
End Function
Private Sub fmangkatan_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim dc(1) As DataColumn
Try
daangkatan = New OleDb.OleDbDataAdapter("select * from
ANGKATAN", con)
daangkatan.Fill(dtangkatan)
dc(0) = dtangkatan.Columns("NO_ANGKATAN")
dtangkatan.PrimaryKey = dc
gridangkatan.DataSource = dtangkatan
Catch errConn As OleDb.OleDbException
MsgBox(errConn.Message)
End Try
End Sub
Private Sub btnproses_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnproses.Click
Try
Dim cbangkatan As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(daangkatan)
drangkatan = dtangkatan.NewRow
28
drangkatan("NO_ANGKATAN") = txtno_angkatan.Text
drangkatan("PROGRAM_STUDI") = cbxprogramstudi.Text
drangkatan("JENJANG") = txtjenjang.Text
dtangkatan.Rows.Add(drangkatan)
con.Open()
daangkatan.Update(dtangkatan)
dtangkatan.AcceptChanges()
con.Close()
Catch errTambah As Exception
MsgBox(errTambah.Message)
End Try
End Sub
Private Sub btncari_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btncari.Click
Try
drangkatan = dtangkatan.Rows.Find(txtno_angkatan.Text)
txtno_angkatan.Text = drangkatan("NO_ANGKATAN").ToString
cbxprogramstudi.Text = drangkatan("PROGRAM_STUDI").ToString
txtjenjang.Text = drangkatan("JENJANG").ToString
Catch errCari As Exception
MsgBox(errCari.Message)
End Try
End Sub
Private Sub btnhapus_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnhapus.Click
Try
Dim cbangkatan As OleDb.OleDbCommandBuilder = New
OleDb.OleDbCommandBuilder(daangkatan)
drangkatan.Delete()
daangkatan.DeleteCommand = cbangkatan.GetDeleteCommand
daangkatan.Update(dtangkatan)
dtangkatan.AcceptChanges()
daangkatan.DeleteCommand.Connection.Close()
Catch errHapus As Exception
MsgBox(errHapus.Message)
End Try
End Sub
Private Sub lbxjenjang_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles lbxjenjang.Click
End Sub
Private Sub btnselesai_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnselesai.Click
Close()
End Sub
29
End Claass
BAB III
30
PENUTUP
A. Kesimpulan
Secara umum tujuan pembuatan makalah pemrograman basic database VB.Net 2005 “
Aplikasi Data Siswa” ialah : untuk mengetahui bagaimana cara mengelolah data siswa
dengan mudah, dipahami oleh orang yang membutuhkan informasi tersebut.
B. Saran
Selain memahami database yang ada pada makalah ini, pembaca juga bisa memperoleh
informasi sumber-sumber yang lain agar bisa membantu dalam mempelajari database
dan aplikasi visual studio.
Diharapkan makalah ini berguna dan dapat menjadi sarana pembelajaran oleh
pembaca. Semoga pembaca lebih paham mengenai database dan aplikasi lain
pendukungnya.