makalah program aplikasi travel

PROGRAM APLIKASI TRAVELMakalah Visual Basic.Net 2005

Disusun Oleh : Nama : Sendy Suci Lestari Nim : 10260156 Kelas : III/C

AKADEMI MANAJEMEN INFORMATIKA DAN KOMPUTER HASS BANDUNG TAHUN AJARAN 2010/2011

Kata Pengantar

Puji dan syukur kami panjatkan kepada Allah SWT yang telah memberikan ridho dan rahmatnya sehingga makalah yang berjudul Program Aplikasi Travel ini dapat selesai dengan tepat waktu. Terima kasih kami ucapkan kepada dosen mata kuliah Visual Studio 2005 Ibu Sri Kuswayati yang telah memberikan bimbingan dan juga kepada seluruh pihak yang ikut membantu dalam penyusunan makalah ini. Sebagai masyarakat awam yang ingin mengetahui bagaimana mempelajari Microsoft Visual Studio 2005, sehingga saya membuat makalah ini agar pembaca mudah dan mengerti cara kerja sistem yang saya buat. Kami pun menyadari bahwa makalah ini masih jauh dari sempurna, maka dari itu kami mengharapkan para pembaca untuk memberikan saran dan kritik yang bersifat membangun agar kami dapat belajar lebih baik lagi sehingga makalah ini dapat tersaji menjadi ilmu yang berguna bagi siapapun yang membacanya.

Bandung, Januari 2012

Penyusun

2 Sendy Suci Lestari (10260156) | Makalah Program Aplikasi Travel

Daftar Isi

Kata Pengantar ............................................................................................................... 2 Daftar Isi ........................................................................................................................ 3 BAB I ............................................................................................................................ 5 PENDAHULUAN .......................................................................................................... 5 A. B. Latar Belakang.................................................................................................... 5 Tujuan ................................................................................................................ 5

BAB II ........................................................................................................................... 6 PERANCANGAN PROGRAM ...................................................................................... 6 A. 1) 2) 3) 4) B. 1) 2) C. 1. 2. 3. 4. 5. 6. 7. 8. D. 1. 2. Konsep Sistem Informasi .................................................................................... 6 Definisi Sistem Informasi ................................................................................ 6 Visual Basic 2005 ........................................................................................... 6 SQL Server 2005 ............................................................................................ 6 Microsoft Access ........................................................................................... 7 Rancangan Database ........................................................................................... 7 Struktur Tabel ................................................................................................. 7 Relationship Diagram...................................................................................... 9 Rancangan Interface ........................................................................................... 9 Splash Screen .................................................................................................. 9 Menu Utama ................................................................................................. 10 Log In ........................................................................................................... 10 Form Pegawai ............................................................................................... 11 Form Jabatan................................................................................................. 11 Form Paket ................................................................................................... 12 Form Transaksi ............................................................................................. 12 Form Member ............................................................................................... 13 Coding (Kode Program) .................................................................................... 13 Coding Form Splash Screen .......................................................................... 13 Coding Form Menu Utama ............................................................................ 14


3. 4. 5. 6. 7. 8.

Coding Form Log In ..................................................................................... 17 Coding Form Pegawai ................................................................................... 18 Coding Form Jabatan .................................................................................... 21 Coding Form Paket ....................................................................................... 24 Coding Form Transaksi ................................................................................. 26 Coding Form Member ................................................................................... 31

BAB III ........................................................................................................................ 34 PENUTUP ................................................................................................................... 34 A. B. Kesimpulan....................................................................................................... 34 Saran ................................................................................................................ 34

DAFTAR PUSTAKA................................................................................................... 35


BAB I PENDAHULUANA. Latar BelakangZaman sekarang ini kita sebagai masyarakat yang modern haus akan informasi karena zaman sekarang ini jika kita tidak mengikuti informasi yang terbaru kita akan menjadi orang yang tertinggal akan informasi, sehingga mulai sekarang kita harus mau mulai mencari informasi apapun itu. Setiap perusahaan sekarang ini memerlukan orang yang kompeten dalam berbagai aplikasi dalam computer sehingga kita perlu mempelajari semua aplikasi yang ada dan bisa membantu kita dalam dunia kerja nanti, dalam makalah Program Aplikasi Travel kita dapat sedikit mempelajari apa yang nama nya Microsoft Visual Studio 2005 itu dan mengenal juga sebagian data base yang telah ada.

B. TujuanSecara umum tujuan di buat makalah ini dalam Microsoft Visual Studio 2005 yang berjudul Program Aplikasi Travel agar dapat mempermudah dan membuat mengerti pembaca yang ingin belajar mengenai aplikasi ini.


