切换导航
AspRain.cn
给站长打赏
收听我
@樊潇洁2
@fanxiaojie1
@樊潇洁
订阅本站 RSS
给我写信
留言版
所有资料
服务器端组件
jQuery参考
JavaScript库
HTML5参考
SVG &Canvas参考
CSS & Less学习
数据库 & 开发工具
ActiveX Data Objects
ADO Fundamentals
ADO Objects and Collections
HelloData: A Simple ADO Application
OLE DB Providers
Errors
Getting Data
Connecting to Data Sources
Preparing and Executing Commands
Receiving Results
Examining Data
Current Record and Size of Recordset
Sample Recordset for Examining Data
Boundaries of a Recordset
Navigating Through Data
Understanding Recordset Structure
Editing Data
Editing Existing Records
Adding Records
Determining What is Supported
Deleting Records Using the Delete Method
Alternatives: Using SQL Statements
Updating and Persisting Data
Updating Data
Persisting Data
Error Handling
ADO Errors
Provider Errors
Field-Related Error Information
Recordset-Related Error Information
Handling Errors In Other Languages
Anticipating Errors
Handling ADO Events
ADO Event Handler Summary
Types of Events
Event Parameters
How Event Handlers Work Together
ADO Event Instantiation by Language
Understanding Cursors and Locks
What is a Cursor?
Types of Cursors
The Significance of Cursor Location
The Microsoft Cursor Service for OLE DB
What is a Lock?
Using CacheSize
Cursor and Lock Characteristics
Data Shaping
Data Shaping Overview
Data Shaping Example
Reshaping
Grandchild Aggregates
Parameterized Commands with Intervening COMPUTE Commands
Persisting Hierarchical Recordsets
Required Providers for Data Shaping
Shape Commands in General
Shape APPEND Clause
Shape COMPUTE Clause
Fabricating Hierarchical Recordsets
Accessing Rows in a Hierarchical Recordset
Formal Shape Grammar
Visual Basic for Applications functions
Records and Streams
Streams and Persistence
Command Streams
Retrieving Resultsets into Streams
Using ADO for Internet Publishing
ADO Object Model
ADO Objects and Interfaces
ADORecordsetConstruction Interface
ADORecordConstruction Interface
ADOStreamConstruction Interface
Command Object
Connection Object
IDSOShapeExtensions Interface
Error Object
Field Object
Parameter Object
Property Object
Record Object
Recordset Object
Stream Object
ADO Events
BeginTransComplete, CommitTransComplete, and RollbackTransComplete Events
ConnectComplete and Disconnect Events
EndOfRecordset Event
ExecuteComplete Event
FetchComplete Event
FetchProgress Event
InfoMessage Event
WillChangeField and FieldChangeComplete Events
WillChangeRecord and RecordChangeComplete Events
WillChangeRecordset and RecordsetChangeComplete Events
WillConnect Event
WillExecute Event
WillMove and MoveComplete Events
ADO Collections
Errors Collection
Fields Collection
Parameters Collection
Properties Collection
ADO Properties
AbsolutePage Property
AbsolutePosition Property
ActiveCommand Property
ActiveConnection Property
ActualSize Property
Attributes Property
BOF, EOF Properties
Bookmark Property
CacheSize Property
Chapter Property
Charset Property
CommandStream Property
CommandText Property
CommandTimeout Property
CommandType Property
ConnectionString Property
ConnectionTimeout Property
Count Property
CursorLocation Property
CursorType Property
DataMember Property
DefaultDatabase Property
DefinedSize Property
Description Property
Dialect Property
DataSource Property
Direction Property
EditMode Property
EOS Property
Filter Property
HelpContext, HelpFile Properties
Index Property
IsolationLevel Property
Item Property
LineSeparator Property
LockType Property
MarshalOptions Property
MaxRecords Property
Mode Property
Name Property
NamedParameters Property
NativeError Property
Number Property
NumericScale Property
OriginalValue Property
PageCount Property
PageSize Property
ParentRow Property
ParentURL Property
Position Property
Precision Property
Prepared Property
Provider Property
RecordCount Property
RecordType Property
Row Property
RowPosition Property
Rowset Property
Size Property (Parameter)
Size Property (Stream)
Sort Property
Source Property (Error)
Source Property (Record)
Source Property (Recordset)
SQLState Property
Status Property (Field)
Status Property (Recordset)
StayInSync Property
State Property
Stream Property
Type Property
Type Property (Stream)
UnderlyingValue Property
Value Property
Version Property
ADO Dynamic Properties
ADO Dynamic Property Index
Optimize Property-Dynamic
Prompt Property-Dynamic
Reshape Name Property-Dynamic
Resync Command Property-Dynamic
Unique Table, Unique Schema, Unique Catalog Properties-Dynamic
Update Resync Property-Dynamic
ADO Methods
AddNew Method
Append Method
AppendChunk Method
BeginTrans, CommitTrans, and RollbackTrans Methods
Cancel Method
CancelBatch Method
CancelUpdate Method
Clear Method
Clone Method
Close Method
CompareBookmarks Method
CopyRecord Method
CopyTo Method
CreateParameter Method
Delete Method 方法(Parameters Collection)
Delete Method 方法(Fields Collection)
Delete Method 方法(Recordset)
DeleteRecord Method
Execute Method 方法(Command)
Execute Method 方法(Connection)
Find Method
Flush Method
get_OLEDBCommand Method
GetChildren Method
GetChunk Method
GetDataProviderDSO Method
GetRows Method
GetString Method
LoadFromFile Method
Move Method
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods
MoveRecord Method
NextRecordset Method
Open Method 方法(Connection)
Open Method 方法(Record)
Open Method 方法(Recordset)
Open Method 方法(Stream)
OpenSchema Method
put_OLEDBCommand Method
Read Method
ReadText Method
Refresh Method
Requery Method
Resync Method
Save Method
SaveToFile Method
Seek Method
SetEOS Method
SkipLine Method
Stat Method
Supports Method
Update Method
UpdateBatch Method
Write Method
WriteText Method
ADO Enumerated Constants
ADCPROP_ASYNCTHREADPRIORITY_ENUM
ADCPROP_AUTORECALC_ENUM
ADCPROP_UPDATECRITERIA_ENUM
ADCPROP_UPDATERESYNC_ENUM
AffectEnum
BookmarkEnum
CommandTypeEnum
CompareEnum
ConnectModeEnum
ConnectOptionEnum
ConnectPromptEnum
CopyRecordOptionsEnum
CursorLocationEnum
CursorOptionEnum
CursorTypeEnum
DataTypeEnum
EditModeEnum
ErrorValueEnum
EventReasonEnum
EventStatusEnum
ExecuteOptionEnum
FieldEnum
FieldAttributeEnum
FieldStatusEnum
FilterGroupEnum
GetRowsOptionEnum
IsolationLevelEnum
LineSeparatorsEnum
LockTypeEnum
MarshalOptionsEnum
MoveRecordOptionsEnum
ObjectStateEnum
ParameterAttributesEnum
ParameterDirectionEnum
PersistFormatEnum
PositionEnum
PropertyAttributesEnum
RecordCreateOptionsEnum
RecordOpenOptionsEnum
RecordStatusEnum
RecordTypeEnum
ResyncEnum
SaveOptionsEnum
SchemaEnum
SearchDirectionEnum
SeekEnum
StreamOpenOptionsEnum
StreamReadEnum
StreamTypeEnum
StreamWriteEnum
StringFormatEnum
XactAttributeEnum
ADO Syntax Indexes
ADO Code Examples
AddNew Method Example (VBScript)
Clone Method Example (VBScript)
Delete Method Example (VBScript)
Execute, Requery, and Clear Methods Example (VBScript)
Move Method Example (VBScript)
MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example (VBScript)
Open and Close Methods Example (VBScript)
Appendix A: Providers
Appendix B: ADO Errors
网站首页
服务器端组件
ActiveX Data Objects
ADO Objects and Interfaces
Stream Object
创建于
2019-6-5
更新于
2019-6-5
753次浏览
催站长更新
上一页：Appendix C: Schema Rowsets
下一页：没有了
我要揪错
如果你喜欢这篇文章，敬请给站长打赏↑
除特别注明外，本站所有文章均为
本站站长
原译，转载请注明出处。
网站首页
服务器端组件
ActiveX Data Objects
ADO Objects and Interfaces
Stream Object
