code listing visual basic

5/12/2018 Code Listing Visual Basic - slidepdf.com

http://slidepdf.com/reader/full/code-listing-visual-basic 1/18

Module1

'deklarasi variabel globa

Public Koneksi As New ADODB.Connection

Public RSreg As New ADODB.Recordset

'buka koneksi databases

Public Sub BukaSambungan()

Set Koneksi = New ADODB.Connection

Koneksi.CursorLocation = adUseClient

Koneksi.Open "Driver={MySQL ODBC 5.1

Driver};Server=localhost;Port=3306;Database=pmb;User=root;Password=biasa;Option=3;"

End Sub

'buka koneksi tabel obat

Public Sub KoneksiRegistrasi()

Set RSreg = New ADODB.Recordset

RSreg.CursorLocation = adUseClient

RSreg.Open "SELECT * FROM registrasi", Koneksi, adOpenDynamic, adLockOptimistic

End Sub



Form Menu

Private Sub MnKeluar_Click()

If MsgBox("Anda yakin akan keluar ?", vbYesNo + vbQuestion, "Pesan Keluar") = vbYes Then

MsgBox "Terima kasih telah menggunakan aplikasi, program belum sempurna, kritik dan saran

ke [email protected]", vbOKOnly + vbInformation, "Pesan Keluar"

End

Else

Exit Sub

End If

End Sub

Private Sub MnLihat_Click()

frmLihat.Show

End Sub

Private Sub MnRegistrasi_Click()

frmRegistrasi.Show

End Sub

Form Lihat

Private Sub Button1_Click()

Unload Me

End Sub



Private Sub Form_Load()

Call BukaSambungan

Call KoneksiRegistrasi

Set DataGrid1.DataSource = RSreg

DataGrid1.Refresh

End Sub

Form Registrasi

Private Sub cmdExit_Click()

Unload Me

End Sub

Private Sub cmdReset_Click()

Call kosong

End Sub

Private Sub cmdSubmit_Click()

If txtUsername.Text = "" Then

MsgBox "Maaf..Terjadi kesalahan input data atau data anda belum lengkap. Periksa Kembali!"

txtUsername.SetFocus

ElseIf txtPassword.Text = "" Then


txtPassword.SetFocus

ElseIf txtNama.Text = "" Then


txtNama.SetFocus



ElseIf cboJK.Text = "" Then


cboJK.SetFocus

ElseIf txtTempatLahir.Text = "" Then


txtTempatLahir.SetFocus

ElseIf cboAgama.Text = "" Then


cboAgama.SetFocus

ElseIf txtAnakKe.Text = "" Then


txtAnakKe.SetFocus

ElseIf txtNoKTP.Text = "" Then


txtNoKTP.SetFocus

ElseIf txtAlamat.Text = "" Then


txtAlamat.SetFocus

ElseIf txtKota.Text = "" Then


txtKota.SetFocus

ElseIf txtKodePOS.Text = "" Then


txtKodePOS.SetFocus

ElseIf txtEmail.Text = "" Then




txtEmail.SetFocus

ElseIf txtTelepon.Text = "" Then


txtTelepon.SetFocus

ElseIf cboAsalSekolah.Text = "" Then


cboAsalSekolah.SetFocus

ElseIf cboJurusanSekolahAsal.Text = "" Then


cboJurusanSekolahAsal.SetFocus

ElseIf txtNamaSekolah.Text = "" Then


txtNamaSekolah.SetFocus

ElseIf txtTahunLulus.Text = "" Then


txtTahunLulus.SetFocus

ElseIf txtAlamatSekolah.Text = "" Then


txtAlamatSekolah.SetFocus

ElseIf txtKodePOSSekolah.Text = "" Then


txtKodePOSSekolah.SetFocus

ElseIf txtNamaBapak.Text = "" Then


txtNamaBapak.SetFocus

ElseIf cboKerjaBapak.Text = "" Then




cboKerjaBapak.SetFocus

ElseIf txtNamaIbu.Text = "" Then


txtNamaIbu.SetFocus

ElseIf cboKerjaIbu.Text = "" Then


cboKerjaIbu.SetFocus

ElseIf cboPendapatan.Text = "" Then


cboPendapatan.SetFocus

ElseIf txtAlamatOrtu.Text = "" Then


txtAlamatOrtu.SetFocus

ElseIf txtTeleponOrtu.Text = "" Then


txtTeleponOrtu.SetFocus

ElseIf cboJurusanPilihan.Text = "" Then


cboJurusanPilihan.SetFocus

ElseIf cboJenjang.Text = "" Then


cboJenjang.SetFocus

ElseIf cboKeterangan.Text = "" Then


