AcceptChanges method, ADO.NET DataRow class, 238
AcceptChanges method, ADO.NET DataSet class, 212
AcceptChanges method, ADO.NET DataTable class, 238
Access (Microsoft), 70-73 JET data engine, 70
ACID acronym, transactions, 299
Active Directory, 14
Add method, ADO.NET DataRelationCollection class, 156
Add method, ADO.NET DataRowCollection class, 212
Add method, ADO.NET DataTableCollection class, 141
Add method, AttributeCollection class, 414
Add Reference dialog, Visual Studio .NET, 332
AddRange method, ArrayList class, 329
ADO, 18 connections, 61 Recordset objects, 377
ADO.NET, 339 columns (see also 142 command builder objects, 238 command objects, 231-35 connection objects, 212 connections, 59-86 data adapter objects, 212 data reader objects, 379 DataColumn class, 159 DataRelation class, 155-56 DataRow class, 350 DataSet class, 381 typed DataSet objects, 377-79 datasets (see also 20 DataTable class, 350 DataView class, 194 rows (see also 142 SqlException class, 294-97 tables (see also DataTable class), 141-42 transaction objects, 307-8 transactions, 304-9
aliasing, SQL, 128
AllowPaging attribute, DataGrid controls, 179
AllowSorting attribute, DataGrid controls, 174
ALTER PROCEDURE statements, SQL, 269
AlternatingItemStyle subelements, DataGrid controls BackColor attribute, 192
application architecture, 22-26
appSettings element, web.config file, 92
AppSettings property, ConfigurationSettings class, 92
architecture (see application architecture)
arguments, stored procedures (see parameters)
ArrayList class, 328 AddRange method, 329 Sort method, 329
AS keyword, SQL, 128-29
ASC keyword, SQL, 163
atomic data, 53
atomicity, SQL stored procedures, 260
atomicity, transactions, 299
Auction site (see Wrox Auction site)
AutoEventWireup attribute, Page directives, 311
AutoGenerateColumns attribute, DataGrid controls, 167
auto-Increment fields, 200
auto-Increment primary keys, 200-201
AutoPostBack attribute, ListBox controls, 106 |