Sistem Basis Data:Perintah Query di Program Delphi: Difference between revisions
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
*Tampil pesan “There is no .....”, klik tombol No | *Tampil pesan “There is no .....”, klik tombol No | ||
*Klik kanan nama tabel MAHASISWA, klik Close | *Klik kanan nama tabel MAHASISWA, klik Close | ||
[[File:Query di Program Delphi 2.png|thumb|Tampilan Program Delphi]] | |||
*Klik drive C: | *Klik drive C: | ||
*Klik folder Program Files => Borland => Delphi6 => Bin | *Klik folder Program Files => Borland => Delphi6 => Bin | ||
| Line 20: | Line 21: | ||
*Ketik nama project RIZKISKS201 pada kotak File Name | *Ketik nama project RIZKISKS201 pada kotak File Name | ||
*Klik tombol Save | *Klik tombol Save | ||
==Menampilkan Data Mahasiswa (1)== | |||
*Klik tab ADO | |||
*Klik komponen ADOQuery, klik pada area form | |||
*Klik propertie Name, ketik TBMHS | |||
*Klik propertie Connection String | |||
*Klik tombol browse, klik tombol Build | |||
*Klik Microsoft Jet 4.0 OLE DB Provider | |||
*Klik tombol Next | |||
*Ketik nama file database DBNILAI.MDB | |||
*Klik tombol OK => OK | |||
*Klik propertie SQL, klik tombol browse | |||
*Ketik SELECT * FROM MAHASISWA | |||
*klik tombol OK | |||
*Klik propertie Active | |||
*Klik droplist, klik True | |||
Revision as of 22:13, 28 February 2022
- Double klik file DBNILAI.MDB
- Klik menu Create, Klik ikon Table Design
- Buat struktur tabel di bawah ini
- Klik ikon Save, Ketik nama tabel MAHASISWA
- Klik tombol Ok
- Tampil pesan “There is no .....”, klik tombol No
- Klik kanan nama tabel MAHASISWA, klik Close
- Klik drive C:
- Klik folder Program Files => Borland => Delphi6 => Bin
- Doubel klik file DELPHI32.EXE
- Klik propertie Name, ketik MAHASISWA
- Klik propertie Position
- Klik droplist, klik poScreenCenter
- Klik menu File => Save All
- Klik droplist pada Save In
- Tentukan drive dan folder lokasi penyimpanan
- Ketik nama unit UMAHASISWA pada kotak File Name
- Klik tombol Save
- Ketik nama project RIZKISKS201 pada kotak File Name
- Klik tombol Save
Menampilkan Data Mahasiswa (1)
- Klik tab ADO
- Klik komponen ADOQuery, klik pada area form
- Klik propertie Name, ketik TBMHS
- Klik propertie Connection String
- Klik tombol browse, klik tombol Build
- Klik Microsoft Jet 4.0 OLE DB Provider
- Klik tombol Next
- Ketik nama file database DBNILAI.MDB
- Klik tombol OK => OK
- Klik propertie SQL, klik tombol browse
- Ketik SELECT * FROM MAHASISWA
- klik tombol OK
- Klik propertie Active
- Klik droplist, klik True