C

Index
byJohn Kauffman, Fabio Claudio Ferracchiatiet al.?
Wrox Press ?2002

Calendar controls, 337

OnSelectionChanged event, 224

SelectedDate property, 184

SelectedDates property, 184

VisibleDate property, 184

CalendarSelectionMode enumeration, 184

CancelCommand event, DataGrid controls, 244

Catch blocks, 291

CellPadding property, DataGrid controls, 124

CellPadding property, RadioButtonList controls, 112

Cells property, DataGridItem class, 246

CellSpacing property, DataGrid controls, 124

CellSpacing property, RadioButtonList controls, 112

ChangeDatabase method, ADO.NET connection objects, 80

char data type, SQL, 271

CheckBoxList controls, 115-16

SelectedIndexChanged event, 121

child columns, ADO.NET, 155-56

choice elements, XSD, 152

class libraries, 320-56

compatibility, 356-57

complexity, 358

documentation, 358-59

Class Library projects, Visual Studio, 324

Class property, ADO.NET SqlException class, 295

Close method, ADO.NET connection objects, 362

Close method, ADO.NET data reader objects, 100

Codd's 12 rules (see also 40-43

code separation, 309-13

CodeBehind attribute, Page directives, 311

Collect method, GC class, 365

ColumnName property, ADO.NET DataColumn class, 145

Columns property, ADO.NET DataTable class, 136

Columns subelement, DataGrid controls, 172

columns, ADO.NET (see also 142

command builder objects, ADO.NET, 238

constructor, 238

command objects, ADO.NET, 231-35

CommandText property, 102-3

CommandType property, 97

constructor, 97

ExecuteNonQuery method, 268

ExecuteReader method, 346

ExecuteScalar method, 210

Parameters property, 283

CommandText property, ADO.NET command objects, 102-3

CommandType property, ADO.NET command objects, 97

Commit method, ADO.NET transaction objects, 305

COMMIT TRANSACTION statements, SQL, 300

CompareValidator controls, 206

compatibility, class libraries, 356-57

complexType elements, XSD, 152

componentization (see also class libraries), 319-59

encapsulation, 321-22

reuse, 322-23

compound keys, 54

configuration, web applications, 395

ConfigurationSettings class

AppSettings property, 92

connection objects, ADO.NET, 212

BeginTransaction method, 307

ChangeDatabase method, 80

Close method, 362

ConnectionString property, 80

ConnectionTimeout property, 80

constructor, 79

Database property, 79

DataSource property, 79

Open method, 79

PacketSize property, 80

Transaction property, 305

connection pooling, 362-68

OLE DB, 363

SQL Server, 363-67

connection strings, 93

Connection Timeout attribute, 369

ConnectionLifetime attribute, 367

ConnectionReset attribute, 368

Extended Properties attribute, 78

Max Pool Size attribute, 369

Min Pool Size attribute, 367

OLE DB Services attribute, 363

Packet Size attribute, 79-80

Pooling attribute, 365

Connection Timeout attribute, connection strings, 369

ConnectionLifetime connection attribute, 367

ConnectionReset connection attribute, 368

connections, 15-16

ADO, 61

ADO.NET, 59-86

ConnectionString property, ADO.NET connection objects, 80

ConnectionTimeout property, ADO.NET connection objects, 80

consistency, transactions, 299

controls, 103-5

custom controls, 26

data binding, 25

validation controls, 253

Controls property, TableCell class, 246

ControlToValidate attribute, RequiredFieldValidator controls, 208

Convert class, 184

Count property, ADO.NET DataView class, 164

CounterName property, PerformanceCounter class, 371

counters (see performance counters)

CREATE PROCEDURE statements, SQL, 269

CurrentPageIndex property, DataGrid controls, 183

custom controls, 26

CustomValidator controls, 206