Index_C

C

Calendar control

example using, 105

getting dates from user, 167

SelectionChanged event handler, 107

using LinkButton control within, 83

CAM (Cornflakes at Midnight) database

creating, 237

creating Tour Diary Page, 453

CancelText property

EditCommandField column, MxDataGrid, 288

capturing user information, 73

ListItem Collection Editor, 74

carriage return character

handling in browsers, 153

Case statement

see Select Case statement.

case studies

creating a guest book, 405

case-sensitivity

comparing strings, 150

CBool function, 169

CC, mailto: parameter, 369

CDate function, 169

converting text into dates, 165

Char data type, 240

ToCharArray method on String, 149

CheckBox control, 74

CheckBoxList control, 327

displayed in browser, 336

CInt function, 146, 169

string conversion, 48

Class Browser

help tracing and debugging, 221

classes

.NET Framework, 182, 194

creating custom class, 428

importing, 301

instances, 173

namespaces, 195

objects, 173

objects and classes, 195

proxy class, 490

using Class Browser to identify, 221

Classes tab, main window, 32

clauses

see also SQL statements.

ORDER BY, 259

WHERE, 254

Clear method

application state, 479

Session object, 478

Click event

see Button_Click event.

client-side scripting, 83

validation controls, 83

Close Connection icon, Data Explorer, 235

code

accessing data using, 299

adding code to Button control, 44

decision making, 98

defining a String, 142

downloading sample code, 5

functions described, 121

looping, 112

maintainability, 129

methods described, 121

nesting different structures, 131

procedures described, 121

readability, 129

sequence of events, 89

statelessness, 89

stepping through code, 217

step-wise refinement, 130

tracing, 212

Try ... Catch statements, 207

underscore, using in code, 107

using underscore at end of line, 107

code builders

toolbox, 32

wizards, 305

collections

see also ListItem Collection Editor.

array lists, 184

arrays, 178

hashtables, 190

SortedList collection, 193

System.Collections namespace, 194

Color class, System.Drawing namespace, 182

Column Properties section

Create New Table dialog, 244

columns

changing order of columns in table, 247

databases, 237

deleting, 251

modifying browser appearance, 276

selection in SELECT statement, 255

Command classes/objects, 302

@search parameter, 317

connecting DataAdapter to databases, 303

diagrammatic representation, 302

ExecuteNonQuery method, 303

ExecuteReader method, 302, 309

populating DataGrid, 309

selecting rows based on search string, 317

updating data, 303

command properties

SqlDataSourceControl control, 269

CommandArgument property

filtering Tour Diary Page, 463

CommandBuilder object

AutoGenerate properties, 269

CommandEventArgs property

filtering Tour Diary Page, 464

commands

SqlDataSourceControl control, 265

comments

' (apostrophe) symbol, 101, 260

<!-- ... -->, 216, 408

XML, 408

Community tab, 508

forums, 33

main window, 32

CompareValidator control, 206

comparing strings, 149

case-sensitivity, 150

compilation errors

see syntactic errors.

condition

If...Then statement, 101

configuration file

see web.config file. .

Connect to Database dialog, 229

Create a new database link, 239

populating DataGrid, 306

Connection classes/objects, 301

connecting DataAdapter to databases, 303

guest book case study, 409

populating DataGrid, 309

selecting rows based on search string, 317

connection strings, 270

example string generated, 271

guest book case study, 421

ConnectionString property, SqlDataSourceControl control, 268

Const keyword, 168

constants, 168

pi, 168

Container controls, 72, 403

Controls property, 403

continuing code, 107

Control Toolbox, main window, 26

ControlChars enumeration

guest book case study, 430

controls

aligning controls, 58

Button control, 79

Calendar control, 83, 167

CheckBox control, 74

CheckBoxList control, 327

CompareValidator control, 206

Container controls, 72, 403

copying existing controls, 49

CustomValidator control, 207

data binding, 278

data binding with list controls, 328

DataGrid control, 233, 328

controls (continued)

DataList control, 328

DropDownList control, 74, 327

grouping, 72

HyperLink control, 358, 386

ImageButton control, 79

invalid controls, 87

Label control, 58

LinkButton control, 79, 81

ListBox control, 328

loading controls at run-time, 400

MxDataGrid control, 272

naming conventions, 72

Panel control, 69

RadioButtonList control, 74, 327

RangeValidator control, 84, 206

RegularExpressionValidator control, 205

Repeater control, 328

RequiredFieldValidator control, 84, 87

reusable content, 383

selecting multiple items, 40

SqlDataSourceControl control, 233, 264

user control, creating, 385

using HTML or Server controls, 58

validation controls, 83

ValidationSummary control, 84, 87

Controls property, Container controls, 403

controls, HTML

anchor control, 344

Image control, 347

ControlToValidate property

RangeValidator control, 87

RegularExpressionValidator control, 205

RequiredFieldValidator control, 87

ConvertCRToBR

guest book case study, 423, 424

converting between data types, 169

Cookieless attribute, <sessionState> tag

cookies and state, 476

cookies, 469

adding to Guest book, 472

implementing, 470

limitations, 475

maintaining state, 475

security, 470

Server-side sessions, 475

Cookies property

HttpRequest class, 470

HttpResponse class, 470

Count property

application state, 479

Session object, 478

Create New Table dialog, 242

Column Properties section, 244

Discs table, 247

CREATE PROCEDURE statement, 259

Create Stored Procedure dialog, 256

credentials

Forms based authentication, 441, 443

credit cards

validating number, 159

validation formula, 161

CSS (Cascading StyleSheet)

format of CSS definition, 379

href attribute, 380

linking to, 376

rel attribute, 380

resource files, 374, 376

type attribute, 380

CStr function, 169

CType function

converting between data types, 172

updating data, 294

custom class

compiling, 431

creating data access tier, 455

guest book case study, 428

Custom Controls, toolbox, 32

customer support used in this book, 5

customErrors section, Web.Config template, 217

Customize Classic Start Menu

Administrative Tools menu, 526

Customize Start Menu

Administrative Tools menu, 527

CustomValidator control, 207