coding form vb

7/25/2019 Coding Form VB

1/3

ImportsSystem.Data.OleDb

PublicClassFilm SubKosongkan() TNomor.Tet ! "" T#u$ul.Tet ! "" TTari%.Tet ! ""

TStok.Tet ! "" TNomor.Focus() &n$Sub

SubData'aru() T#u$ul.Tet ! "" TTari%.Tet ! "" TStok.Tet ! "" T#u$ul.Focus() &n$Sub

SubTampilri$() $a ! NeOleDbData*$apter("Select + %rom Film", Conn) $s ! NeDataSet $s.Clear() $a.Fill($s, "Film") D-.DataSource ! ($s.Tables("Film")) D-.ea$Only !True &n$Sub

SubTampilData() T#u$ul.Tet ! r$.Item("#u$ul") TTari%.Tet ! r$.Item("Tari%") TStok.Tet ! r$.Item("Stok")

&n$Sub

Pri/ateSubFilm01oa$('y-alsen$er *sSystem.Ob2ect, 'y-ale *sSystem.&/ent*rgs) 3an$les4y'ase.1oa$ CallKoneksi() CallTampilri$() &n$Sub

Pri/ateSubTNomor0KeyPress('y-alsen$er *sOb2ect, 'y-ale *sSystem.5in$os.Forms.KeyPress&/ent*rgs) 3an$lesTNomor.KeyPress TNomor.4a1engt6 ! 7 I%e.KeyC6ar ! C6r(89)T6en TNomor.Tet ! :Case(TNomor.Tet) cm$ ! NeOleDbComman$("select + %rom Film 6ere NomorFlm!;"< TNomor.Tet < ";",Conn) r$ ! cm$.&ecuteea$er

r$.ea$() I%r$.3asos !TrueT6en CallTampilData() T#u$ul.Focus() &lse CallData'aru() T#u$ul.Focus() &n$I% &n$I% &n$Sub


2/3

Pri/ateSubT#u$ul0KeyPress('y-alsen$er *sOb2ect, 'y-ale *sSystem.5in$os.Forms.KeyPress&/ent*rgs) 3an$lesT#u$ul.KeyPress I%e.KeyC6ar ! C6r(89)T6en T#u$ul.Tet ! :Case(T#u$ul.Tet) TTari%.Focus() &n$I%

&n$Sub

Pri/ateSubTTari%0KeyPress('y-alsen$er *sOb2ect, 'y-ale *sSystem.5in$os.Forms.KeyPress&/ent*rgs) 3an$lesTTari%.KeyPress I%e.KeyC6ar ! C6r(89)T6en TTari%.Tet ! :Case(TTari%.Tet) TStok.Focus() &n$I% I%Not((e.KeyC6ar =! ">"*n$e.KeyC6ar ?! "@") Ore.KeyC6ar ! /b'ack)T6ene.3an$le$()!True &n$Sub

Pri/ateSubTStok0KeyPress('y-alsen$er *sOb2ect, 'y-ale *sSystem.5in$os.Forms.KeyPress&/ent*rgs) 3an$lesTStok.KeyPress I%e.KeyC6ar ! C6r(89)T6enCm$Simpan.Focus() I%Not((e.KeyC6ar =! ">"*n$e.KeyC6ar ?! "@") Ore.KeyC6ar ! /b'ack)T6ene.3an$le$()!True &n$Sub

Pri/ateSubCm$Simpan0Click('y-alsen$er *sSystem.Ob2ect, 'y-ale *sSystem.&/ent*rgs)3an$lesCm$Simpan.Click I%TNomor.Tet ! ""OrT#u$ul.Tet ! ""OrTTari%.Tet ! ""OrTStok.Tet ! ""T6en 4sg'o("Data 'elum 1engkap") &it Sub &lse cm$ ! NeOleDbComman$("Select + %rom Film 6ere NomorFlm!;"< TNomor.Tet < ";",Conn)

r$ ! cm$.&ecuteea$er r$.ea$() I%Notr$.3asosT6en DimsAltamba6 *sString! "Insert into Film(NomorFlm,#u$ul,Tari%,Stok) /alues "< 0 "(;"< TNomor.Tet < ";,;"< T#u$ul.Tet < ";,;"< TTari%.Tet < ";,;"< TStok.Tet < ";)" cm$ ! NeOleDbComman$(sAltamba6, Conn) cm$.&ecuteNonBuery() CallKosongkan() CallTampilri$() &lse DimsAle$it *sString! ":p$ate Film set "< 0 "#u$ul!;"< T#u$ul.Tet < ";, "< 0 "Tari%!;"< TTari%.Tet < ";, "< 0 "Stok!;"< TStok.Tet < "; 6ere NomorFlm!;"< TNomor.Tet < ";"

cm$ ! NeOleDbComman$(sAle$it, Conn) cm$.&ecuteNonBuery() CallKosongkan() CallTampilri$() &n$I% &n$I% &n$Sub

Pri/ateSubCm$'atal0Click('y-alsen$er *sSystem.Ob2ect, 'y-ale *sSystem.&/ent*rgs)3an$lesCm$'atal.Click


3/3

CallKosongkan() &n$Sub

Pri/ateSubCm$Tutup0Click('y-alsen$er *sSystem.Ob2ect, 'y-ale *sSystem.&/ent*rgs)3an$lesCm$Tutup.Click 4e.Close() &n$Sub

Pri/ateSubCm$3apus0Click('y-alsen$er *sSystem.Ob2ect, 'y-ale *sSystem.&/ent*rgs)3an$lesCm$3apus.Click I%TNomor.Tet ! ""T6en 4sg'o("Isi ko$e Film terlebi6 $a6ulu") TNomor.Focus() &it Sub &lse I%4essage'o.S6o("akin akan $i6apus..", "", 4essage'o'uttons.esNo) !5in$os.Forms.Dialogesult.esT6en cm$ ! NeOleDbComman$("Delete + %rom Film 6ere NomorFlm!;"< TNomor.Tet

coding form vb

Documents