cboKeterangan.SetFocus



Else

RSreg.AddNew

RSreg!UserName = txtUsername.Text

RSreg!Password = txtPassword.Text

RSreg!Nama = txtNama.Text

RSreg!JK = cboJK.Text

RSreg!TempatLahir = txtTempatLahir.Text

RSreg!TanggalLahir = dtTanggalLahir.Value

RSreg!Agama = cboAgama.Text

RSreg!AnakKe = txtAnakKe.Text

RSreg!NoKTP = txtNoKTP.Text

RSreg!Alamat = txtAlamat.Text

RSreg!Kota = txtKota.Text

RSreg!KodePOS = txtKodePOS.Text

RSreg!Email = txtEmail.Text

RSreg!NoTelepon = txtTelepon.Text

RSreg!AsalSekolah = cboAsalSekolah.Text

RSreg!JurusanSekolahAsal = cboJurusanSekolahAsal.Text

RSreg!NamaSekolah = txtNamaSekolah.Text

RSreg!TahunLulus = txtTahunLulus.Text

RSreg!AlamatSekolah = txtAlamatSekolah.Text

RSreg!KodePOSSekolah = txtKodePOSSekolah.Text



RSreg!NamaBapak = txtNamaBapak.Text

RSreg!KerjaBapak = cboKerjaBapak.Text

RSreg!NamaIbu = txtNamaIbu.Text

RSreg!KerjaIbu = cboKerjaIbu.Text

RSreg!Pendapatan = cboPendapatan.Text

RSreg!AlamatOrtu = txtAlamatOrtu.Text

RSreg!TeleponOrtu = txtTeleponOrtu.Text

RSreg!JurusanPilihan = cboJurusanPilihan.Text

RSreg!Jenjang = cboJenjang.Text

RSreg!Keterangan = cboKeterangan.Text

RSreg.Update

Call kosong

txtUsername.SetFocus

MsgBox "Anda berhasil terdaftar"

End If

End Sub

Private Sub txtUsername_KeyPress(keyascii As Integer)

If keyascii = 13 Then

txtPassword.SetFocus

End If

End Sub

Private Sub txtPassword_KeyPress(keyascii As Integer)




txtNama.SetFocus

End If

End Sub

Private Sub txtNama_KeyPress(keyascii As Integer)


cboJK.SetFocus

End If

End Sub

Private Sub cboJK_KeyPress(keyascii As Integer)


txtTempatLahir.SetFocus

End If

End Sub

Private Sub txtTempatLahir_KeyPress(keyascii As Integer)


dtTanggalLahir.SetFocus

End If

End Sub

Private Sub dtTanggal_KeyPress(keyascii As Integer)


cboAgama.SetFocus

End If

End Sub

Private Sub cboAgama_KeyPress(keyascii As Integer)


txtAnakKe.SetFocus



End If

End Sub

Private Sub txtAnakKe_KeyPress(keyascii As Integer)


txtNoKTP.SetFocus

End If

End Sub

Private Sub txtNoKTP_KeyPress(keyascii As Integer)


txtAlamat.SetFocus

End If

End Sub

Private Sub txtKota_KeyPress(keyascii As Integer)


txtKodePOS.SetFocus

End If

End Sub

Private Sub txtKodePOS_KeyPress(keyascii As Integer)


txtEmail.SetFocus

End If

End Sub

Private Sub txtEmail_KeyPress(keyascii As Integer)


txtTelepon.SetFocus

End If



End Sub

Private Sub txtTelepon_KeyPress(keyascii As Integer)


cboAsalSekolah.SetFocus

End If

End Sub

Private Sub cboAsalSekolah_KeyPress(keyascii As Integer)


cboJurusanSekolahAsal.SetFocus

End If

End Sub

Private Sub cboJurusanSekolahAsal_KeyPress(keyascii As Integer)


txtNamaSekolah.SetFocus

End If

End Sub

Private Sub txtNamaSekolah_KeyPress(keyascii As Integer)


txtTahunLulus.SetFocus

End If

End Sub

Private Sub txtTahunLulus_KeyPress(keyascii As Integer)


txtAlamatSekolah.SetFocus

End If

End Sub



Private Sub txtAlamatSekolah_KeyPress(keyascii As Integer)


txtKodePOSSekolah.SetFocus

End If

End Sub

Private Sub txtKodePOSSekolah_KeyPress(keyascii As Integer)


txtNamaBapak.SetFocus

End If

End Sub

Private Sub txtNamaBapak_KeyPress(keyascii As Integer)


cboKerjaBapak.SetFocus

End If

End Sub

Private Sub cboKerjaBapak_KeyPress(keyascii As Integer)