BAB II PERANCANGAN PROGRAMA. Konsep Sistem Informasi1) Definisi Sistem Informasi Sistem informasi dapat didefinisikan sebagai suatu kumpulan data yang sudah diolah, terintegrasi dan saling melengkapi yang menghasilkan informasi yang mempunyai nilai atau berguna dalam pengambilan keputusan. Sistem informasi akuntansi pada aplikasi ini merupakan sistem informasi yang memproses data transaksi bisnis sehingga menghasilkan keluaran berupa informasi keuangan yang berguna bagi pemakainya. 2) Visual Basic 2005 Visual Basic 2005 (VB 2005) merupakan bahasa pemrograman berbasis GUI (Graphical User Interface) atau program yang memungkinkan pengguna berkomunikasi dengan komputer menggunakan gambar atau grafik. Visual Basic 2005 adalah salah satu bahasa pemrograman yang dibuat oleh microsoft corporation dan VB 2005 merupakan pengembangan dari Visual Basic 6.0 (VB6). Visual Basic 2005 merupakan bagian dari sebuah suite aplikasi pemrograman Visual Studio 2005. Visual Basic 2005 menggunakan .NET Framework 2.0. 3) SQL Server 2005 SQL Sever 2005 merupakan salah satu jenis database server yang

menggunakan SQL sebagai bahasa dasar untuk mengakses databasenya. SQl Server 2005 merupakan jenis RDBMS (Relational Database Management Sistem) yang diluncurkan oleh microsoft corporation bersamaan dengan Visual Studio 2005. SQl Server 2005 merupakan pengembangan dari SQL Server 2000. Bahasa yang digunakan oleh SQL Server 2005 adalah SQL (Structured Query Language). SQL adalah bahasa standar yang digunakan secara khusus untuk memanipulasi data, berkomunikasi dengan basisdata relasional.


4) Microsoft Access Microsoft Access adalah suatu program aplikasi basis data komputer relasional yang digunakan untuk merancang, membuat dan mengolah berbagai jenis data dengan kapasitas yang besar. Database adalah kumpulan tabel-tabel yang saling berelasi. Antar tabel yang satu dengan yang lain saling berelasi, sehingga sering disebut basis data relasional. Relasi antar tabel dihubungkan oleh suatu key, yaitu primary key dan foreign key.

B. Rancangan DatabaseNama Database Keterangan 1) Struktur Tabel Berikut adalah struktur tabel dbTravel: 1. Tabel PegawaiField Name *NIK Nama_Pegawai Alamat_Pegawai Telepon Id_Jabatan Data Type Text Text Text Text Text Size 10 30 30 15 10 Descriptions Nomor Induk Karyawan(PK) Nama Pegawai Alamat/Tempat tinggal Pegawai Telepon Pegawai Id Jabatan Pegawai

: dbTravel.mdb : * = Primary Key(PK)

2. Tabel MemberField Name *Id_Member Nama_Pelanggan Alamat TTL Pekerjaan Telepon Data Type Text Text Text Date/Time Text Text 20 15 Size 10 30 50 Descriptions Id Member Pelanggan (PK) Nama Pelanggan Alamat Pelanggan Tempat Tanggal Lahir Pelanggan Pekerjaan Pelanggan Nomor Telepon Pelanggan

3. Table PaketField Name *Id_Paket Nama_Paket Data Type Text Text Size 10 30 Descriptions Id Paket Pilihan(PK) Nama Paket


Min_Paket Harga_Umum Harga_Pelajar

Text Number Number

255 Decimal Decimal

Minimal banyak orang yang ngambil Paket Harga Umum Paket Harga Pelajar Paket

4. Tabel JabatanField Name *Id_Jabatan Nama_Jabatan Data Type Text Text Size 10 30 Descriptions Id Jabatan Pegawai(PK) Jabatan

5. Tabel TransaksiField Name *No_Transaksi Tgl_Transaksi Tgl_Pemesanan Banyak_Pesanan Total_Bayar Bayar Kembalian Id_Member Id_Paket Data Type Text Date/Time Date/Time Number Number Number Number Text Text Integer Decimal Decimal Decimal 10 10 Size 10 Descriptions No Transaksi(PK) Tanggal Transaksi Tanggal Berangkat Pemesanan Banyak nya pesanan Total Bayar Membayar Kembalian Id Member Pelanggan Id Paket Pilihan

6. Tabel Login/UserField Name *Kode Nama_User Password Data Type Text Text Text Size 10 20 20 Descriptions Kode User(PK) Nama Pengguna Untuk Login Password


