Index_E

E

e object

e As EventArgs, Button_Click event, 130

updating data, 293

Edit DataList Templates dialog, 332

Edit icon, Data Explorer, 231

Edit menu, main window, 31

Edit Stored Procedure dialog

pubs database, 231

Edit Table Design dialog

column order, 247

Edit Table dialog

* (asterisk) symbol, 250

deleting a column, 251

Discs table, 250

pubs database, 230

Editable Data Grid type, Data Pages template, 248

EditCommand event, 290

EditCommandField column, MxDataGrid control, 288

editing data

example using templates, 288

Editing toolbar, main window, 26

EditItemIndex property, MxDataGrid control, 290

EditItemTemplate type

templated column, list control, 285

EditText property

EditCommandField column, MxDataGrid control, 288

Else/ElseIf clauses

If...Then statement, 102

e-mail

function sending example, 122

using hyperlinks for e-mail, 367

encoding

< (less-than), 370

> (greater-than), 370

data passed on query string, 365

storing passwords, 443

Enterprise Manager, SQL Server

database access, 271

errata in this book, 6

ErrorMessage property

invalid controls, 87

RangeValidator control, 87

RegularExpressionValidator control, 205

RequiredFieldValidator control, 87

errors, 199

see also exceptions.

404 error, 215

File not found error, 353

guest book case study, 411

input errors, 200

missing pages error, 215

Permission denied error, 353

run-time errors, 202

semantic errors, 200

syntactic errors, 200

Errors property, Exception exception type, 210

escape characters

defining quotation marks (, 143

Eval method, DataBinder object, 286

events

Application_End event, 480

Application_Start event, 480

Click event, 90

e object, 293

EditCommand event, 290

event handlers, 130

event procedures, 47, 52

ItemCommand event, 295

Page_Load event, 91, 98, 359

SelectionChanged event handler, 107

server side events, 90

Session_End event, 477

Session_Start event, 477

Events icon, Properties window, 290

Page object, 310

Exception exception type, 209

properties and methods, 210

exceptions, 199, 209

see also errors.

connecting to a database, 207

example finding, 202

Try ... Catch statements, 207

types, 209

ExecuteNonQuery method, Command object, 303

guest book case study, 422

ExecuteReader method, Command object

executing SQL statement, 302

populating DataGrid, 309

Exit Do

exiting a loop early, 118

Exit For

exiting a loop early, 118

Expires property, HttpCookie object, 471