Obiekt ActiveX Data Object (ADO) pozwala aplikacji klienckiej na dostęp oraz obróbkę danych znajdujących się na serwerze bazy danych poprzez OLE DB provider. Dużą zaletą ADO jest łatwość użycia oraz szybkość.
1. Obiekt Command
| Właściwości |
| ActiveConnection |
- |
|
| CommandStream |
- |
|
| CommandText |
- |
|
| CommandTimeout |
- |
|
| CommandType |
- |
|
| Dialect |
- |
|
| Name |
- |
|
| NamedParameters |
- |
|
| Prepared |
- |
|
| State |
- |
|
| Metody |
| Cancel |
- |
|
| CreateParameter |
- |
|
| Execute |
- |
|
2. Obiekt Connection
| Właściwości |
| Attributes |
- |
|
| CommandTimeout |
- |
|
| ConnectionString |
- |
|
| ConnectionTimeout |
- |
|
| CursorLocation |
- |
|
| DefaultDatabase |
- |
|
| IsolationLevel |
- |
|
| Mode |
- |
|
| Provider |
- |
|
| State |
- |
|
| Version |
- |
|
| Metody |
| BeginTrans |
- |
|
| Cancel |
- |
|
| Close |
- |
|
| CommitTrans |
- |
|
| Execute |
- |
|
| Open |
- |
|
| OpenSchema |
- |
|
| RollbackTrans |
- |
|
| Zdarzenia |
| BeginTransComplete |
- |
|
| CommitTransComplete |
- |
|
| ConnectComplete |
- |
|
| Disconnect |
- |
|
| ExecuteComplete |
- |
|
| InfoMessage |
- |
|
| RollbackTransComplete |
- |
|
| WillConnect |
- |
|
| WillExecute |
- |
|
3. Obiekt Recordset
| Właściwości |
| AbsolutePage |
- |
|
| AbsolutePosition |
- |
|
| ActiveCommand |
- |
|
| BOF |
- |
|
| Bookmark |
- |
|
| CacheSize |
- |
|
| CursorLocation |
- |
|
| CursorType |
- |
|
| DataMember |
- |
|
| DataSource |
- |
|
| EditMode |
- |
|
| EOF |
- |
|
| Filter |
- |
|
| Index |
- |
|
| LockType |
- |
|
| MarshalOptions |
- |
|
| MaxRecords |
- |
|
| PageCount |
- |
|
| PageSize |
- |
|
| RecordCount |
- |
|
| Sort |
- |
|
| Source |
- |
|
| Status |
- |
|
| StayInSync |
- |
|
| Metody |
| AddNew |
- |
|
| Cancel |
- |
|
| CancelBatch |
- |
|
| CancelUpdate |
- |
|
| Clone |
- |
|
| Close |
- |
|
| CompareBookmarks |
- |
|
| Delete |
- |
|
| Find |
- |
|
| GetRows |
- |
|
| GetString |
- |
|
| Move |
- |
|
| MoveFirst |
- |
|
| MoveLast |
- |
|
| MoveNext |
- |
|
| MovePrevious |
- |
|
| NextRecordset |
- |
|
| Open |
- |
|
| Requery |
- |
|
| Resync |
- |
|
| Save |
- |
|
| Seek |
- |
|
| Update |
- |
|
| UpdateBatch |
- |
|
| Zdarzenia |
| EndOfRecordset |
- |
|
| FetchComplete |
- |
|
| FetchProgress |
- |
|
| FieldChangeComplete |
- |
|
| MoveComplete |
- |
|
| RecordChangeComplete |
- |
|
| RecordsetChangeComplete |
- |
|
| WillChangeField |
- |
|
| WillChangeRecord |
- |
|
| WillChangeRecordset |
- |
|
| WillMove |
- |
|
4. Obiekt Record
| Właściwości |
| ActiveConnection |
- |
|
| Mode |
- |
|
| ParentURL |
- |
|
| RecordType |
- |
|
| Source |
- |
|
| State |
- |
|
| Metody |
| Cancel |
- |
|
| Close |
- |
|
| CopyRecord |
- |
|
| DeleteRecord |
- |
|
| GetChildren |
- |
|
| MoveRecord |
- |
|
| Open |
- |
|
5. Obiekt Stream
| Właściwości |
| Charset |
- |
|
| EOS |
- |
|
| LineSeparator |
- |
|
| Mode |
- |
|
| Position |
- |
|
| Size |
- |
|
| State |
- |
|
| Type |
- |
|
| Metody |
| Cancel |
- |
|
| Close |
- |
|
| CopyTo |
- |
|
| Flush |
- |
|
| LoadFromFile |
- |
|
| Open |
- |
|
| Read |
- |
|
| ReadText |
- |
|
| SaveToFile |
- |
|
| SetEOS |
- |
|
| SkipLine |
- |
|
| Write |
- |
|
| WriteText |
- |
|
6. Obiekt Error
| Właściwości |
| Description |
- |
|
| HelpContext/HelpFile |
- |
|
| NativeError |
- |
|
| Number |
- |
|
| Source |
- |
|
| SQLState |
- |
|
7. Obiekt Field
| Właściwości |
| ActualSize |
- |
|
| Attributes |
- |
|
| DefinedSize |
- |
|
| Name |
- |
|
| NumericScale |
- |
|
| OriginalValue |
- |
|
| Precision |
- |
|
| Status |
- |
|
| Type |
- |
|
| UnderlyingValue |
- |
|
| Value |
- |
|
| Metody |
| AppendChunk |
- |
|
| GetChunk |
- |
|
8. Obiekt Parameter
| Właściwości |
| Attributes |
- |
|
| Direction |
- |
|
| Name |
- |
|
| NumericScale |
- |
|
| Precision |
- |
|
| Size |
- |
|
| Type |
- |
|
| Value |
- |
|
| Metody |
| AppendChunk |
- |
|
9. Obiekt Property
| Właściwości |
| Attributes |
- |
|
| Name |
- |
|
| Type |
- |
|
| Value |
- |
|
Autor: Krzysztof Stelmach
Strona pochodzi z http://www.stelmach.info/
Ładowanie w toku ...
Ładowanie ...