: , Microsoft Access; .
: Access , ( !!!):
1) (__, _, )
2) (__, , , _, , _, , _)
3) (_, _, _).
, , , . ( 10 ). .
Delphi. .
ADO: ADOConnection, ADOTable, DataAccess DataSource, DBControl DBGrid.
ADOConnection1: ConnectionString Use ConnectionString Build: OLE DB Microsoft Jet 4.0 OLE DB Provider, , (.\ _ _.mdb); Read/Write, .
LoginPrompt ( ) false.
DataSource1: DataSet ADOTable1.
ADOTable1: Connection -- ADOConnection1, TableName .
DBGrid1: DataSource -- DataSource1.
Active ADOTable1 true.
, DBGrid .
DB Navigator. DBGrid. , . DBGrid readonly.
.
. .
DBGrid DataControl, DBComboBox. DBEdit : DataSource DataField.
, .
.
.
DataSource, ADOConnection, ADOQuery, .
( DBCtrlGrid, ).
: , , , . .
:
ADOQuery1.Close; //
ADOQuery1.SQL.Clear; // SQL
ADOQuery1.SQL.Text:=' Select { } from { ()} where =:p1'; // , p1
|
|
ADOQuery1.Parameters[0].Value:=edit1.text; //
ADOQuery1.Open; //
:
ADOQuery1.Close; //
ADOQuery1.SQL.Clear; // SQL
ADOQuery1.SQL.Text:=' Select { } from { ()} where like +Edi1.text+%; // , , Edit1.text
ADOQuery1.Open; //
( ).
:
- , ; ( order by, )
- ,
- , .
3 ( and, or) .