KONEK DATABASE DAN LANGKAH-LANGKAH VB

KONEK DATABASE

1. sqlpuls/nolog
2. conn sys/oracle@orcl as sysdba;
3. create user audy identified by audy;
4. grant connect to audy;
5. conn audy/audy@orcl
6. conn sys/oracle@orcl as sysdba;
7. grant all privileges to audy identified by audy;
8. conn audy/audy@orcl
9. create table mhw (npm char(10), nama varchar2(50), alamat varchar2(50));
10. insert into mhw (npm, nama, alamat) values (1635010004, 'erica', 'lmg');
11. select * from mhw;
12. commit;

VB CONNECTED

1. new project
2. add reference --> sys data oracle client
3. tools --> connect to db
4. toolbox --> listview --> properties --> coloumn (collection) yg ... klik
   add --> text diganti nama kolom npm
   add --> text diganti nama kolom nama
   add --> text diganti nama kolom alamat
   kalau tidak muncul, properties --> view diganti details
5. import sys
6. inisialisasi Dim
   Dim xconn
   Dim xcomm
   Dim dr
   Dim npm, nama, alamat As String
7. buat sub konek --> pakai:
   conn close()
   conn open()
   Ditaruh diatas form load
8. manggil konek

VB DISCONNECTED

1. new project
2. add reference --> sys data oracle client
3. tools --> connect to db
4. toolbox --> DataGridView
5. klik2x utk koding
6. import sys
7. Dim, dkk
8. sub koneksi --> end sub
9. server explore --> properties
10. private sub
11. ganti 32 ke 64 + password
12. klik toolbox buat textbox + button
13. buat label, dll
14. insert into '" & .......... dll