2) Relationship Diagram Berikut ini adalah bentuk relationship diagram dari dbTravel:

C. Rancangan InterfaceBerikut ini adalah Rancangan interface dari Program Aplikasi Travel: 1. Splash Screen


2. Menu Utama

3. Log In


4. Form Pegawai

5. Form Jabatan


6. Form Paket

7. Form Transaksi


8. Form Member

D. Coding (Kode Program)Berikut ini merupakan coding dari setiap Form dalam Program Aplikasi Travel: 1. Coding Form Splash ScreenPublic NotInheritable Class SplashScreen1 'TODO: This form can easily be set as the splash screen for the application by going to the "Application" tab ' of the Project Designer ("Properties" under the "Project" menu). Private Sub SplashScreen1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End If End Sub Private Sub MainLayoutPanel_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles MainLayoutPanel.Paint Timer1.Start() End Sub Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick If ProgressBar1.Value < 100 Then ProgressBar1.Value += 4 ElseIf ProgressBar1.Value = 100 Then Timer1.Stop()


MDIParent1.Show() End If End Sub End Class

2. Coding Form Menu UtamaImports System.Windows.Forms Public Class MDIParent1 Private Sub ShowNewForm(ByVal sender As Object, ByVal e As EventArgs) ' Create a new instance of the child form. Dim ChildForm As New System.Windows.Forms.Form ' Make it a child of this MDI form before showing it. ChildForm.MdiParent = Me m_ChildFormNumber += 1 ChildForm.Text = "Window " & m_ChildFormNumber ChildForm.Show() End Sub Private Sub OpenFile(ByVal sender As Object, ByVal e As EventArgs) Dim OpenFileDialog As New OpenFileDialog OpenFileDialog.InitialDirectory = My.Computer.FileSystem.SpecialDirectories.MyDocuments OpenFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*" If (OpenFileDialog.ShowDialog(Me) = System.Windows.Forms.DialogResult.OK) Then Dim FileName As String = OpenFileDialog.FileName ' TODO: Add code here to open the file. End If End Sub Private Sub SaveAsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Dim SaveFileDialog As New SaveFileDialog SaveFileDialog.InitialDirectory = My.Computer.FileSystem.SpecialDirectories.MyDocuments SaveFileDialog.Filter = "Text Files (*.txt)|*.txt|All Files (*.*)|*.*" If (SaveFileDialog.ShowDialog(Me) = System.Windows.Forms.DialogResult.OK) Then Dim FileName As String = SaveFileDialog.FileName ' TODO: Add code here to save the current contents of the form to a file. End If End Sub

Private Sub ExitToolsStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Global.System.Windows.Forms.Application.Exit() End Sub Private Sub CutToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs)


' Use My.Computer.Clipboard to insert the selected text or images into the clipboard End Sub Private Sub CopyToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) ' Use My.Computer.Clipboard to insert the selected text or images into the clipboard End Sub Private Sub PasteToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) 'Use My.Computer.Clipboard.GetText() or My.Computer.Clipboard.GetData to retrieve information from the clipboard. End Sub Private Sub CascadeToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Me.LayoutMdi(MdiLayout.Cascade) End Sub Private Sub TileVerticleToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Me.LayoutMdi(MdiLayout.TileVertical) End Sub Private Sub TileHorizontalToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Me.LayoutMdi(MdiLayout.TileHorizontal) End Sub Private Sub ArrangeIconsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Me.LayoutMdi(MdiLayout.ArrangeIcons) End Sub Private Sub CloseAllToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) ' Close all child forms of the parent. For Each ChildForm As Form In Me.MdiChildren ChildForm.Close() Next End Sub Private m_ChildFormNumber As Integer = 0 Private Sub LogInToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LogInToolStripMenuItem.Click Dim form As New FormLogin() form.Show() End Sub Private Sub PegawaiToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PegawaiToolStripMenuItem.Click Dim form As New FmPegawai() form.Show() End Sub


