Lampiran TA visual basic

7/21/2019 Lampiran TA visual basic

1/25

Lampiran Laporan

1.

Screenshot Programa.

Tampilan Awal

b.

MDIParents

c.

Menu Login


2/25

d.

Edit Data

e.

Daftar Makanan

f.

Data Pekerjaan


3/25

g.

Searching Data

h.

Laporan

i.

Percetakan


4/25

j.

Crystal Report

k.

About


5/25

l.

Help

m.

Menu admin


6/25

n.

Koneksi data

2.

Form Codinga.

Tampilan awalPublicNotInheritableClassForm1

PrivateSubSplashScreen_Load(ByValsender AsObject, ByVale AsSystem.EventArgs) HandlesMe.Load

Timer1.Start() 'memulai pewaktu (timer1)EndSubPrivateSubTimer1_Tick(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesTimer1.TickIfProgressBar1.Value < 100 Then'nilai maksimal timer 100'

ProgressBar1.Value += 2 'kenaikan waktu timer 2'ElseIfProgressBar1.Value = 100 Then'ketika timer telah mencapai

100Timer1.Stop() 'timer berhenti

MDIParent1.Show()Me.Hide()EndIf

EndSubEndClass

b.

MDIParentsImportsSystem.Windows.Forms

PublicClassMDIParent1


7/25

PrivateSubShowNewForm(ByValsender AsObject, ByVale AsEventArgs)HandlesNewWindowToolStripMenuItem.Click

' Create a new instance of the child form.DimChildForm AsNewSystem.Windows.Forms.Form' Make it a child of this MDI form before showing it.ChildForm.MdiParent = Me

m_ChildFormNumber += 1ChildForm.Text = "Window "& m_ChildFormNumber

ChildForm.Show()EndSub

PrivateSubOpenFile(ByValsender AsObject, ByVale AsEventArgs)DimOpenFileDialog AsNewOpenFileDialogOpenFileDialog.InitialDirectory =

My.Computer.FileSystem.SpecialDirectories.MyDocumentsOpenFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files

(*.*)|*.*"If(OpenFileDialog.ShowDialog(Me) =

System.Windows.Forms.DialogResult.OK) ThenDimFileName AsString= OpenFileDialog.FileName' TODO: Add code here to open the file.

EndIfEndSub

PrivateSubSaveAsToolStripMenuItem_Click(ByValsender AsObject, ByVale AsEventArgs)

DimSaveFileDialog AsNewSaveFileDialogSaveFileDialog.InitialDirectory =

My.Computer.FileSystem.SpecialDirectories.MyDocumentsSaveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files

(*.*)|*.*"

If(SaveFileDialog.ShowDialog(Me) =System.Windows.Forms.DialogResult.OK) Then

DimFileName AsString= SaveFileDialog.FileName' TODO: Add code here to save the current contents of the form

to a file.EndIf

EndSub

PrivateSubExitToolsStripMenuItem_Click(ByValsender AsObject, ByValeAsEventArgs)

Me.Close()EndSub

PrivateSubCutToolStripMenuItem_Click(ByValsender AsObject, ByVale

AsEventArgs)' Use My.Computer.Clipboard to insert the selected text or images

into the clipboardEndSub

PrivateSubCopyToolStripMenuItem_Click(ByValsender AsObject, ByValeAsEventArgs)

' Use My.Computer.Clipboard to insert the selected text or imagesinto the clipboard

EndSub

PrivateSubPasteToolStripMenuItem_Click(ByValsender AsObject, ByValeAsEventArgs)


8/25

'Use My.Computer.Clipboard.GetText() orMy.Computer.Clipboard.GetData to retrieve information from the clipboard.

EndSub

PrivateSubToolBarToolStripMenuItem_Click(ByValsender AsObject, ByVale AsEventArgs)

EndSub

PrivateSubStatusBarToolStripMenuItem_Click(ByValsender AsObject,ByVale AsEventArgs)

EndSub

PrivateSubCascadeToolStripMenuItem_Click(ByValsender AsObject, ByVale AsEventArgs) HandlesCascadeToolStripMenuItem.Click

Me.LayoutMdi(MdiLayout.Cascade)EndSub

