Editing ActiveX Data Objects (section)

== Basic usage ==
Some basic steps are required in order to be able to access and manipulate data using ADO :
#Create a connection object to connect to the database.
#Create a recordset object in order to receive data in.
#Open the connection
#Populate the recordset by opening it and passing the desired table name or SQL statement as a parameter to ''open'' function.
#Do all the desired searching/processing on the fetched data.
#Commit the changes you made to the data (if any) by using ''Update'' or ''UpdateBatch'' methods.
#Close the recordset
#Close the connection

=== ASP example ===

Here is an [[Active Server Pages|ASP]] example using ADO to select the "Name" field, from a table called "Phonebook", where a "PhoneNumber" was equal to "555-5555".

<syntaxhighlight lang="vbscript">
dim myconnection, myrecordset, name
set myconnection = server.createobject("ADODB.Connection")
set myrecordset = server.createobject("ADODB.Recordset")

myconnection.open mydatasource
myrecordset.open "Phonebook", myconnection 
myrecordset.find "PhoneNumber = '555-5555'"
name = myrecordset.fields.item("Name")
myrecordset.close

set myrecordset = nothing
set myconnection = nothing
</syntaxhighlight>

This is equivalent to the following ASP code, which uses plain SQL instead of the functionality of the Recordset object:
<syntaxhighlight lang="vbscript">
dim myconnection, myrecordset, name
set myconnection = server.createobject("ADODB.connection")
myconnection.open mydatasource
set myrecordset = myconnection.execute("SELECT Name FROM Phonebook WHERE PhoneNumber = '555-5555'")
name = myrecordset(0)
</syntaxhighlight>