Private Sub JabatanToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles JabatanToolStripMenuItem.Click Jabatan.Show() End Sub Private Sub MemberToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MemberToolStripMenuItem.Click Dim form As New FormPaket() form.Show() End Sub Private Sub PemesananToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PemesananToolStripMenuItem.Click Dim form As New FormTransaksi() form.Show() End Sub Private Sub MemberToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MemberToolStripMenuItem1.Click Dim form As New FormMember() form.Show() End Sub Private Sub ExitToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem1.Click End End Sub Private Sub ExitToolStripMenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem2.Click End End Sub Private Sub ReportDataPegawaiToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReportDataPegawaiToolStripMenuItem.Click Dim form As New RepDataPegawai() form.Show() End Sub Private Sub StatusStrip_ItemClicked(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles StatusStrip.ItemClicked End Sub Private Sub ReportTransaskiToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReportTransaskiToolStripMenuItem.Click FrCRtransaksi.Show() End Sub Private Sub ExitToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExitToolStripMenuItem.Click MasterToolStripMenuItem.Enabled = False TransaksiToolStripMenuItem.Enabled = False


ReportToolStripMenuItem.Enabled = False LogInToolStripMenuItem.Enabled = True LogOutToolStripMenuItem.Enabled = False ReportToolStripMenuItem.Enabled = False End Sub End Class

3. Coding Form Log InPublic Class FormLogin Dim KNS As New OleDb.OleDbConnection Dim DA As New OleDb.OleDbDataAdapter Dim DT, DT2 As New DataTable Dim SQL, SQL2 As String Private Sub FormLogin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load PictureBox1.Enabled = True KNS.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb" End Sub Sub cari() DT.Clear() SQL = "SELECT * FROM User WHERE Kode='" & txtKode.Text & "'" DA.SelectCommand = New OleDb.OleDbCommand(SQL, KNS) DA.Fill(DT) End Sub Sub cari1() DT2.Clear() SQL2 = "SELECT * FROM User WHERE Nama_User='" & txtUser.Text & "'" DA.SelectCommand = New OleDb.OleDbCommand(SQL, KNS) DA.Fill(DT2) End Sub Sub cari2() DT2.Clear() SQL2 = "SELECT * FROM User WHERE Password='" & txtPassword.Text & "'" DA.SelectCommand = New OleDb.OleDbCommand(SQL, KNS) DA.Fill(DT2) End Sub Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click On Error Resume Next cari() cari1() cari2() If DT.Rows.Count 0 And txtPassword.Text = DT2.Rows(0)(1) Then If DT2.Rows.Count 1 Then


MessageBox.Show("ANDA BERHASIL LOGIN", "INFORMASI", MessageBoxButtons.OK, MessageBoxIcon.Information) MDIParent1.MasterToolStripMenuItem.Enabled = True MDIParent1.TransaksiToolStripMenuItem.Enabled = True MDIParent1.ReportToolStripMenuItem.Enabled = True MDIParent1.LogInToolStripMenuItem.Enabled = False MDIParent1.LogOutToolStripMenuItem.Enabled = True MDIParent1.ReportToolStripMenuItem.Enabled = True Me.Close() Else MessageBox.Show("user atau password salah!!", "INFORMASI", MessageBoxButtons.OK, MessageBoxIcon.Information) txtUser.Clear() txtPassword.Clear() txtUser.Focus() End If Else MessageBox.Show("GAGAL LOGIN", "INFORMASI", MessageBoxButtons.OK, MessageBoxIcon.Information) txtUser.Focus() End If End Sub Private Sub btnCancle_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancle.Click txtUser.Text = "" txtPassword.Text = "" txtUser.Focus() End Sub Private Sub btClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btClose.Click Me.Close() End Sub End Class

4. Coding Form PegawaiPublic Class FmPegawai Dim daJabatan As OleDb.OleDbDataAdapter Dim daPegawai As OleDb.OleDbDataAdapter Dim con As New OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb")) Dim dtJabatan As New DataTable() Dim dtPegawai As New DataTable() Dim drPegawai As DataRow Dim drJabatan As DataRow 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 FmPegawai_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DbTravelDataSet5.Pegawai' table. You can move, or remove it, as needed. Me.PegawaiTableAdapter1.Fill(Me.DbTravelDataSet5.Pegawai) Dim dc(1) As DataColumn Try daJabatan = New OleDb.OleDbDataAdapter("select * from Jabatan", con) daJabatan.Fill(dtJabatan) dc(0) = dtJabatan.Columns("Id_Jabatan") dtJabatan.PrimaryKey = dc With lstId_Jabatan .DataSource = dtJabatan .DisplayMember = "Id_Jabatan" .ValueMember = "Id_Jabatan" End With daPegawai = New OleDb.OleDbDataAdapter("select * from Pegawai", con) daPegawai.Fill(dtPegawai) dc(0) = dtPegawai.Columns("NIK") dtPegawai.PrimaryKey = dc dgPegawai.DataSource = dtPegawai Catch errConn As OleDb.OleDbException MsgBox(errConn.Message) End Try End Sub Private Sub kosong() txtNIK.Text = "" txtNama.Text = "" txtAlamat.Text = "" txtTelepon.Text = "" txtJabatan.Text = "" txtNIK.Focus() End Sub Private Sub btClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btClear.Click kosong() End Sub Private Sub btTambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btTambah.Click Try Dim cbTambah As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daPegawai) drPegawai = dtPegawai.NewRow


drPegawai("NIK") = txtNIK.Text drPegawai("Nama_Pegawai") = txtNama.Text drPegawai("Alamat_Pegawai") = txtAlamat.Text drPegawai("Telepon") = txtTelepon.Text drPegawai("Id_Jabatan") = lstId_Jabatan.Text dtPegawai.Rows.Add(drPegawai) con.Open() daPegawai.Update(dtPegawai) dtPegawai.AcceptChanges() con.Close() Catch errTambah As Exception MsgBox(errTambah.Message) End Try kosong() End Sub Private Sub btCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btCari.Click Try drPegawai = dtPegawai.Rows.Find(txtNIK.Text) txtNIK.Text = drPegawai("NIK").ToString txtNama.Text = drPegawai("Nama_Pegawai").ToString txtAlamat.Text = drPegawai("Alamat_Pegawai").ToString txtTelepon.Text = drPegawai("Telepon").ToString lstId_Jabatan.Text = drPegawai("Id_Jabatan").ToString Catch errCari As Exception MsgBox(errCari.Message) End Try End Sub Private Sub btHapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHapus.Click Try Dim cbhapus As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daPegawai) drPegawai.Delete() daPegawai.DeleteCommand = cbhapus.GetDeleteCommand daPegawai.Update(dtPegawai) dtPegawai.AcceptChanges() daPegawai.DeleteCommand.Connection.Close() Catch errHapus As Exception MsgBox(errHapus.Message)


