ADO: Simple Hello World to Expertise ActiveX Data Objects in 7 Days: Master ADO in 7 Days by Divyah Bala
English | November 7, 2018 | ASIN: B07KB74WMT | AZW3 | 0.23 MB
English | November 7, 2018 | ASIN: B07KB74WMT | AZW3 | 0.23 MB
ADO is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components.
ADO example and best practice is covered in this book. This book provide complete developer reference for ADO.
You can start with Hello World kind of coding to become master within 7 days after reading this ActiveX Data Objects book.
What is ADO?
•ADO is a Microsoft technology
•ADO refers to ActiveX Data Objects ( A ctiveX D ata O bjects )
•ADO is a Microsoft Active-X component
•ADO will be installed automatically with Microsoft's IIS
•ADO is a programming interface for accessing data in a database
Access the database from an ASP page
The usual way to access a database from within an ASP page is:
1.Create an ADO connection to the database
2.Open database connection
3.Create an ADO Recordset
4.Extract the data you need from the recordset
5.Close the recordset
6.Close the connection
Learn ActiveX Data Objects in 7 Days
Introduction to ADO
What is ADO?
Access the database from an ASP page
ADO database connection
Create a DSN-less database connection
Create an ODBC database connection
ODBC connection to the MS Access database
ADO Connection Object
ADO Recordset
Create an ADO Table Recordset
Create an ADO SQL Recordset (ADO SQL Recordset)
Extract data from a recordset
ADO Recordset Object
ADO display
Display field names and field values
Display field names and field values in an HTML table
Add a title to an HTML table
ADO query
Instance
Display selected data
ADO sorting
Activex control
Instance
Sort data
ADO add record
Add records to a table in the database
Important matters
About no data fields
ADO update record
ODBC connection to the MS Access database
Update records in a database table
ADO delete record
Activexobject
Delete records in the table
ADO speeds up scripts with GetString()
Instance
Multi-line Response.Write
GetString() method
ADO Command object
Command object
ProgID
Attributes
method
set
ADO Connection object
Connection object
ProgID
Attributes
method
event
set
ADO Error object
Error object
grammar
Attributes
ADO Field Object
Field object
ProgID
Attributes
method
set
ADO Parameter object
Parameter object
Grammar
Attributes
method
ADO Property Object
Property object
ProgID
Attributes
ADO Record object
Record object (ADO version 2.5)
grammar
Attributes
method
set
The properties of the Fields collection
ADO Recordset Object
Instance
Recordset object
ProgID
Attributes
method
Event
set
The properties of the Fields collection
Properties of the Properties collection
ADO Stream Object
Stream object (ADO version 2.5)
grammar
Attributes
method
ADO Data Type
You have already learned ADO, what's next?
ADO overview
You have already learned ADO, what's next?
Example Code with output:
Code to display records in an HTML table
Search records with "Companyname" starting with A:
Show records with "Companyname" greater than E
Show only USA customers
Let users choose filters
Sort ascending according to the specified field name
Sort ascending according to the specified field name
Sort descending according to the specified field name
Let the user choose to sort by that column
Recordset object GetRows
Recordset object GetString
Introduction to ADO
What is ADO?
Access the database from an ASP page
ADO database connection
Create a DSN-less database connection
Create an ODBC database connection
ODBC connection to the MS Access database
ADO Connection Object
ADO Recordset
Create an ADO Table Recordset
Create an ADO SQL Recordset (ADO SQL Recordset)
Extract data from a recordset
ADO Recordset Object
ADO display
Display field names and field values
Display field names and field values in an HTML table
Add a title to an HTML table
ADO query
Instance
Display selected data
ADO sorting
Activex control
Instance
Sort data
ADO add record
Add records to a table in the database
Important matters
About no data fields
ADO update record
ODBC connection to the MS Access database
Update records in a database table
ADO delete record
Activexobject
Delete records in the table
ADO speeds up scripts with GetString()
Instance
Multi-line Response.Write
GetString() method
ADO Command object
Command object
ProgID
Attributes
method
set
ADO Connection object
Connection object
ProgID
Attributes
method
event
set
ADO Error object
Error object
grammar
Attributes
ADO Field Object
Field object
ProgID
Attributes
method
set
ADO Parameter object
Parameter object
Grammar
Attributes
method
ADO Property Object
Property object
ProgID
Attributes
ADO Record object
Record object (ADO version 2.5)
grammar
Attributes
method
set
The properties of the Fields collection
ADO Recordset Object
Instance
Recordset object
ProgID
Attributes
method
Event
set
The properties of the Fields collection
Properties of the Properties collection
ADO Stream Object
Stream object (ADO version 2.5)
grammar
Attributes
method
ADO Data Type
You have already learned ADO, what's next?
ADO overview
You have already learned ADO, what's next?
Example Code with output:
Code to display records in an HTML table
Search records with "Companyname" starting with A:
Show records with "Companyname" greater than E
Show only USA customers
Let users choose filters
Sort ascending according to the specified field name
Sort ascending according to the specified field name
Sort descending according to the specified field name
Let the user choose to sort by that column
Recordset object GetRows
Recordset object GetString