ADO Code Examples in Microsoft Visual Basic Scripting Edition
Use the following code examples to learn about how to use the ADO objects, methods, and properties when writing in Visual Basic Scripting Edition (VBScript).
Note Paste the entire code example, from beginning to end, into your code editor. The example may not run correctly if partial examples are used or if paragraph formatting is lost.
Objects
Methods
- AddNew Method Example
- Cancel Method Example
- CancelUpdate Method Example
- Clone Method Example
- ConvertToString Method Example
- CreateObject Method and DataSpace Object Example
- CreateObject and Query Methods and DataFactory Object Example
- CreateRecordset Method Example
- Delete Method Example
- Execute, Requery, and Clear Methods Example
- Move Method Example
- MoveFirst, MoveLast, MoveNext, and MovePrevious Methods Example
- Open and Close Methods Example
- Query Method Example
- Refresh Method Example
- SubmitChanges Method Example
Properties
- Connect Property Example
- ExecuteOptions and FetchOptions Properties Example
- FilterColumn, FilterCriterion, FilterValue, SortColumn, and SortDirection Properties and Reset Method Example
- Recordset and SourceRecordset Properties Example
- ReadyState Property Example
- Server Property Example
- SQL Property Example
- URL Property Example