txtNamaIbu.SetFocus

End If

End Sub

Private Sub txtNamaIbu_KeyPress(keyascii As Integer)


cboKerjaIbu.SetFocus

End If



End Sub

Private Sub cboKerjaIbu_KeyPress(keyascii As Integer)


cboPendapatan.SetFocus

End If

End Sub

Private Sub cboPendapatan_KeyPress(keyascii As Integer)


txtAlamatOrtu.SetFocus

End If

End Sub

Private Sub txtAlamatOrtu_KeyPress(keyascii As Integer)


txtTeleponOrtu.SetFocus

End If

End Sub

'combo list

Private Sub list()

'list jenis kelamin

cboJK.AddItem "Pria"

cboJK.AddItem "Wanita"

'list agama

cboAgama.AddItem "Islam"



cboAgama.AddItem "Kristen"

cboAgama.AddItem "Katolik"

cboAgama.AddItem "Hindu"

cboAgama.AddItem "Budah"

cboAgama.AddItem "Lainnya"

'list asal sekolah

cboAsalSekolah.AddItem "SMU"

cboAsalSekolah.AddItem "SMK"

cboAsalSekolah.AddItem "MA"

'list jurusan sekolah asal

cboJurusanSekolahAsal.AddItem "IPA"

cboJurusanSekolahAsal.AddItem "IPS"

cboJurusanSekolahAsal.AddItem "Bahasa"

cboJurusanSekolahAsal.AddItem "Komputer"

cboJurusanSekolahAsal.AddItem "Listrik"

cboJurusanSekolahAsal.AddItem "Lainnya"

'list kerja ortu

cboKerjaBapak.AddItem "PNS"

cboKerjaBapak.AddItem "Polri"

cboKerjaBapak.AddItem "TNI"

cboKerjaBapak.AddItem "Pegawai Swasta"

cboKerjaBapak.AddItem "Wiraswasta"

cboKerjaBapak.AddItem "Lainnya"



cboKerjaIbu.AddItem "PNS"

cboKerjaIbu.AddItem "Polri"

cboKerjaIbu.AddItem "TNI"

cboKerjaIbu.AddItem "Pegawai Swasta"

cboKerjaIbu.AddItem "Wiraswasta"

cboKerjaIbu.AddItem "Lainnya"

'pendapatan

cboKerjaBapak.AddItem "PNS"

cboKerjaBapak.AddItem "Polri"

cboKerjaBapak.AddItem "TNI"

cboKerjaBapak.AddItem "Pegawai Swasta"

cboKerjaBapak.AddItem "Wiraswasta"

cboKerjaBapak.AddItem "Lainnya"

cboKerjaIbu.AddItem "PNS"

cboKerjaIbu.AddItem "Polri"

cboKerjaIbu.AddItem "TNI"

cboKerjaIbu.AddItem "Pegawai Swasta"

cboKerjaIbu.AddItem "Wiraswasta"

cboKerjaIbu.AddItem "Lainnya"

'list pendapatan ortu

cboPendapatan.AddItem "10000000"







'ket tambahan

cboJurusanPilihan.AddItem "Teknik Informatika"

cboJurusanPilihan.AddItem "Sistem Informasi"

cboJenjang.AddItem "S1"

cboJenjang.AddItem "D3"

cboJenjang.AddItem "D2"

cboKeterangan.AddItem "Kelas Reguler"

cboKeterangan.AddItem "Kelas Unggul"

End Sub

Private Sub Form_Load()

Call BukaSambungan

Call KoneksiRegistrasi

Call list

Call kosong

End Sub

Private Sub kosong()

txtUsername.Text = ""

txtPassword.Text = ""



txtNama.Text = ""

txtTempatLahir.Text = ""

dtTanggalLahir.Value = "01/01/1990"

txtAnakKe.Text = ""

txtNoKTP.Text = ""

txtAlamat.Text = ""

txtKota.Text = ""

txtKodePOS.Text = ""

txtEmail.Text = ""

txtTelepon.Text = ""

txtNamaSekolah.Text = ""

txtTahunLulus.Text = ""

txtAlamatSekolah.Text = ""

txtKodePOSSekolah.Text = ""

txtNamaBapak.Text = ""

txtNamaIbu.Text = ""

txtAlamatOrtu.Text = ""

txtTeleponOrtu.Text = ""

End Sub

Private Sub tutupkoneksi()

RSreg.Close

Set RSreg = Nothing

Koneksi.Close



Set Koneksi = Nothing

End Sub

Private Sub Form_Unload(Cancel As Integer)

Call kosong

Call tutupkoneksi

Unload Me

End Sub

code listing visual basic

Documents