Menu Utama
Public Class Menu
Private Sub menuutama_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
End Sub
Private Sub KaryawanToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
KaryawanToolStripMenuItem.Click
Form1.MdiParent = Me
Form1.Show()
End Sub
Private Sub BagianToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
BagianToolStripMenuItem.Click
Formproduk.MdiParent = Me
Formproduk.Show()
End Sub
Private Sub JabatanToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
JabatanToolStripMenuItem.Click
Formsiswa.MdiParent = Me
Formsiswa.Show()
End Sub
Private Sub ExitToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
ExitToolStripMenuItem.Click
End
End Sub
End Class
Listening program Form Kendaraan
Imports System.Data.OleDb
Public Class Form1
Public DB As OleDbConnection
Public CMD As OleDbCommand
Public ADP As OleDbDataAdapter
Public DS As New DataSet
Dim SQL As String
Public DR As OleDbDataReader
Public Sub OpenDB()
Dim
LOKASI = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source = C:\VB2\produk.mdb"
DB = New
OleDbConnection(LOKASI)
If
DB.State = ConnectionState.Closed Then
DB.Open()
End If
End Sub
Sub
ButtonBaru()
btnbaru.Enabled = True
btnSimpan.Enabled = False
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub
ButtonEdit()
btnbaru.Enabled = False
btnSimpan.Enabled = False
btnEdit.Enabled = True
btnHapus.Enabled = True
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
ButtonSimpan()
btnbaru.Enabled = False
btnSimpan.Enabled = True
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
HapusText()
nobk.Text = ""
pemilik.Text = ""
alamat.Text = ""
tahun.Text = ""
warna.Text = ""
norangkamesin.Text = ""
Call
ButtonBaru()
End Sub
Sub
TampilKaryawan()
ADP = New
OleDbDataAdapter("SELECT * FROM
kendaraan", DB)
DS = New
DataSet
ADP.Fill(DS, "kendaraan")
End Sub
Private Sub Form1_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Call
OpenDB()
Call
HapusText()
End Sub
Private Sub btnBaru_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBaru.Click
Call
HapusText()
nobk.Focus()
End Sub
Private Sub btnSimpan_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnSimpan.Click
SQL = "INSERT
INTO kendaraan(nobk, pemilik, alamat, tahun, warna, norangkamesin)"
& _
" VALUES ('" & nobk.Text & "','" & _
pemilik.Text & "','"
& _
alamat.Text & "','" & _
tahun.Text & "','"
& _
warna.Text & "','"
& _
norangkamesin.Text & "')"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnHapus_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnHapus.Click
SQL = "DELETE
FROM kendaraan Where nobk='" & nobk.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnKeluar_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnKeluar.Click
Me.Close()
End Sub
Private Sub nobk_KeyPress(ByVal
sender As Object,
ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles
nobk.KeyPress
Dim
tombol As Integer
= Asc(e.KeyChar)
Dim
xkode As String
If tombol = 13 Then
SQL = "select
* from kendaraan where nobk='" & nobk.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
DR = CMD.ExecuteReader
DR.Read()
If
DR.HasRows = True Then
pemilik.Text = DR.Item(1)
alamat.Text = DR.Item(2)
tahun.Text = DR.Item(3)
warna.Text = DR.Item(4)
norangkamesin.Text = DR.Item(5)
Call
ButtonEdit()
MsgBox("data
ditemukan !")
Else
xkode = nobk.Text
Call
HapusText()
nobk.Text = xkode
Call
ButtonSimpan()
End
If
pemilik.Focus()
End If
End Sub
Private Sub btnBatal_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBatal.Click
Call
HapusText()
nobk.Focus()
End Sub
Private Sub btnEdit_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs)
Handles btnEdit.Click
SQL = "UPDATE
kendaraan SET pemilik='" & pemilik.Text & "' " & _
",alamat='" & alamat.Text & "' " & _
",tahun='" & tahun.Text & "' " & _
",warna='" & warna.Text & "' " & _
",norangkamesin='" &
norangkamesin.Text & "' "
& _
"Where nobk='" & nobk.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
End Class
Listening program Form Produk
Imports
System.Data.OleDb
Public Class Formproduk
Public DB As OleDbConnection
Public CMD As OleDbCommand
Public ADP As OleDbDataAdapter
Public DS As New DataSet
Dim SQL As String
Public DR As OleDbDataReader
Public Sub OpenDB()
Dim
LOKASI = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source = C:\VB2\produk.mdb"
DB = New
OleDbConnection(LOKASI)
If
DB.State = ConnectionState.Closed Then
DB.Open()
End If
End Sub
Sub
ButtonBaru()
btnbaru.Enabled = True
btnSimpan.Enabled = False
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub
ButtonEdit()
btnbaru.Enabled = False
btnSimpan.Enabled = False
btnEdit.Enabled = True
btnHapus.Enabled = True
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
ButtonSimpan()
btnbaru.Enabled = False
btnSimpan.Enabled = True
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
HapusText()
kode.Text = ""
nama.Text = ""
satuan.Text = ""
harga.Text = ""
jumlah.Text = ""
Call
ButtonBaru()
End Sub
Sub
TampilKaryawan()
ADP = New
OleDbDataAdapter("SELECT * FROM produk",
DB)
DS = New
DataSet
ADP.Fill(DS, "produk")
End Sub
Private Sub Formproduk_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Call
OpenDB()
Call
HapusText()
End Sub
Private Sub btnBaru_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBaru.Click
Call
HapusText()
kode.Focus()
End Sub
Private Sub btnSimpan_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnSimpan.Click
SQL = "INSERT
INTO produk(kodeproduk, namaproduk, satuan, harga, jumlah)" & _
" VALUES ('" & kode.Text & "','" & _
nama.Text & "','" &
_
satuan.Text & "','"
& _
harga.Text & "','"
& _
jumlah.Text & "')"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnHapus_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnHapus.Click
SQL = "DELETE
FROM produk Where kodeproduk='" & kode.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnKeluar_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnKeluar.Click
Me.Close()
End Sub
Private Sub kode_KeyPress(ByVal
sender As Object,
ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles
kode.KeyPress
Dim
tombol As Integer
= Asc(e.KeyChar)
Dim
xkode As String
If
tombol = 13 Then
SQL = "select
* from produk where kodeproduk='" & kode.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
DR = CMD.ExecuteReader
DR.Read()
If
DR.HasRows = True Then
nama.Text = DR.Item(1)
satuan.Text = DR.Item(2)
harga.Text = DR.Item(3)
jumlah.Text = DR.Item(4)
Call
ButtonEdit()
MsgBox("data
ditemukan !")
Else
xkode = kode.Text
Call
HapusText()
kode.Text = xkode
Call
ButtonSimpan()
End
If
nama.Focus()
End If
End Sub
Private Sub btnBatal_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBatal.Click
Call
HapusText()
kode.Focus()
End Sub
Private Sub btnEdit_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnEdit.Click
SQL = "UPDATE
produk SET nama='" & nama.Text & "'
" & _
",satuan='" & satuan.Text & "' " & _
",harga='" & harga.Text & "' " & _
",jumlah='" & jumlah.Text & "' " & _
"Where kode='" & kode.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
End Class
Listening program Form Siswa
Imports
System.Data.OleDb
Public Class Formsiswa
Public DB As OleDbConnection
Public CMD As OleDbCommand
Public ADP As OleDbDataAdapter
Public DS As New DataSet
Dim SQL As String
Public DR As OleDbDataReader
Public Sub OpenDB()
Dim
LOKASI = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source = C:\VB2\produk.mdb"
DB = New
OleDbConnection(LOKASI)
If
DB.State = ConnectionState.Closed Then
DB.Open()
End If
End Sub
Sub
ButtonBaru()
btnbaru.Enabled = True
btnSimpan.Enabled = False
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = False
btnkeluar.Enabled = True
End Sub
Sub
ButtonEdit()
btnbaru.Enabled = False
btnSimpan.Enabled = False
btnEdit.Enabled = True
btnHapus.Enabled = True
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
ButtonSimpan()
btnbaru.Enabled = False
btnSimpan.Enabled = True
btnEdit.Enabled = False
btnHapus.Enabled = False
btnBatal.Enabled = True
btnkeluar.Enabled = False
End Sub
Sub
HapusText()
NIS.Text = ""
namasiswa.Text = ""
alamat.Text = ""
namawali.Text = ""
tanggallahir.Text = ""
agama.Text = ""
jeniskelamin.Text = ""
Call
ButtonBaru()
End Sub
Sub
TampilKaryawan()
ADP = New
OleDbDataAdapter("SELECT * FROM siswa",
DB)
DS = New
DataSet
ADP.Fill(DS, "siswa")
End Sub
Private Sub Form1_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Call
OpenDB()
Call
HapusText()
End Sub
Private Sub btnBaru_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBaru.Click
Call
HapusText()
NIS.Focus()
End Sub
Private Sub btnSimpan_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnSimpan.Click
SQL = "INSERT
INTO siswa(NIS, namasiswa, alamat, namawali, tanggallahir, agama,
jeniskelamin)" & _
" VALUES ('" & NIS.Text & "','" & _
namasiswa.Text & "','"
& _
alamat.Text & "','" & _
namawali.Text & "','"
& _
tanggallahir.Text & "','"
& _
agama.Text & "','"
& _
jeniskelamin.Text & "')"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnHapus_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnHapus.Click
SQL = "DELETE
FROM produk Where NIS='" & NIS.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
Private Sub btnKeluar_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnKeluar.Click
Me.Close()
End Sub
Private Sub NIS_KeyPress(ByVal
sender As Object,
ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles
NIS.KeyPress
Dim
tombol As Integer
= Asc(e.KeyChar)
Dim
xkode As String
If
tombol = 13 Then
SQL = "select
* from siswa where NIS='" & NIS.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
DR = CMD.ExecuteReader
DR.Read()
If
DR.HasRows = True Then
namasiswa.Text = DR.Item(1)
alamat.Text = DR.Item(2)
namawali.Text = DR.Item(3)
tanggallahir.Text = DR.Item(4)
agama.Text = DR.Item(5)
jeniskelamin.Text = DR.Item(6)
Call
ButtonEdit()
MsgBox("data
ditemukan !")
Else
xkode = NIS.Text
Call
HapusText()
NIS.Text = xkode
Call
ButtonSimpan()
End
If
namasiswa.Focus()
End If
End Sub
Private Sub btnBatal_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnBatal.Click
Call
HapusText()
NIS.Focus()
End Sub
Private Sub btnEdit_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles btnEdit.Click
SQL = "UPDATE
siswa SET namasiswa='" & namasiswa.Text & "' " & _
",alamat='"
& alamat.Text & "' " &
_
",namawali='" & namawali.Text & "' " & _
",tanggallahir='" &
tanggallahir.Text & "' " &
_
",agama='" & agama.Text & "' " & _
",jeniskelamin='" &
jeniskelamin.Text & "' " &
_
"Where NIS='" & NIS.Text & "'"
CMD = New
OleDbCommand(SQL, DB)
CMD.ExecuteNonQuery()
Call
btnBaru_Click(sender, e)
End Sub
End Class