Index D

D

DAO technology, 18

data access capability, ADO.NET, 318-319

ADO data access vs., 319-321

programming, 366-377

with Access query and parameters, 375-377

with SQL string and parameter, 372-375

with SQL string and variable, 367-368

validating string variables , 368-371, 492-493

Data Access Object (DAO), 320

data access pages, 4

data adapters, 259, 267, 281. See also DataAdapter class; OleDbDataAdapter class

data connection, adding to Server Explorer, 54

data definition capability, ADO.NET, 318

Data Form Wizard, 251, 280-296

data manipulation with TextBox controls, 281-286

main/sub forms, 290-296

switchboard forms (example), 280

updatable data sources for DataGrid controls, 286-290

Web applications, 491

data manipulation, ADO.NET, 318, 319, 378-388

adding database tables, 381-383

creating Access databases, 379-380

DataAdapter and DataSet programming, 388-411

concurrency violations, 409-411

displaying dataset metadata and data, 394-398

graphically based datasets, 404-409

manipulating rows, 399-404

setting up OleDbDataAdapter, 390-394

design and operational views from Web pages, 512-516

forms authentication, 594-602

login page, creating, 596-599

secure Web pages, creating, 599-601

Web.config file, editing, 595-596

from Web pages, 512-523

within transactions, 383-388

data providers, ADO.NET, 19-20, 315

data security (cryptography), 574-575

data source assignment (forms), 269-280

Data Form Wizard, 251, 280-296

data manipulation with TextBox controls, 281-286

main/sub forms, 290-296

switchboard forms (example), 280

updatable data sources for DataGrid controls, 286-290

dynamically formatting DataGrid controls, 269-274

loading into DataGrid controls, 275-280

Data Source clause, connection strings, 361

data types, 44-45, 60-69

access modifiers, 73-74

compared to Access data types, 63-65

consolidating metadata with arrays, 99-102

creating custom, 66

data types, continued

default values for, 63

mapping .NET types to OleDbType enumeration, 372-373

Option Strict statement, 72-73

summary of, 60-63

translating from Access to .NET, 86-91

value vs. reference types, 65-69

DataAdapter class, 22, 317-319. See also data adapters; OleDbDataAdapter class

programming, 388-411

setting up for data manipulation, 390-394

Database property (Connection class), 356, 358

databases. See Access databases

DataBinding class, 450

DataBindings property (form controls), 259

DataColumn class, 345, 395

DataFormWizSamples project (example), 280-286

DataGrid controls in forms

data manipulation with Web forms, 512-516

deleting rows, 514

design view of Web page, 515-516

inserting rows, 512-513

updating rows, 513-514

dynamically formatting, 269-274

loading data sources into, 275-280

managing properties, 296-312

CurrentCell and CurrentRowIndex, 300-312

ReadOnly and AllowSorting, 296-300

roundtrips consideration with Web forms, 491

updatable data sources, 286-290

DataReader class, 21, 318-319. See also OleDbDataReader class

DataRelation class, 346, 432

adding relations between DataTables, 434

foreign key constraints, 442

DataRow class, 345, 452-458

DataSet class, 20, 22, 317

object model for, 344-353

programming, 388-411

concurrency violations, 409-411

displaying dataset metadata and data, 394-398

graphically based datasets, 404-409

manipulating rows, 399-404

typed and untyped datasets, 320

Dataset Designer, 404-409

creating datasets with two DataTables, 438-441

dragging tables or queries to, 417-418

DatasetForms project (example), 414-458

datasets, 414. See also DataTable class

created from two DataTable objects, 438-441

creating, 414-418

dragging tables or queries to forms, 415-416

from two DataTable objects, 427-428

custom initialization code, 420-421

Forms Designer code, understanding, 418-419

typed and untyped

computing child values (typed), 438-443

computing child values (untyped), 429-438

IntelliSense for typed schemas, 426-427

schemas for, 421-425

DataSource property (Connection class), 358

DataTable class, 344-346

browsing and manipulating data with forms, 443-458

browsing through rows, 452-453

deleting selected rows, 457

design and operational views (example), 444-445

form load event procedure, 447-452

inserting new rows, 454-456

updating rows, 458

concurrency violations, 409-411

creating and using datasets, 414-428

custom initialization code, 420-421

datasets from two DataTable objects, 427-428, 438-441

Forms Designer code, understanding, 418-419

typed and untyped, schemas for, 421-425

typed schemas, IntelliSense for, 426-427

displaying dataset metadata and data, 394-398

foreign key constraints, 440-443

graphically based datasets, 404-409

manipulating rows, 399-404, 512-514

parent-child relationships, 429-443

adding relations between DataTables, 434

computing child values, typed dataset, 438-443

computing child values, untyped dataset, 429-438

XML schemas for, 617-622

primary key for, 393, 395, 401

DataTableCollection property (DataSet class), 396

DataView class, 457

Date data type, 61, 62

Date type (OleDbType), 373

DateTime data type (Access), 63, 64

DaysTilEOM project (example), 539-548

building client application

on another workstation, 548-549

on localhost, 544-548

deploying, 550-551

Internet-based client for, 554

DbConcurrencyException class, 409

Decimal data type, 61, 62

Decimal data type (Access), 64

Decimal type (OleDbType), 373

declarations, public and private, 39

default data type values, 63

delegates, 10

delegates (procedures that handle events), 147

Delete( ) (FileInfo class), 146

Delete( ) (OleDbDataAdapter class), 401

DeleteCommand property (OleDbDataAdapter class), 338, 392, 448-450

deleting DataTable rows with forms, 457

deleting rows from local datasets, 401-402, 406-409, 514

deploying Web services, 549-554

derived classes, 16, 48-49, 163

Description setting (WebService class attribute), 541

Design view, Web forms (example), 466

design views of Web forms (example)

graphically created ADO.NET objects, 499-502

insert, update, and delete operations, 515-516

programmatically created ADO.NET objects, 507-508

design views of Web services (example), 533-534, 546

design views of Windows forms (example), 444-445

DesktopLocation property (form controls), 202

Dim statement, 94, 418

Directory class, 130, 135-137

DirectoryInfo class, 131, 132-135

disabling Close control (forms), 204-209

disconnected datasets, 259

displaying binary files, 137-141

DisplayMember property (ComboBox control), 267

Dispose procedure (Form Designer region), 195-197

DOCUMENT Property Pages dialog, 467

Do... Loop statements, 79

Double data type, 61

Double data type (Access), 64

Double type (OleDbType), 373

dynamic assemblies, 13

dynamically formatting DataGrid controls, 269-274