Wiki

Sistem Basis Data:Perintah Query di Program Delphi: Difference between revisions

Kangtain (talk | contribs)
Bureaucrats, Interface administrators, Suppressors, Administrators
9,154 edits
VisualWikitext
Created page with "#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..."
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
#Double klik file DBNILAI.MDB
*Double klik file <code>DBNILAI.MDB</code>
#Klik menu Create, Klik ikon Table Design
*Klik menu Create, Klik ikon <code>Table Design</code>
#Buat struktur tabel di bawah ini
*Buat struktur tabel di bawah ini
#Klik ikon Save, Ketik nama tabel MAHASISWA
[[File:Query di Program Delphi 1.png|thumb|center]]
#Klik tombol Ok
*Klik ikon <code>Save</code>, Ketik nama tabel <code>MAHASISWA</code>
#Tampil pesan “There is no .....”, klik tombol No
*Klik tombol <code>OK</code>
#Klik kanan nama tabel MAHASISWA, klik Close
*Tampil pesan <code>There is no .....</code>, klik tombol <code>NO</code>
*Klik kanan nama tabel <code>MAHASISWA</code>, klik <code>Close</code>
[[File:Query di Program Delphi 2.png|thumb|Tampilan Program Delphi]]
*Klik drive <code>C:</code>
*Klik folder <code>Program Files</code> → <code>Borland</code> → <code>Delphi6</code> → <code>Bin</code>
*Doubel klik file <code>DELPHI32.EXE</code>
*Klik propertie Name, ketik <code>MAHASISWA</code>
*Klik propertie <code>Position</code>
*Klik droplist, klik <code>poScreenCenter</code>
*Klik menu <code>File</code> → <code>Save All</code>
*Klik droplist pada <code>Save In</code>
*Tentukan drive dan folder lokasi penyimpanan
*Ketik nama unit <code>UMAHASISWA</code> pada kotak <code>File Name</code>
*Klik tombol <code>Save</code>
*Ketik nama project <code>RIZKISKS201</code> pada kotak File Name
*Klik tombol Save


Klik drive C:
==Menampilkan Data Mahasiswa (1)==
Klik folder Program Files => Borland => Delphi6 => Bin
*Klik tab <code>ADO</code>
Doubel klik file DELPHI32.EXE
*Klik komponen <code>ADOQuery</code>, klik pada area form
Klik propertie Name, ketik MAHASISWA
*Klik propertie <code>Name</code>, ketik <code>TBMHS</code>
Klik propertie Position
*Klik propertie <code>Connection String</code>
Klik droplist, klik poScreenCenter
*Klik tombol browse, klik tombol <code>Build</code>
Klik menu File => Save All
*Klik <code>Microsoft Jet 4.0 OLE DB Provider</code>
Klik droplist pada Save In
*Klik tombol <code>Next</code>
Tentukan drive dan folder lokasi penyimpanan
*Ketik nama file database <code>DBNILAI.MDB</code>
Ketik nama unit UMAHASISWA pada kotak File Name
*Klik tombol <code>OK</code>
Klik tombol Save
*Klik propertie <code>SQL</code>, klik tombol <code>browse</code>
Ketik nama project RIZKISKS201 pada kotak File Name
*Ketik <code>SELECT * FROM MAHASISWA</code>
Klik tombol Save
*klik tombol <code>OK</code>
*Klik propertie <code>Active</code>
*Klik <code>droplist</code>, klik <code>True</code>
 
==Menampilkan Data Mahasiswa (2)==
*Klik tab <code>Data Access</code>
*Klik komponen <code>DataSource</code>
*Klik area form
*Klik propertie <code>Name</code>
*Ketik <code>DSMHS</code>
*Klik propertie <code>DataSet</code>
*Klik <code>droplist</code>, klik <code>TBMHS</code>
*Klik tab <code>DataControl</code>
*Klik komponen <code>DbGrid</code>
*Buat kotak dengan draging mouse pada area form
*Klik propertie <code>Name</code>, ketik <code>DBGMHS</code>
*Klik propertie <code>DataSource</code>
*Klik <code>droplist</code>, klik <code>DSMHS</code>
 
[[Category:Materi]]
[[Category:Matkul]]
[[Category:Sistem Basis Data]]
Retrieved from "https://kangtain.com/wiki/index.php/Sistem_Basis_Data:Perintah_Query_di_Program_Delphi"