{ Berbagi, Menulis, Dan Mengajar } Ilmu… » Archive
SCRIPT TAMPILKAN DATA BUKU SDM
Set Rs_PegawaiBesar = New ADODB.Recordset Rs_PegawaiBesar.Open “SELECT Pegawai.NIP, ” _ & ” Pegawai.Nm_Pegawai ” _ & ” FROM Pegawai,DataBesarPegawai ” _ & ” WHERE Pegawai.NIP=DataBesarPegawai.NIP ” _ & ” ORDER BY DataBesarPegawai.NIP”, _ DBKoneksi, adOpenDynamic, adLockBatchOptimistic With Rs_PegawaiBesar If .BOF Then MsgBox “Informasi SDM Pegawai Masih Kosong ! “, _ vbInformation + vbOKOnly, “Informasi” Exit Sub Else i = 1 ListDataTersimpan.ListItems.Clear While Not .EOF Set View = ListDataTersimpan.ListItems.Add View.Text = i View.SubItems(1) = !NIP View.SubItems(2) = !Nm_Pegawai i = i + 1 .MoveNext Wend End If End With … Read entire article »
Filed under: 7. Operating System
Update
UPDATE `pangkat` SET `Golongan`='IV', `Ruang`='B', `TMT`='12-12-2001', `Gapok`='12000' WHERE `Kd_Pangkat`='G04' … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
Perintah UPDATE
update `dbpenggajian`.`pangkat` set `Kd_Pangkat`=” where `Kd_Pangkat`=’001′ … Read entire article »
Filed under: 7. Operating System
Dasar INSERT INTO
insert into `dbpenggajian`.`pangkat`(`Kd_Pangkat`,`Golongan`,`Ruang`,`TMT`,`Gapok`) values ( NULL,’877′,NULL,NULL,NULL) Contoh insert into `pangkat`(`Kd_Pangkat`,`Golongan`,`Ruang`,`TMT`,`Gapok`) VALUES('001','II','C','00-11-2011','2500') … Read entire article »
Filed under: 4. Programming / IDE, MYSQL
Penghapus Virus Short Cut
Ubah Dengan Extension .bat Penghapus Virus shortcut … Read entire article »
Filed under: 7. Operating System
ini link ipin upin nasywa
http://www.youtube.com/watch?v=hti0JTLhLXg … Read entire article »
Filed under: 7. Operating System
BPPS ONLINE
Selamat, Anda telah berhasil melakukan proses pendaftaran BPPS dengan Nama : R Dimas Adityo No Registrasi : 1101050106347 <br/><br/> Username : 200107037 Password : QG9px4 … Read entire article »
Filed under: 7. Operating System