Delphi Onderdils The Delphi Resources
|
open source masterhelp,macro, vba, word, cdma, component, delphi, excel |
This is example fill next grid with data using addoquery and microsoft Access database.
The first time you must add columns to nextgrid by double click the component, and then choose type column of next grid wicth do you want :
One of DML SQL Command is SELECT.
SELECT is command to show record(s) from tabel in database
Syntax :
SELECT * FROM TPEGAWAI;
| NO | NAME | BORNDATE | ADDRESS | SALARY |
|---|---|---|---|---|
| 1 | Andi | 20/08/1990 | Jl gajah mada 20 Jember | 3000000 |
| 2 | Edy | 16/07/1978 | Perum taman gading blok zb no 2 Jember | 5000000 |
| 3 | Jack | 18/05/1985 | Jl trunojoyo 18 | 4000000 |
NOTE :
How to use SQL in Delphi ADO…?
Microsoft’s ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing data sources. A part of MDAC, it provides a middleware layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner). ADO allows a developer to write programs that access data without knowing how the database is implemented. He must be aware of the database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to directly execute SQL commands. The disadvantage of the latter is that it introduces a dependency upon the type of database used.
ADO is positioned as a successor to Microsoft’s earlier object layers for accessing data sources, including RDO (Remote Data Objects) and DAO (Data Access Objects). ADO was introduced by Microsoft in October 1996.
In delphi
TADOConnection connects to an ADO data store.