Build Your Own ASP.NET 3.5 Website Using C# & VB (118 page)

creating users,
580

Add New Field..., 473

ADO.NET,
348–349

addEmployeeButton for the ControlID,

and Generic Data Access,
349

646

built in protection against injection

adding a new item to a project, 195

attacks, 551

addition operator (+),
326

bulletproofing data access code, 368–

address book, 159
,
447–452

370

adding a new employee,
503
, 505,
508

creating the Dorknozzle Employee

code for
, 509–510

Directory,
376–415

displaying details about the selected

data source controls,
488–515

row,
463

defining the database connection,

displaying selected columns,
455

351–352

highlighting selected fields,
460

establishing link between database

in Design View
, 447

and application,
349

in DetailsView,
463,
465–467
,
476

executing the Command, 353–355

in GridView,
451

importing the SqlClient namespace,

350

Licensed to [email protected]

708

preparing the command, 352

using,
180–183

reading the data, 359–360

Application_AuthenticateRequest, 177

setting up database authentication,

Application_AuthorizeRequest,
177

356–358

Application_BeginRequest,
176

using parameters with queries,
360–

Application_End,
176

368

Application_EndRequest,
176

using the repeater control, 370–376

Application_Error
, 176

AdRotator control, 123–127,
659

Application_PreSendRequestContent,

benefits, 123

176

Advanced SQL Generation options, 500

Application_PreSendRequestHeaders,

Advanced... button, 500

176

aggregate functions,
333–338

Application_Start, 176

AJAX Extensions, 642,
694–696

arithmetic functions,
329–330

allowing user access, 563

arrays, 58–61

AllowPaging, 495,
526

and VB, 215

AllowSorting property
, 495
,
532

declaring, 60

ALTER PROCEDURE,
344

reading an element from,
60

AlternateText,
125

zero-based, 60

AlternatingItemStyle, 443

ASP.NET,
1
,
637

template,

access to functionality of .NET

372
,
421

Framework,
4

AND operator,
327

and client-side validation, 231

animation

as server-side technology,
2

ASP
.NET AJAX, 653–655

as technology for developing web ap
anonymous users, 563,
583
,
584
,
591

plications, 3

App_Data,
162

controls in,
97

appending text, 603

features,
4

AppendText method,
603,
604

help, 22

Application object, 178

reuse of common User Interface ele
application state, 178–187

ments, 5

difference from session state,
178

sending email with,
619–633

locking, 185

separation of server-side code from

objects in, 178,
180

HTML layout, 4

removing objects from,
179

support websire, 22

two users updating simuntaneously,

use of Microsoft .NET Framework,
4

185

validation controls, 649

two users updating with locks,
186

web forms, 635

Licensed to [email protected]

709

what is it?,
2–5

ASP.NET page,
26

ASP.NET 3.5 (
see
ASP.NET)

ASP
.NET server controls, 34

ASP.NET AJAX

code declaration blocks,
30–32

animation, 653–655

code render blocks, 33–34

Control T
oolkit, 648–655

compiling of,
4

help,
650

directives,
30,
41

library
, 637

elements,
27

managing ScriptManager control,
642–

encryption of view state data, 40

643

HTML tags, 36–37

server controls, 637

life cycle, 26

using trigger to update an UpdatePanliteral text,
36–37

el,
643–647

sample page, 29

using UpdatePanel control,
638–642

server
-side comments, 35–36

VaidatorCalloutExtender Control Extime display
, 19

tender
, 649–652

writing your first,
11–22

what is it?,
636–637

ASP.NET page structure,
26–37

ASP.NET Applications

ASP
.NET runtime, 26

Visual Web Developer Express,
698–

ASP.NET security
, 552–567

701

ASP
.NET server controls, 27
,
34

ASP
.NET Atlas, 637

advantages for ASP.NET developers,

ASP.NET configuration sections,
175

34

ASP.NET Deployment “Gotchas”,
701–

residence of, 34

702

view state,
34,
37–41

ASP.NET events,
46

ASP
.NET validation controls, 228–232

outputs, 55

enforcing validation on the server,

ASP.NET function

232–238

executing,
63

reserved space for,
237

ASP.NET Hosting Considerations,
697

using,
238–252

ASP
.NET languages, 42

ASP.NET web pages,
95–155