End Try kosong() End Sub Private Sub btSelesai_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btSelesai.Click Close() End Sub Private Sub lstId_Pegawai_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstId_Jabatan.SelectedIndexChanged Try Dim drDatKul As DataRow drDatKul = dtJabatan.Rows.Find(lstId_Jabatan.Text) txtJabatan.Text = drDatKul("Nama_Jabatan").ToString Catch errTampil As Exception

End Try End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try drPegawai = dtPegawai.Rows.Find(txtNIK.Text) If (txtNIK.Text = drPegawai("NIK")) Then MsgBox("Nik Pegawai Sudah Ada") txtNIK.Text = "" txtNIK.Focus() Exit Sub End If Catch errCari As Exception MsgBox(errCari.Message) End Try txtNama.Focus() End Sub End Class

5. Coding Form JabatanPublic Class Jabatan Dim daJab As OleDb.OleDbDataAdapter Dim con As New OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb")) Dim dtJab As New DataTable() Dim drJab As DataRow 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 Jabatan_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DbTravelDataSet4.Jabatan' table. You can move, or remove it, as needed. Me.JabatanTableAdapter.Fill(Me.DbTravelDataSet4.Jabatan) Dim dc(1) As DataColumn Try 'daDatKul = New OleDb.OleDbDataAdapter("select * from Jabatan", con) daJab = New OleDb.OleDbDataAdapter("select * from Jabatan", con) daJab.Fill(dtJab) dc(0) = dtJab.Columns("Id_Jabatan") dtJab.PrimaryKey = dc dgJabatan.DataSource = dtJab Catch errConn As OleDb.OleDbException MsgBox(errConn.Message) End Try End Sub Private Sub kosong() txtId_Jabatan.Text = "" txtJabatan.Text = "" txtId_Jabatan.Focus() End Sub Private Sub btTambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btTambah.Click Try Dim cbTambah As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daJab) drJab = dtJab.NewRow

drJab("Id_Jabatan") = txtId_Jabatan.Text drJab("Nama_Jabatan") = txtJabatan.Text dtJab.Rows.Add(drJab) con.Open() daJab.Update(dtJab) dtJab.AcceptChanges() con.Close() Catch errTambah As Exception MsgBox(errTambah.Message) End Try kosong()


End Sub Private Sub btCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btCari.Click Try drJab = dtJab.Rows.Find(txtId_Jabatan.Text) txtId_Jabatan.Text = drJab("Id_Jabatan").ToString txtJabatan.Text = drJab("Nama_Jabatan").ToString

Catch errCari As Exception MsgBox(errCari.Message) End Try End Sub Private Sub btHapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHapus.Click Try Dim cbhapus As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daJab) drJab.Delete() daJab.DeleteCommand = cbhapus.GetDeleteCommand daJab.Update(dtJab) dtJab.AcceptChanges() daJab.DeleteCommand.Connection.Close() Catch errHapus As Exception MsgBox(errHapus.Message) End Try kosong() End Sub Private Sub btSelesai_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btSelesai.Click Close() End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try drJab = dtJab.Rows.Find(txtId_Jabatan.Text) If (txtId_Jabatan.Text = drJab("NIK")) Then MsgBox("Nik Pegawai Sudah Ada") txtId_Jabatan.Text = "" txtId_Jabatan.Focus() Exit Sub End If


