D

Team Fly

Page 670

custom objects, in middle tier, 444

CustomValidator control, 283

D

Data Adapter Configuration Wizard, 394, 394

data binding, 36–37, 505–506

data display on WebForm, 273–283

connecting to database, 273–274

DataGrid control, 276–281

DataList control, 275

detecting postback, 281–282

Repeater control, 276

templates, 275

Data Encryption Standard (DES), 142, 143

encrypting and decrypting file with, 143–145

data entry, 216

to robust applications, 215

validation, 282

Data Link Properties dialog box, 392–393, 393

data types, 11–18

color as, 17–18

mixing in single stream, 55–56

strong typing and mismatch, 17

in WSDL, 332

in XML, 483–486

data validation, 225. See also validation

DataAdapter class (ADO.NET), 404–408

configuration, 393–394

for transactions, 432–440

Update method, 400, 404, 425, 428–430

database. See also ADO.NET

connection, 392–393

in client/server model, 442

immediate update of, 508

insert and update operations, 428–440

DataAdapter for transactions, 436–440

DataAdapter for updating, 428–430

Identity columns, 430–436

SQL connection to, 273–274

update frequency, 408

Web services connection to, 326–330

database server, 441

DataColumn objects, 415, 417

Data.DataException, 227

Data.DBConcurrencyException, 227

DataGrid control, 276–281

AlternatingBackColor property of, 281

AlternatingItemStyle property of, 281

appearance of, 278–280, 279

AutoGenerate Columns property, 280

binding DataSet to, 277–278, 396, 399

detecting postback, 281–282

formatting, 401–402

limitations, 505

on hierarchy display, 535

mouse and, 516

specifying behaviors, 278

DataList control (ASP.NET), 275

DataReader class (ADO.NET), 392, 412, 413–415

DataRelation objects, 421

DataRelations project, 422–424, 423

DataRow objects, 415, 417–418

DataRowState enumeration, 424, 425

DataRowVersion enumeration, 425

DataSet class (ADO.NET), 391–392

DataSets, 415–427

accessing tables, 416–417

adding and deleting rows, 419–420

binding to DataGrid control, 277–278, 396

converting to XML, 504, 504

converting XML to, 503, 504

creation, 395–396

DataViews, 426–427

editing with constraints, 421

HasErrors property of, 429

locating rows, 420–421

multiple tables for, 396–400

navigation, 421–426

null values, 418–419

to pass data between tiers, 444

rows, 417–418

typed vs. untyped, 416

updating database from, 400–402

viewing, 396

and XML, 493–495

DataSource property, for binding controls, 509

Data.SqlClientSqlException, 227

Data.SqlTypes.SqlTypeException, 227

DataTable objects, 415, 416–417

Team Fly