ASP.NET login controls (
see
login conadvanced controls,
117–133

trols)

list controls, 115–117

ASP.NET membership system,
567

master pages,
142–147

creating membership data structures,

server controls, 97–104

568–570

using CSS, 148–155

using your database to store member
web forms, 96–97

ship data,
570–575

web server controls, 104–115

ASP
.NET operators, 66

web user controls,
133–142

Licensed to [email protected]

710

ASP.NET Web Site Administration Tool,

AsyncPostBackT
riggers, 645

568
,
585

Attachment class, 619

Application tab,
577

AttachmentCollection class,
619

creating access rules, 584

Attachments (email messages),
620

Provider tab, 577

authenticating users, 557,
587–589

Security tab, 568,
569

authentication, 552

assigning the Users role, 582

forms,
553
,
554–567

Create user,
580

Passport, 553

creating access rules, 583–584

setting up database (ADO.NET),
356–

creating the administration account,

358

580

SQL Server
, 572

Enable Roles, 579

Windows,
553

to create an application setting, 578

W
indows Live ID, 553

ASP.NET Web Site Configuration Tool

authentication mode

Security tab, 576

attribute values,
555

Select authentication type link,
576

authentication ticket,
554
,
560

using, 576–579

authorization, 553

ASP.NET W
eb Site template, 160

authorization problems,
356

ASP.NET Web Sites

authorization section

deploying, 697–705

configuring, 555

asp: prefix,
105
,
106

Auto Format,
441

AutoFormat..., 454

adding,
598

AutoGenerateColumns,
453

giving write access to,
599

A
VG function, 337

aspnet_regsql.exe

customization, 573

B

using at the command prompt,
574

Back button,
637

ASPNETDB database,
568,
570

background (style property),
151

access to,
570

backslash (\) character

as User Instance database,
570

used inside a string,
352

important features,
570

banner advertisements, 123

ASPNETDB database files, 571

example, 124–127

AspNetSqlMembershipProvider
, 580

Bcc (email messages), 620

overriding default settings,
581

BETWEEN keyword,
317–318

.aspx files, 26,
41

BindData method, 528

Asynchronous JavaScript and XML, 636

BindGrid method, 448,
521

AsyncPostBack triggers,
646

modifying,
529–530

Licensed to [email protected]

711

to add a new department to a datacase sensitivty,
68

base, 544–545

code-behind files, 90

to apply sorting,
535–536

comments in, 31

BindList method,
427

data types, 56

bit data type,
275

declaring an array,
60

block, 152

do while loop,
72

Body (email message),
620

editing Default.aspx,
165

bool (C#), 56

equality operator
, 67

Boolean (VB),
56

file upload,
618

border,
152

for loop,
73

BoundField column,
454
,
458,
464,
479

HTML server controls in, 103

converted to T
emplateFields, 481

if else statement, 68

box, 152

operators, 66

breadcrumb navigation system,
129

page events,
53

break (C#), 74

selecting case, 69

breaking long lines of code,
67

semicolon to mark end of a command,

breakpoint,
216

67

Browse button, 615

simple button and label (code-behind

Browse With,
170

files), 90

browser

square brackets for arrays, 61

Internet Explorer
, 15

static method,
602

Build Style..., 198

subroutine components,
50

BulletedList control, 116,
659,
660

Visual Web Developer
, 165

BulletStyle property
, 117

C++, 42

Button control,
109–110,
232,
362,
364,

Cache object, 189–191

625

calendar

attributes,
46,
49

default,
119

events,
661

Calendar control, 117–122
,
148,
199

OnClick attribute,
559

events, 663

properties, 660

properties, 120,
661–663

button_Click routine, 48

user selection of days, weeks and

ButtonField column, 458,
459
,
460

months example,
121–122

call stack, 222

C

callouts,
651

C#,
4
,
16,
42,
43

Camel Casing,
105

as strongly-typed language,
57

Cancel button,
477

case sensitive, 18

Cancel Editing button,
433–434

Licensed to [email protected]

712

candidate key
, 278

importing namespaces into,
85

Cascading Style Sheets (CSS), 2,
148,

instantiating, 80

196
,
197,
199

methods,
78
,
79

template styles, 455

properties, 77

Case, 611

scope,
81

case sensitivity,
68

Click event, 46
,
48,
49,
109,
110
,
111
,