Catch errCari As Exception MsgBox(errCari.Message) End Try txtJabatan.Focus() End Sub End Class

6. Coding Form PaketPublic Class FormPaket Dim daPaket As OleDb.OleDbDataAdapter Dim con As New OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb")) Dim dtPaket As New DataTable() Dim drPaket As DataRow 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 btTambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btTambah.Click Try Dim cbTambah As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daPaket) drPaket = dtPaket.NewRow

drPaket("Id_Paket") = txtId_Paket.Text drPaket("Nama_Paket") = txtNama.Text drPaket("Min_Paket") = txtMin.Text drPaket("Harga_Umum") = txtHargaUmum.Text drPaket("Harga_Pelajar") = txtHargaelajar.Text dtPaket.Rows.Add(drPaket) con.Open() daPaket.Update(dtPaket) dtPaket.AcceptChanges() con.Close() Catch errTambah As Exception MsgBox(errTambah.Message) End Try kosong() End Sub Private Sub FormPaket_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)


Handles MyBase.Load 'TODO: This line of code loads data into the 'DbTravelDataSet.Member' table. You can move, or remove it, as needed. Me.MemberTableAdapter.Fill(Me.DbTravelDataSet.Member) Dim dc(1) As DataColumn Try 'daDatKul = New OleDb.OleDbDataAdapter("select * from Paket", con) daPaket = New OleDb.OleDbDataAdapter("select * from Paket", con) daPaket.Fill(dtPaket) dc(0) = dtPaket.Columns("Id_Paket") dtPaket.PrimaryKey = dc dgPaket.DataSource = dtPaket Catch errConn As OleDb.OleDbException MsgBox(errConn.Message) End Try End Sub Private Sub kosong() txtId_Paket.Text = "" txtNama.Text = "" txtMin.Text = "" txtHargaUmum.Text = "" txtHargaelajar.Text = "" txtId_Paket.Focus() End Sub Private Sub btClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btClear.Click kosong() End Sub Private Sub btCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btCari.Click Try drPaket = dtPaket.Rows.Find(txtId_Paket.Text) txtId_Paket.Text = drPaket("Id_Paket").ToString txtNama.Text = drPaket("Nama_Paket").ToString txtMin.Text = drPaket("Min_Paket").ToString txtHargaUmum.Text = drPaket("Harga_Umum").ToString txtHargaelajar.Text = drPaket("Harga_Pelajar").ToString

Catch errCari As Exception MsgBox(errCari.Message) End Try End Sub Private Sub btHapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHapus.Click Try Dim cbhapus As OleDb.OleDbCommandBuilder = New


OleDb.OleDbCommandBuilder(daPaket) drPaket.Delete() daPaket.DeleteCommand = cbhapus.GetDeleteCommand daPaket.Update(dtPaket) dtPaket.AcceptChanges() daPaket.DeleteCommand.Connection.Close() Catch errHapus As Exception MsgBox(errHapus.Message) End Try kosong() End Sub Private Sub btSelesai_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btSelesai.Click Close() End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try drPaket = dtPaket.Rows.Find(txtId_Paket.Text) If (txtId_Paket.Text = drPaket("Id_Paket")) Then MsgBox("Id Paket Sudah Ada") txtId_Paket.Text = "" txtId_Paket.Focus() Exit Sub End If Catch errCari As Exception MsgBox(errCari.Message) End Try txtNama.Focus() End Sub End Class

7. Coding Form TransaksiPublic Class FormTransaksi Dim daTransaksi As OleDb.OleDbDataAdapter Dim daPaket As OleDb.OleDbDataAdapter Dim daMember As OleDb.OleDbDataAdapter Dim con As New OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb")) Dim dtTransaksi As New DataTable() Dim dtPaket As New DataTable() Dim dtMember As New DataTable() Dim drTransaksi As DataRow


Dim drPaket As DataRow Dim drMember As DataRow 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 btTambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btTambah.Click Try Dim cbTambah As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daTransaksi) drTransaksi = dtTransaksi.NewRow

