DALs (data access layers), 391
DAO (Data Access Objects), 18
data access layers (see DALs)
data adapter objects, ADO.NET, 212 Fill method, 212 InsertCommand property, 212 RefreshSchema method, 239 SelectCommand property, 239 Update method, 249 UpdateCommand property, 238
data binding, 25
Data Definition Language (see DDL)
data hiding, 322
Data Manipulation Language (see DML)
data providers (see .NET data providers)
data reader objects, ADO.NET, 134-35 Close method, 100 NextResult method, 381 performance, 379 Read method, 381
data sources, 59-93 multiple data sources, 146-50 text files, 12-13 XML, 13-14
data tiers, 24
database management systems (see DBMSs)
Database property, ADO.NET connection objects, 79
databases relationships, 96 schemas, 86-91
DataAdapter objects (see data adapter objects)
DataBind method, DataGrid controls, 242
DataBind method, Page class, 166
DataColumn class, ADO.NET, 159 ColumnName property, 145 DataType property, 154
data-driven web sites, 10-11
DataField attribute, BoundColumn controls, 167
DataFormatString attribute, BoundColumn controls, 168
DataGrid controls, 253-55 AllowPaging attribute, 179 AllowSorting attribute, 174 AutoGenerateColumns attribute, 167 BackColor property, 123 BorderColor property, 124 CancelCommand event, 244 CellPadding property, 124 CellSpacing property, 124 Columns subelement, 172 Current Page Index property, 183 DataBind method, 242 DataKeys property, 426 DataSource property, 413 DeleteCommand event, 253 EditCommand event, 244 EditItemIndex property, 424-25 Enabled property, 125 Font property, 124-25 ForeColor property, 123 HeaderStyle subelement, 218 ItemCreated event, 423 ItemStyle subelement, 218 OnDeleteCommand method, 424 OnPageIndexChanged attribute, 179 OnSortCommand attribute, 174 PageIndexChanged event, 179 PagerStyle subelement, 218 PageSize attribute, 179 UpdateCommand event, 245 Visible property, 125
DataGridConmandEventArgs class, 244
DataGridItem class Cells property, 246 FindControl method, 425 ItemIndex property, 244 ItemType property, 414
DataGridItemEventArgs class, 414
DataKeys property, DataGrid controls, 426
DataReader objects (see data reader objects)
DataRelation class, ADO.NET, 155-56 constructor, 156
DataRow class, ADO.NET, 350 AcceptChanges method, 238 Delete method, 249 GetChildRows method, 160 RejectChanges method, 249 RowState property, 249
DataRowCollection class, ADO.NET Add method, 212 Find method, 237 Remove method, 249
DataRowState enumeration, ADO.NET, 237
DataSet class, ADO.NET, 248-52 AcceptChanges method, 212 constructor, 137 creating a DataSet object, 137 GetChanges method, 212 GetXmlSchema method, 377 late bound DataSet objects, 377 performance, 381 ReadXml method, 225 Tables property, 141-42 typed DataSet objects, 377-79
datasets, ADO.NET (see also DataSet class), 20
DataSource property, ADO.NET connection objects, 79
DataSource property, DataGrid controls, 413
DataTable class, ADO.NET, 350 AcceptChanges method, 238 Columns property, 136 constructor, 137 creating a DataTable object, 137 NewRow method, 212 PrimaryKey property, 236 RejectChanges method, 249 Rows property, 237
DataTextField property, DropDownList controls, 193
DataTextField property, ListBox controls, 106-7
DataType property, ADO.NET DataColumn class, 154
DataValueField property, DropDownList controls, 193
DataValueField property, ListBox controls, 111
DataView class, ADO.NET, 194 Count property, 164 RowFilter property, 194 Sort property, 177-78
DateTime structure type, 362
DBMSs (database management systems), 33
DDL (Data Definition Language), 43
declarative languages, 39
DECLARE statements, SQL, 270-71
Delete method, ADO.NET DataRow class, 249
DELETE statements, SQL, 247-48 FROM keyword, 247 WHERE clauses, 247
DeleteCommand event, DataGrid controls, 253
deletion anomalies, 52
DESC keyword, SQL, 163
Desktop Engine (see MSDE)
Direction property, ADO.NET parameter objects, 279-80
DML (Data Manipulation Language), 43
documentation, class libraries, 358-59
DROP PROCEDURE statements, SQL, 269
DropDownList controls, 337 DataTextField property, 193 DataValueField property, 193 OnSelectedIndexChanged attribute, 192
durability, transactions, 299 |