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 |