. , Delphi, DataAccess DataSource DataControl . : DBGrid, DBNavigator, DBCombobox .. . .
, . - . . . , , - . : , . , Table (DBTable) - . BDE. , ODBC - . DataBaseName, ODBC - . TableName . , DataBaseName . TableName . . ( Table1). .
. DataAccess DataSource . , DataSet. .
DBGrid. DataControls. ( DataSource), . , . Active (Table) True. , Grid . , .. False.
. ? Active . , Open . , , OnActivate . . .
, Grid , , .. DBNavigator DataControls, . , .. DataSource. . , Access.
|
|
ADO.
,
: , MS Access , MS Excel. ADO.
! , .. .
ADO . , . , Connection . Open . , , , , Open.
Dim adoConn As ADODB.Connection
Set adoConn = CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\111.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False"
adoConn.ConnectionTimeout = 15
adoConn.CommandTimeout = 30
adoconn.CursorLocation = ADODB.adUseClient
' (.. )
adoConn.Open
. . udl (User Data Link), , try.udl. ( Total Commander). , , , . . , , .. . , . , MS SQL Server, Microsoft OLE DB Provider for SQL Server). Oracle Microsoft OLE DB Provider for Oracle. Access Microsoft JET 4.0 OLE DB Provider. . () . MS Access . , , . , ( ). , . , . , , . , . try.udl, ( ), ( , !) , objConn.ConnectionString.
|
|
udl ODBC . , . , . , . .
ConnectionTimeout . , . 0, .
CommandTimeout . , , . , .
. . ( , , ) . : Close, , Nothing.
adoConn.Close
Set adoConn = Nothing
, , RecordSet. , . .
Dim adors As New ADODB.Recordset
adors.ActiveConnection = objConn
adors.CursorType = ADODB.adOpenForwardOnly
adors.LockType = ADODB.adLockReadOnly
, .
CursorType , , , . . , , .
-, , Dynamic Forward Only ! , , , , , ! , , ( CursorType Open), ( Open), .
. CursorLocation adUseClient, Static, , . adUseServer, KeySet. , , , , , , , . adUseServer, . , . recordCount Bookmark , Open KeySet Static , Dynamic ForwardOnly.
, ForwardOnly .
|
|
CursorType. , ADO , , DAO.
: Close Recordset. DAO Close RecordSet Nothing. ADO . , , .. , , , . , , -, Clear . , . , , . , . , . ( Select), , . , , : close, RecordSet Nothing.
, , , DAO ADO.
:
adOpenForwardOnly , . , . CursorType , RecordCount ( ).
adOpenStatic , .
adOpenKeyset , , , .
adOpenDynamic , , , .
LockType , , .
adLockReadOnly .
adLockPessimistic , ( ) .
adLockOptimistic , Update.
adLockBatchOptimistic , Update .
CursorLocation , , () . adUseClient adUseServer
! RecordSet Connection. , , .
, Open. ( ), SQL-.
adors.Open "_"
:
adors.Open "Select * from _"
Open. , Open, Option. . adCmdText, , Open - SQL-. adCmdTable , , SQL-, . adCmdTableDirect , . adCmdStoredProc .