drTransaksi("No_Transaksi") = txtNo_Transaksi.Text drTransaksi("Tgl_Transaksi") = DateTimePicker1.Value drTransaksi("Tgl_Pemesanan") = DateTimePicker2.Value drTransaksi("Banyak_Pesanan") = txtB_Pesanan.Text drTransaksi("Total_Bayar") = txtTotBayar.Text drTransaksi("Bayar") = txtBayar.Text drTransaksi("Kembalian") = txtKembalian.Text drTransaksi("Id_Member") = cbId_Member.Text drTransaksi("Id_Paket") = cbId_Paket.Text dtTransaksi.Rows.Add(drTransaksi) con.Open() daTransaksi.Update(dtTransaksi) dtTransaksi.AcceptChanges() con.Close() Catch errTambah As Exception MsgBox(errTambah.Message) End Try kosong() End Sub Private Sub FormTransaksi_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DbTravelDataSet.Jabatan' table. You can move, or remove it, as needed. Me.JabatanTableAdapter.Fill(Me.DbTravelDataSet.Jabatan) Dim dc(1) As DataColumn Try daMember = New OleDb.OleDbDataAdapter("select * from Member", con) daMember.Fill(dtMember) dc(0) = dtMember.Columns("Id_Member")


dtMember.PrimaryKey = dc With cbId_Member .DataSource = dtMember .DisplayMember = "Id_Member" .ValueMember = "Id_Member" End With daPaket = New OleDb.OleDbDataAdapter("select * from Paket", con) daPaket.Fill(dtPaket) dc(0) = dtPaket.Columns("Id_Paket") dtPaket.PrimaryKey = dc With cbId_Paket .DataSource = dtPaket .DisplayMember = "Id_Paket" .ValueMember = "Id_Paket" End With daTransaksi = New OleDb.OleDbDataAdapter("select * from Transaksi", con) daTransaksi.Fill(dtTransaksi) dc(0) = dtTransaksi.Columns("NIK") dtTransaksi.PrimaryKey = dc dgTransaksi.DataSource = dtTransaksi Catch errConn As OleDb.OleDbException MsgBox(errConn.Message) End Try End Sub Private Sub kosong() txtNo_Transaksi.Text = "" txtNama_Pelanggan.Text = "" txtNama.Text = "" txtH_Paket.Text = "" txtB_Pesanan.Text = "" txtTotBayar.Text = "" txtBayar.Text = "" txtKembalian.Text = "" txtNo_Transaksi.Focus() End Sub Private Sub btClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btClear.Click kosong() End Sub Private Sub btCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btCari.Click Try drTransaksi = dtTransaksi.Rows.Find(txtNo_Transaksi.Text) txtNo_Transaksi.Text = "" txtNo_Transaksi.Text = drTransaksi("No_Transaksi").ToString DateTimePicker1.Text = drTransaksi("Tgl_Transaksi").ToString DateTimePicker2.Text = drTransaksi("Tgl_Pemesanan").ToString


txtB_Pesanan.Text = drTransaksi("Banyak_Pemesanan").ToString txtTotBayar.Text = drTransaksi("Total_Bayar").ToString txtBayar.Text = drTransaksi("Bayar").ToString txtKembalian.Text = drTransaksi("Kembalian").ToString cbId_Member.Text = drTransaksi("Id_Member").ToString cbId_Paket.Text = drTransaksi("Id_Paket").ToString Catch errCari As Exception MsgBox(errCari.Message) End Try End Sub Private Sub btHapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHapus.Click Try Dim cbhapus As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daTransaksi) drTransaksi.Delete() daTransaksi.DeleteCommand = cbhapus.GetDeleteCommand daTransaksi.Update(dtTransaksi) dtTransaksi.AcceptChanges() daTransaksi.DeleteCommand.Connection.Close() Catch errHapus As Exception MsgBox(errHapus.Message) End Try kosong() End Sub Private Sub cbId_Member_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbId_Member.SelectedIndexChanged Try Dim drMember As DataRow drMember = dtMember.Rows.Find(cbId_Member.Text) txtNama_Pelanggan.Text = drMember("Nama_Pelanggan").ToString Catch errTampil As Exception End Try End Sub Private Sub cbId_Paket_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbId_Paket.SelectedIndexChanged Try Dim drPaket As DataRow drPaket = dtPaket.Rows.Find(cbId_Paket.Text) txtNama.Text = drPaket("Nama_Paket").ToString


cbJ_Paket.Text = drPaket("Harga_Pelajar").ToString cbHUmum.Text = drPaket("Harga_Umum").ToString Catch errTampil As Exception End Try End Sub

