A
ActiveX Database Objects (ADO)
as component of MDAC 1.0, 121122
and programming ODBC applications, 125126
use Command object, 129
use Connection object, 127128
use Recordset object, 129
Add Connection dialog box, 187
Add Counter dialog box, 88
Add Table dialog box, 51, 53, 180
ADO. See ActiveX Database Objects (ADO)
ADO.NET
advantages of, 129
delete data from, 268271
evaluate errors in, 270271
insert data from, 249250
main components of database application connecting to SQL Server 2005 through, 11
and Microsoft Data Access Components (MDAC), 121
as native data provider, 1011
outline architecture, 130
programming ODBC applications, 125
understanding, 139
update data from, 284296
use ADO.NET Namespace, 130131
ADO.NET Command object, 249
ADO.NET Connection object, 249
ADO.NET Namespace, 130131
ALTER VIEW statement, 183
American National Standards Institute (ANSI), 146147, 151
ANSI. See American National Standards Institute (ANSI)
API. See Application program interface (API)
Application code. See Code
Application program interface (API), 123, 183
Approximate number datatypes, 103
Arithmetic, to update information, 275276
Attribute
add, 9495
defined, 92, 98
See also entries for specific types of attributes