PrivateSubTileVerticalToolStripMenuItem_Click(ByValsender AsObject,

ByVale AsEventArgs) HandlesTileVerticalToolStripMenuItem.ClickMe.LayoutMdi(MdiLayout.TileVertical)EndSub

PrivateSubTileHorizontalToolStripMenuItem_Click(ByValsender AsObject, ByVale AsEventArgs) HandlesTileHorizontalToolStripMenuItem.Click

Me.LayoutMdi(MdiLayout.TileHorizontal)EndSub

PrivateSubArrangeIconsToolStripMenuItem_Click(ByValsender AsObject,ByVale AsEventArgs) HandlesArrangeIconsToolStripMenuItem.Click

Me.LayoutMdi(MdiLayout.ArrangeIcons)EndSub

PrivateSubCloseAllToolStripMenuItem_Click(ByValsender AsObject,ByVale AsEventArgs) HandlesCloseAllToolStripMenuItem.Click

' Close all child forms of the parent.ForEachChildForm AsFormInMe.MdiChildren

ChildForm.Close()Next

EndSub

Privatem_ChildFormNumber AsInteger

PrivateSubLOGINToolStripMenuItem_Click(ByValsender AsSystem.Object,ByVale AsSystem.EventArgs) HandlesLOGINToolStripMenuItem.Click

DimMDIChild AsNewLOGINMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubDataMahasiswaToolStripMenuItem_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesDataMahasiswaToolStripMenuItem.Click

DimMDIChild AsNewMASTERDATAMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubDataPekerjaanToolStripMenuItem_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesDataPekerjaanToolStripMenuItem.Click


9/25

DimMDIChild AsNewMASTERPEKERJAANMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubEXITToolStripMenuItem_Click(ByValsender AsSystem.Object,

ByVale AsSystem.EventArgs) HandlesEXITToolStripMenuItem.ClickEnd

EndSub

PrivateSubAboutToolStripMenuItem_Click(ByValsender AsSystem.Object,ByVale AsSystem.EventArgs) HandlesAboutToolStripMenuItem.Click

DimMDIChild AsNewAboutBox1MDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubSearchingToolStripMenuItem_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesSearchingToolStripMenuItem.Click

DimMDIChild AsNewSearchingMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubLaporanToolStripMenuItem_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesLaporanToolStripMenuItem.Click

DimMDIChild AsNewLaporanMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubHelpToolStripMenuItem_Click(ByValsender AsSystem.Object,ByVale AsSystem.EventArgs) HandlesHelpToolStripMenuItem.Click

DimMDIChild AsNewHELPMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubPercetakanToolStripMenuItem_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesPercetakanToolStripMenuItem.Click

DimMDIChild AsNewpercetakanMDIChild.MdiParent = MeMDIChild.Show()

EndSub

PrivateSubCrystalReportToolStripMenuItem_Click(ByValsender As

System.Object, ByVale AsSystem.EventArgs) HandlesCrystalReportToolStripMenuItem.Click

DimMDIChild AsNewcrystalMDIChild.MdiParent = MeMDIChild.Show()

EndSubEndClass

c.

LoginImportsSystem.Data.OleDbPublicClassLOGIN


10/25

PrivateSubButton1_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesButton1.Click

Dimcon AsNewOleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source = "&System.Environment.CurrentDirectory & "\Alumni.mdb")