Private Sub btSelesai_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btSelesai.Click Close() End Sub Private Sub btHitung_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHitung.Click Dim total, HargaPaket, banyak As Integer HargaPaket = Val(txtH_Paket.Text) banyak = Val(txtB_Pesanan.Text) total = Val(txtTotBayar.Text) total = HargaPaket * banyak txtTotBayar.Text = total End Sub Private Sub btPilih_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btPilih.Click If MsgBox("Apakah akan memilih harga umum ?", vbYesNo + vbQuestion) = vbYes Then txtH_Paket.Text = cbHUmum.Text Else txtH_Paket.Text = cbJ_Paket.Text End If End Sub

Private Sub txtBayar_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtBayar.TextChanged Dim kembalian, total, bayar As Integer total = Val(txtTotBayar.Text) bayar = Val(txtBayar.Text) kembalian = bayar - total txtKembalian.Text = kembalian End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btBatal.Click txtH_Paket.Text = "" End Sub End Class


8. Coding Form MemberPublic Class FormMember Dim daMember As OleDb.OleDbDataAdapter Dim con As New OleDb.OleDbConnection(Koneksi("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Kampus\semester 3\TRAVEL\Travel\dbTravel.mdb")) Dim dtMember As New DataTable() Dim drMember As DataRow 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 FormMember_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'DbTravelDataSet.Member' table. You can move, or remove it, as needed. Me.MemberTableAdapter.Fill(Me.DbTravelDataSet.Member) Dim dc(1) As DataColumn Try 'daDatKul = New OleDb.OleDbDataAdapter("select * from Member", con) daMember = New OleDb.OleDbDataAdapter("select * from Member", con) daMember.Fill(dtMember) dc(0) = dtMember.Columns("Id_Member") dtMember.PrimaryKey = dc dgMember.DataSource = dtMember Catch errConn As OleDb.OleDbException MsgBox(errConn.Message) End Try End Sub Private Sub btTambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btTambah.Click Try Dim cbTambah As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daMember) drMember = dtMember.NewRow

drMember("Id_Member") = txtId_Member.Text drMember("Nama_Pelanggan") = txtNama_Pelanggan.Text drMember("Alamat") = txtAlamat.Text drMember("TTL") = txtTTL.Text drMember("Pekerjaan") = txtPekerjaan.Text drMember("Telepon") = txtTelepon.Text dtMember.Rows.Add(drMember) con.Open() daMember.Update(dtMember) dtMember.AcceptChanges()


con.Close() Catch errTambah As Exception MsgBox(errTambah.Message) End Try kosong() End Sub Private Sub kosong() txtId_Member.Text = "" txtNama_Pelanggan.Text = "" txtAlamat.Text = "" txtTTL.Text = "" txtPekerjaan.Text = "" txtTelepon.Text = "" txtId_Member.Focus() End Sub Private Sub btClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btClear.Click kosong() End Sub Private Sub btCari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btCari.Click Try drMember = dtMember.Rows.Find(txtId_Member.Text) txtId_Member.Text = drMember("Id_Member").ToString txtNama_Pelanggan.Text = drMember("Nama_Pelanggan").ToString txtAlamat.Text = drMember("Alamat").ToString txtTTL.Text = drMember("TTL").ToString txtPekerjaan.Text = drMember("Pekerjaan").ToString txtTelepon.Text = drMember("Telepon").ToString

Catch errCari As Exception MsgBox(errCari.Message) End Try End Sub Private Sub btHapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btHapus.Click Try Dim cbhapus As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(daMember) drMember.Delete() daMember.DeleteCommand = cbhapus.GetDeleteCommand daMember.Update(dtMember) dtMember.AcceptChanges()


daMember.DeleteCommand.Connection.Close() Catch errHapus As Exception MsgBox(errHapus.Message) End Try kosong() End Sub Private Sub btSelesai_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btSelesai.Click Close() End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try drMember = dtMember.Rows.Find(txtId_Member.Text) If (txtId_Member.Text = drMember("Id_Member")) Then MsgBox("Id Member Sudah Ada") txtId_Member.Text = "" txtId_Member.Focus() Exit Sub End If Catch errCari As Exception MsgBox(errCari.Message) End Try txtNama_Pelanggan.Focus() End Sub End Class


BAB III PENUTUPA. KesimpulanSecara umum tujuan di buat makalah ini dalam Microsoft Visual Studio 2005 yang berjudul Program Aplikasi Travel agar dapat mempermudah dan membuat mengerti pembaca yang ingin belajar mengenai aplikasi ini.

B. SaranDiharapkan semoga makalah ini berguna untuk orang yang ingin mempelajari Microsoft Visual Studio 2005. Diharapkan Mengerti dan memahami Data Base yang telah disediakan dalam Microsoft Visual Stusio. Makalah ini dirancang agar mempermudah pembaca yang ingin mempelajarinya


DAFTAR PUSTAKAwww.google.com