Dimcmd AsOleDbCommand= NewOleDbCommand("SELECT * FROM LOGIN

WHERE USERNAME = '"& TextBox1.Text & "' AND PASS = '"& TextBox2.Text & "'", con)

con.Open()Dima AsOleDbDataReader= cmd.ExecuteReader()If(a.Read() = True) Then

Me.Hide()DimMDIChild AsNewDATAMDIChild.MdiParent = MDIParent1MDIChild.Show()

ElseMessageBox.Show("Invalid username or password!", "Warning",

MessageBoxButtons.OK, MessageBoxIcon.Warning)DATA.Hide()

EndIf

EndSubPrivateSubButton2_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesButton2.Click

TextBox1.Clear()TextBox2.Clear()

EndSubEndClass

d.

Data (Manipulasi data)Option Strict OffImportsSystem.DataImportsSystem.Data.OleDbPublicClassDATA

Dimdb AsNewDataTable

DimDBvb AsStringPrivatekoneksi AsNewOleDbConnectionPrivateKelompokData AsOleDbDataAdapterPrivateSubInfinity()

db.Clear()DimInfinity AsNewOleDbDataAdapter(" SELECT *FROM DATA", koneksi)Infinity.Fill(db)Me.DataGridView1.DataSource = dbkoneksi.Close()

EndSubPrivateSubIsiData(ByValSQL AsString)

db.Clear()KelompokData = NewOleDbDataAdapter(SQL, koneksi)KelompokData.Fill(db, "DATA")

Me.DataGridView1.DataSource = dbMe.DataGridView1.DataMember = "DATA"EndSubSubKosongkan()

TextBox1.Text = ""TextBox2.Text = ""TextBox3.Text = ""TextBox4.Text = ""TextBox5.Text = ""TextBox6.Text = ""TextBox7.Text = ""TextBox8.Text = ""TextBox9.Text = ""TextBox10.Text = ""


11/25

TextBox11.Text = ""

EndSub

PrivateSubForm6_Load(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesMyBase.LoadDimkoneksiStr AsString= "provider=Microsoft.Jet.OLEDB.4.0;Data

Source = "& System.Environment.CurrentDirectory & "\Alumni.mdb"Try

koneksi = NewOleDbConnection(koneksiStr)koneksi.Open()Me.Text = "Data Mahasiswa"Button4.Enabled = FalseGroupBox1.Enabled = False

Catchex AsExceptionMe.Text = "Disconnected"MessageBox.Show(ex.Message.ToString, "Disconnected")

EndTryInfinity()

Kosongkan()

EndSubPrivateSubDataGridView1_CellContentClick(ByValsender As

System.Object, ByVale AsSystem.Windows.Forms.DataGridViewCellEventArgs)HandlesDataGridView1.CellContentClick

TryDimNIM AsString=

Me.DataGridView1.CurrentRow.Cells("NIM").ValueDimNAMA AsString=

Me.DataGridView1.CurrentRow.Cells("NAMA").ValueDimJK AsString=

Me.DataGridView1.CurrentRow.Cells("JENIS_KELAMIN").ValueDimALAMAT AsString=

Me.DataGridView1.CurrentRow.Cells("ALAMAT").ValueDimMT AsString=

Me.DataGridView1.CurrentRow.Cells("MASUK_TAHUN").ValueDimLT AsString=

Me.DataGridView1.CurrentRow.Cells("LULUS_TAHUN").ValueDimJENJANG AsString=

Me.DataGridView1.CurrentRow.Cells("JENJANG").ValueDimPRODI AsString=

Me.DataGridView1.CurrentRow.Cells("PRODI").ValueDimPEKERJAAN AsString=

Me.DataGridView1.CurrentRow.Cells("PEKERJAAN").ValueDimEMAIL AsString=

Me.DataGridView1.CurrentRow.Cells("EMAIL").ValueDimNOHP AsString=

Me.DataGridView1.CurrentRow.Cells("NO_HP").Value

TextBox1.Text = NIMTextBox2.Text = NAMATextBox3.Text = JKTextBox4.Text = ALAMATTextBox5.Text = MTTextBox6.Text = LTTextBox7.Text = JENJANGTextBox8.Text = PRODITextBox9.Text = PEKERJAANTextBox10.Text = EMAILTextBox11.Text = NOHPGroupBox1.Enabled = True


12/25

Catchex AsException

MsgBox(ex.Message)EndTry

EndSub


If(DBvb = "Tambah") ThenIfTextBox1.Text = ""Then

MsgBox("Masih ada yang Kosong, Silahkan cek lagi")koneksi.Close()Exit Sub

ElseIfTextBox2.Text = ""ThenMsgBox("Masih ada yang Kosong, Silahkan cek lagi")koneksi.Close()Exit Sub

ElseIfTextBox3.Text = ""ThenMsgBox("Masih ada yang Kosong, Silahkan cek lagi")koneksi.Close()

Exit SubElseIfTextBox4.Text = ""ThenMsgBox("Masih ada yang Kosong, Silahkan cek lagi")koneksi.Close()Exit Sub








Elsekoneksi.Open()Dimtambah AsNewOleDbCommand("INSERT INTO DATA(NIM,

NAMA,JENIS_KELAMIN, ALAMAT, MASUK_TAHUN, LULUS_TAHUN, JENJANG, PRODI,PEKERJAAN, EMAIL, NO_HP) VALUES ('"& TextBox1.Text & "','"& TextBox2.Text& "','"& TextBox3.Text & "','"& TextBox4.Text & "','"& TextBox5.Text &"','"& TextBox6.Text & "','"& TextBox7.Text & "','"& TextBox8.Text &"','"& TextBox9.Text & "','"& TextBox10.Text & "','"& TextBox11.Text &"')", koneksi)


13/25

tambah.ExecuteNonQuery()Infinity()MsgBox("Data Telah Berhasil Ditambahkan")koneksi.Close() 'menutup koneksiKosongkan() 'memanggil prosedur kosong

EndIf

ElseIf(DBvb = "Ubah") ThenTry

IfTextBox1.TextLength = 0 ThenMsgBox("Silahkan Pilih Data yang akan diubah")

ElseIfTextBox2.Text = NothingOrTextBox3.TextLength = 0 OrTextBox4.TextLength = 0 OrTextBox5.Text = NothingOrTextBox6.Text =NothingOrTextBox7.Text = NothingOrTextBox8.Text = NothingOrTextBox9.Text = NothingOrTextBox10.Text = NothingOrTextBox11.Text =NothingThen

MsgBox("Masih ada yang Kosong, Silahkan cek lagi")Else

'membuka koneksikoneksi.Open()TextBox1.ReadOnly = True

'mendefinCorebeekan queryDimubah AsNewOleDbCommand("UPDATE DATA SET NAMA = '"& TextBox2.Text & "', JENIS_KELAMIN = '"& TextBox3.Text & "',ALAMAT = '"&TextBox4.Text & "',MASUK_TAHUN = '"& TextBox5.Text & "',LULUS_TAHUN = '"&TextBox6.Text & "',JENJANG = '"& TextBox7.Text & "',PRODI = '"&TextBox8.Text & "',PEKERJAAN = '"& TextBox9.Text & "',EMAIL = '"&TextBox10.Text & "',NO_HP = '"& TextBox11.Text & "'WHERE NIM = ('"&TextBox1.Text & "')", koneksi)

ubah.ExecuteNonQuery() 'eksekusi querykoneksi.Close() 'menutup koneksiInfinity()MsgBox("Data "& TextBox1.Text & " telah diubah")

EndIfKosongkan() 'memanggil prosedure kosong

Catchex AsException'pesan jika ditemukan kesalahanMsgBox(ex.Message)koneksi.Close() 'menutup koneksi

EndTry

ElseIf(DBvb = "Hapus") ThenTry

'jika kota belum dipilihIfTextBox1.Text = NothingThen

MsgBox("Data Belum Dipilih")Else

'membuka koneksi

koneksi.Open()'query penghapusan data berdasarkan kota yang dipilihDimhapus AsNewOleDbCommand("DELETE FROM DATA WHERE

NIM =('"& TextBox1.Text & "')", koneksi)hapus.ExecuteNonQuery() 'perintah eksekusi querykoneksi.Close() 'menutup koneksiInfinity()MsgBox("Data NIM "& TextBox1.Text & " telah dihapus")

EndIfKosongkan()

Catchex AsException'pesan jika ditemukan kesalahan


14/25

MsgBox(ex.Message)'menutup koneksikoneksi.Close()

EndTryEndIf

Button4.Enabled = FalseButton3.Enabled = TrueButton1.Enabled = TrueButton2.Enabled = TrueTextBox1.ReadOnly = FalseGroupBox1.Enabled = False

EndSub


Try'memberi nilai dan memanggil prosedure kosongDBvb = "Tambah"

Kosongkan()TextBox1.Focus()Button1.Enabled = FalseButton4.Enabled = TrueButton3.Enabled = FalseButton2.Enabled = FalseGroupBox1.Enabled = True

Catchex AsException'pesan jika ditemukan kesalahanMsgBox(ex.Message)

EndTryEndSub


Try'jika kota yang akan diubah belum dipilihIfTextBox1.TextLength = 0 Then

MsgBox("Silahkan Pilih Data Untuk Diubah")Else

TextBox1.ReadOnly = TrueDBvb = "Ubah"Button4.Enabled = TrueButton3.Enabled = FalseButton2.Enabled = FalseGroupBox1.Enabled = True

EndIfCatchex AsException

'pesan jika ditemukan kesalahan

MsgBox(ex.Message)EndTry

EndSub


Try'jika belum ada kota yang dipilihIfTextBox1.TextLength = 0 Then

MsgBox("Silahkan Pilih Data Untuk Dihapus")Else

TextBox1.ReadOnly = TrueDBvb = "Hapus"


15/25


16/25

PrivateSubButton7_Click_1(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesButton7.ClickDimMDIChild AsNewPEKERJAANMDIChild.MdiParent = MDIParent1MDIChild.Show()

EndSub

PrivateSubData_FormClosing(ByValsender AsObject, ByVale AsSystem.Windows.Forms.FormClosingEventArgs) HandlesMe.FormClosing

'Konfirmasi penutupan formIfMessageBox.Show("Anda akan melakukan LOGOUT?", "Warning",

MessageBoxButtons.YesNo, MessageBoxIcon.Warning) =Windows.Forms.DialogResult.No Then

e.Cancel = TrueEndIf

EndSub


Me.Hide()EndSubEndClass

e.

Pekerjaan (Manipulasi Pekerjaan)Option Strict OffImportsSystem.DataImportsSystem.Data.OleDbPublicClassPEKERJAAN

Dimdb AsNewDataTableDimDBvb AsStringPrivatekoneksi AsNewOleDbConnectionPrivateKelompokData AsOleDbDataAdapterPrivateSubInfinity()

db.Clear()DimInfinity AsNewOleDbDataAdapter(" SELECT *FROM PEKERJAAN",

koneksi)Infinity.Fill(db)Me.DataGridView1.DataSource = dbkoneksi.Close()

EndSubPrivateSubIsiData(ByValSQL AsString)

db.Clear()KelompokData = NewOleDbDataAdapter(SQL, koneksi)KelompokData.Fill(db, "PEKERJAAN")Me.DataGridView1.DataSource = dbMe.DataGridView1.DataMember = "PEKERJAAN"

EndSub

PrivateSubBersih()Me.TextBox1.Text = ""Me.TextBox2.Text = ""Me.TextBox3.Text = ""

EndSubPrivateSubisiTeks()

IfDataGridView1.CurrentRow.Index


17/25

Me.LabelUpdate.Text = Me.DataGridView1.Item(0,DataGridView1.CurrentRow.Index).Value

EndIfEndSub

PrivateSubPEKERJAAN_Load(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesMyBase.LoadDimkoneksiStr AsString= "provider=Microsoft.Jet.OLEDB.4.0;Data

Source = "& System.Environment.CurrentDirectory & "\Alumni.mdb"Try

koneksi = NewOleDbConnection(koneksiStr)koneksi.Open()Me.Text = "Pekerjaan"Button4.Enabled = FalseGroupBox1.Enabled = False

Catchex AsExceptionMe.Text = "Disconnected"MessageBox.Show(ex.Message.ToString, "Disconnected")

EndTryInfinity()

Bersih()EndSub

PrivateSubTextBox1_TextChanged(ByValsender AsSystem.Object, ByValeAsSystem.EventArgs) HandlesTextBox1.TextChanged

IfMe.TextBox1.Text ""AndMe.Button4.Enabled = FalseThenMe.Button6.Enabled = TrueMe.Button5.Enabled = True

ElseMe.Button6.Enabled = TrueMe.Button5.Enabled = True

EndIfEndSub


Try'memberi nilai dan memanggil prosedure kosongDBvb = "Tambah"Bersih()TextBox1.Focus()Button8.Enabled = FalseButton4.Enabled = TrueButton5.Enabled = FalseButton6.Enabled = FalseGroupBox1.Enabled = True

Catchex AsException'pesan jika ditemukan kesalahanMsgBox(ex.Message)

EndTry

EndSub


If(DBvb = "Tambah") ThenIfTextBox1.Text = ""Then

MsgBox("Masih ada yang Kosong, Silahkan cek lagi")koneksi.Close()Exit Sub

ElseIfTextBox2.Text = ""ThenMsgBox("Masih ada yang Kosong, Silahkan cek lagi")


18/25

koneksi.Close()Exit Sub


Elsekoneksi.Open()Dimtambah AsNewOleDbCommand("INSERT INTO

PEKERJAAN(TEMPAT_KERJA, STATUS_KERJA, ALAMAT_KERJA) VALUES ('"&TextBox1.Text & "','"& TextBox2.Text & "','"& TextBox3.Text & "')",koneksi)

tambah.ExecuteNonQuery()Infinity()MsgBox("Data Telah Berhasil Ditambahkan")koneksi.Close() 'menutup koneksiBersih() 'memanggil prosedur kosong

EndIfElseIf(DBvb = "Ubah") Then

Try

IfTextBox1.TextLength = 0 ThenMsgBox("Silahkan Pilih Data yang akan diubah")ElseIfTextBox1.Text = NothingOrTextBox2.TextLength = 0 Or

TextBox3.TextLength = 0 ThenMsgBox("Masih ada yang Kosong, Silahkan cek lagi")

Else'membuka koneksikoneksi.Open()TextBox1.ReadOnly = True'mendefinCorebeekan queryDimubah AsNewOleDbCommand("UPDATE PEKERJAAN SET

TEMPAT_KERJA = '"& TextBox1.Text & "', STATUS_KERJA = '"& TextBox2.Text &"', ALAMAT_KERJA = '"& TextBox3.Text & "'WHERE PEKERJAAN = ('"&TextBox1.Text & "')", koneksi)

ubah.ExecuteNonQuery() 'eksekusi querykoneksi.Close() 'menutup koneksiInfinity()MsgBox("Data "& TextBox1.Text & " telah diubah")

EndIfBersih() 'memanggil prosedure kosong

Catchex AsException'pesan jika ditemukan kesalahanMsgBox(ex.Message)koneksi.Close() 'menutup koneksi

EndTry

ElseIf(DBvb = "Hapus") Then

Try'jika kota belum dipilihIfTextBox1.Text = NothingThen

MsgBox("Data Belum Dipilih")Else

'membuka koneksikoneksi.Open()'query penghapusan data berdasarkan yang dipilihDimhapus AsNewOleDbCommand("DELETE FROM PEKERJAAN

WHERE NAMA =('"& TextBox1.Text & "')", koneksi)hapus.ExecuteNonQuery() 'perintah eksekusi querykoneksi.Close() 'menutup koneksiInfinity()


19/25

MsgBox("Pekerjaan "& TextBox1.Text & " telah dihapus")EndIfBersih()

Catchex AsException'pesan jika ditemukan kesalahan

MsgBox(ex.Message)'menutup koneksikoneksi.Close()

EndTryEndIfButton4.Enabled = FalseButton5.Enabled = TrueButton8.Enabled = TrueButton6.Enabled = TrueTextBox1.ReadOnly = FalseGroupBox1.Enabled = False

EndSub

PrivateSubButton6_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesButton6.ClickTry

'jika kota yang akan diubah belum dipilihIfTextBox1.TextLength = 0 Then

MsgBox("Silahkan Pilih Data Untuk Diubah")Else

TextBox1.ReadOnly = TrueDBvb = "Ubah"Button4.Enabled = TrueButton5.Enabled = FalseButton6.Enabled = FalseGroupBox1.Enabled = True


'pesan jika ditemukan kesalahanMsgBox(ex.Message)

EndTryEndSub


Try'jika belum ada kota yang dipilihIfTextBox1.TextLength = 0 Then

MsgBox("Silahkan Pilih Data Untuk Dihapus")Else

TextBox1.ReadOnly = TrueDBvb = "Hapus"

Button4.Enabled = TrueButton8.Enabled = FalseButton6.Enabled = FalseGroupBox1.Enabled = True


'pesan jika ditemukan kesalahanMsgBox(ex.Message)

EndTry

EndSub


20/25

PrivateSubDataGridView1_CellContentClick(ByValsender AsSystem.Object, ByVale AsSystem.Windows.Forms.DataGridViewCellEventArgs)HandlesDataGridView1.CellContentClick

TryDimTEMPAT_KERJA AsString=

Me.DataGridView1.CurrentRow.Cells("TEMPAT_KERJA").Value

DimSTATUS_KERJA AsString=Me.DataGridView1.CurrentRow.Cells("STATUS_KERJA").Value

DimALAMAT_KERJA AsString=Me.DataGridView1.CurrentRow.Cells("ALAMAT_KERJA").Value

TextBox1.Text = TEMPAT_KERJATextBox2.Text = STATUS_KERJATextBox3.Text = ALAMAT_KERJAGroupBox1.Enabled = True

Catchex AsExceptionMsgBox(ex.Message)

EndTryEndSub


Me.Hide()EndSub

EndClass

f.

SearchingOption Strict OffImportsSystem.DataImportsSystem.Data.OleDb

PublicClasssearchingDimdt AsNewDataTable

DimrecDt AsDataRow

PrivateSubsearching_Load(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesMyBase.Load

dt.Clear()Me.OleDbDataAdapter1.Fill(dt)

EndSub


TryDimcari = TextBox1.Text()DimPilih = ComboBox1.Text

Dimpencarian AsString'membuka koneksiMe.OleDbConnection1.Open()'mengambil data dengan kriteria kota atau negaraIf(Equals("NIM", Pilih)) Then

pencarian = "SELECT * FROM DATA WHERE NIM = ('"& cari &"')"

ElseIf(Equals("NAMA", Pilih)) Thenpencarian = "SELECT * FROM DATA WHERE NAMA = ('"& cari &

"')"'jika kriteria tidak ditentukan

ElseIf(Me.ComboBox1.Text = "Pilih") ThenMsgBox("Pilih Pencarian")

EndIf


21/25

Dimtampil AsNewOleDbDataAdapter(pencarian,Me.OleDbConnection1)

'menutup koneksiMe.OleDbConnection1.Close()'membersihkan data tabel dengan variabel tampildt.Clear()

tampil.Fill(dt)

DataGridView1.DataSource = dt'menentukan jumlah data yang ditemukanDimjum AsIntegerjum = dt.Rows.CountIf(jum


22/25

str += vbCrLf & "-------------------------------------------------------"& _

"--------------------------------------------------------"&vbCrLf

str += " DATA "&vbCrLf

str += "-------------------------------------------------------"& _

"--------------------------------------------------------"&vbCrLf

str += vbTab & " NIM : "& vbTab &rO.NIM & vbCrLf

str += vbTab & " NAMA : "& vbTab & rO.NAMA& vbCrLf

str += vbTab & " JENIS KELAMIN : "& vbTab &rO.JENIS_KELAMIN & vbCrLf

str += vbTab & " ALAMAT Rumah : "& vbTab & rO.ALAMAT &vbCrLf

str += vbTab & " JENJANG : "& rO.JENJANG &vbCrLf

str += vbTab & " PRODI : "& rO.PRODI &vbCrLfstr += vbTab & " EMAIL : "& vbTab &

rO.EMAIL & vbCrLfstr += vbTab & " NO HP : "& vbTab &

rO.NO_HP & vbCrLfstr += "----------------------------------------------------

---"& _"--------------------------------------------------------"&

vbCrLfNextrO

'Memasukkan string ke dalam RichTextBox1Me.RichTextBox1.Text = str

Catchex AsExceptionMessageBox.Show(ex.Message)

EndTry

EndSubEndClass

h.

LaporanPublicClassLaporan

DimdtOrd AsAlumniDataSet1.DATADataTable

PrivateSubLaporan_FormClosing(ByValsender AsObject, ByVale AsSystem.Windows.Forms.FormClosingEventArgs) HandlesMe.FormClosing

'Konfirmasi penutupan formIfMessageBox.Show("Yakin akan keluar?", "Warning",MessageBoxButtons.YesNo, MessageBoxIcon.Warning) =Windows.Forms.DialogResult.No Then

e.Cancel = TrueEndIf

EndSubPrivateSubForm2_Load(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesMyBase.LoaddtOrd = NewAlumniDataSet1.DATADataTableMe.taData.Fill(dtOrd)Me.ComboBox1.DataSource = dtOrdMe.ComboBox1.DisplayMember = "NIM"

EndSub


23/25

PrivateSubButton1_Click(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesButton1.ClickMe.RichTextBox1.Clear()Dimid AsString= "NIM ="& ComboBox1.TextDimds AsNewAlumniDataSet1

Me.taData.Fill(ds.DATA)DimrO AsAlumniDataSet1.DATARowDimstr AsStringstr = "printed on "& Now & vbCrLf & vbCrLfTry

ForEachrO Inds.DATA.Select(id)str += vbCrLf & "-------------------------------------------

------------"& _"--------------------------------------------------------"&

vbCrLfstr += " DATA "&

vbCrLfstr += "----------------------------------------------------

---"& _

"--------------------------------------------------------"&vbCrLfstr += vbTab & " NIM : "& vbTab &

rO.NIM & vbCrLfstr += vbTab & " NAMA : "& vbTab & rO.NAMA

& vbCrLfstr += vbTab & " JENIS KELAMIN : "& vbTab &

rO.JENIS_KELAMIN & vbCrLfstr += vbTab & " ALAMAT Rumah : "& vbTab & rO.ALAMAT &

vbCrLfstr += vbTab & " JENJANG : "& rO.JENJANG &

vbCrLfstr += vbTab & " PRODI : "& rO.PRODI &

vbCrLfstr += vbTab & " EMAIL : "& vbTab &

rO.EMAIL & vbCrLfstr += vbTab & " NO HP : "& vbTab &

rO.NO_HP & vbCrLfstr += "----------------------------------------------------

---"& _"--------------------------------------------------------"&

vbCrLfNextrO

'Memasukkan string ke dalam RichTextBox1Me.RichTextBox1.Text = str

Catchex AsExceptionMessageBox.Show(ex.Message)

EndTryEndSub


DimMDIChild AsNewpercetakanMDIChild.MdiParent = MDIParent1MDIChild.Show()Me.Hide()

EndSubEndClass

i.

Master pekerjaan


24/25

PublicClassMASTERPEKERJAANDimdt AsNewDataTablePrivateSubMASTERPEKERJAAN_Load(ByValsender AsSystem.Object, ByVale

AsSystem.EventArgs) HandlesMyBase.LoadMe.OleDbDataAdapter1.Fill(dt)Me.DataGridView1.DataSource = dt

EndSub


Me.Hide()MDIParent1.Show()

EndSubEndClass

j.

Master dataPublicClassMASTERDATA

Dimdt AsNewDataTable

PrivateSubMASTERDATA_Load(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesMyBase.LoadMe.OleDbDataAdapter1.Fill(dt)Me.DataGridView1.DataSource = dt

EndSub


Me.Hide()MDIParent1.Show()

EndSubEndClass

k.

HelpPublicClassHELP


Me.Hide()EndSub

EndClass

l.

CristalImportsCrystalDecisions.CrystalReports.EnginePublicClasscrystal

PrivateSubcrystal_Load(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesMyBase.Load

DimcryRpt AsNewReportDocumentcryRpt.Load("D:\Prak Visual Basic\Tugas Akhir -VB\TugasAkhir\CrystalReport1.rpt")

CrystalReportViewer1.ReportSource = cryRptCrystalReportViewer1.Refresh()

EndSubPrivateSubButton1_Click(ByValsender AsSystem.Object, ByVale As

System.EventArgs) HandlesButton1.ClickMe.Hide()

EndSubEndClass

m.

AboutPublicNotInheritableClassAboutBox1


25/25

PrivateSubAboutBox1_Load(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs) HandlesMyBase.Load

' Set the title of the form.DimApplicationTitle AsStringIfMy.Application.Info.Title ""Then

ApplicationTitle = My.Application.Info.Title

ElseApplicationTitle =

System.IO.Path.GetFileNameWithoutExtension(My.Application.Info.AssemblyName)EndIf

EndSub

PrivateSubOKButton_Click(ByValsender AsSystem.Object, ByVale AsSystem.EventArgs)

Me.Hide()EndSub

PrivateSubLogoPictureBox_Click(ByValsender AsSystem.Object, ByValeAsSystem.EventArgs)

EndSub

EndClass