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

Read Build Your Own ASP.NET 3.5 Website Using C# & VB Online

Authors: Cristian Darie,Zak Ruvalcaba,Wyatt Barnett

Tags: #C♯ (Computer program language), #Active server pages, #Programming Languages, #C#, #Web Page Design, #Computers, #Web site development, #internet programming, #General, #C? (Computer program language), #Internet, #Visual BASIC, #Microsoft Visual BASIC, #Application Development, #Microsoft .NET Framework

BOOK: Build Your Own ASP.NET 3.5 Website Using C# & VB
10.36Mb size Format: txt, pdf, ePub

K

LocalSqlServer,
570

keys,
278

connection to a disconnected data
Keyword, 125

base,
574

KeywordFilter property,
125

connection to your database,
575

definition in machine.config,
574

L

Location drop-down,
161

Label control,
101,
103,
107–108
,
180,

lock application state,
185

359,
479,
605–606
,
613,
614,
625,

Log In button, 254

668

logged-in user

documentation,
107

checking status of,
593

Text property,
108

LoggedInT
emplate, 592

Label web server control, 105

logging users out, 567

LabelText property,
136
,
138

logical design (database),
270,
273

language attribute,
30,
32

Login control, 586

Language box, 160

login controls,
568,
586–587

languages, 42

authenticating users, 587–589

strongly typed,
57

customizing user display,
589–593

Lanugage drop-down list,
202

options for
, 588

LEN function, 331

using,
588

lenght of string function,
331

login credentials, 564

less-than operator (<), 326

validation, 559

less-than ot equal-to operator (<=),
327

login failed error
, 356

LIKE keyword,
318–319

Login link,
591

LIKE operator,
327

login page,
589

LinikButton control,
668

configuring the authentication mode,

LinkButton,
424
,
428

555

LinkButton control, 111

configuring the authorizatoin section,

list (style property), 152

555

list controls,
115–117

construction, 554–557

ListBox control,
105,
115,
669

creating the,
557–558

Literal control,
108,
424,
429
,
670

example,
560

setting its contents,
429

for hard-coded user accounts, 558–560

Text property,
108

naming, 557

Login tab, 568

Licensed to [email protected]

726

login web form

example, 143
,
146

and validation groups,
252

using,
147

checking uniqueness of login, 249

MAX function,
337

creating,
229

MaximumValue poperty
, 244

list of error messages, 244

membership data

username field,
247

storage using your database, 570–575

validating data in password fields,
240

membership data structures, 568–570

Login.aspx, 229,
240
,
243
,
244

membership system, 567

LoginName control,
586
,
592

login controls,
568

LoginStatus control, 586,
591
,
592

membership tables, 576

loginUrl attribute, 561

Menu control,
131
,
204

LoginV
alidationGrouo, 255

events,
690

LoginV
iew control, 586,
591
,
592

methods,
690

Logout link, 591,
592

properties, 685–690

loops, 69–75

Message property
, 225

LOWER function,
330

messageLabel object, 92

lowercase,
330

methods (class),
78,
79

L
TRIM function, 330

methods (object),
76

Microsoft

M

V
isual Studio line, 166

machine.config file,
574
,
580

Microsoft .NET Framework (
see
.Net

overriding settings,
172

Framework)

MailAddress class, 619

Microsoft AJAX Library,
637

MailAddressCollection class, 619
,
620

Microsoft Passport accounts, 554

MailMessage class,
619
,
629

Microsoft SQL Server,
267

proerties supported, 619

Microsoft SQL Server Database Publishmany-to-many relationships,
304–305

ing Wizard,
703

MapPath method, 603,
604

MIN function,
337

mapping tables, 304

MinimumValue property,
244

master page

MOD function,
329

building, 202–205

ModeChanging event,
474

editing a web form that uses a,
209

Modify
, 283

using, 205–208

money data type,
275
,
276

master page files,
143

MONTH function,
333

Master Page template, 202

mulitple tables

master pages, 97
,
142–148,
589

querying

differences from web forms,
146

using table joins,
323–325

Licensed to [email protected]

727

multi-column keys, 279

new database

multiple character operator (% or *),
328

creating using SQL Server Managemultiple projects

ment Studio, 268–269

working with, 257

creating using Visual Web Developer,

multiple tables

267

querying,
323

New Databases...,
269

using subqueries,
323

New Query button,
285
,
309,
414

reading data from,
322–325

newsletter page, 159

multiplication operator (*),
326

creating, 623–633

MultiView control,
131–132

"No file uploaded!" error message, 618

example, 131

None mode (validation),
237

Multiview control,
670

normalization (database),
274

mySubName (...), 51

not equal to operator (<> or !=), 327

NOT operator
, 327

N

Nothing,
190

name attribute, 561

null,
183
,
190

named skin,
200

NULL property (columns),
276
,
277

namespace references, 173

and default values, 278

namespaces, 85

numbers

importing,
85

(
see also
integers)

NavigateURL,
125

converting to strings,
65

NavigateUrl property,
111

nvarchar (n),
363

navigation web controls, 684–694

nvarchar (n) data type,
275

nchar (n) data type, 276

.NET

O

objects in, 83–85

Object (data type),
56

.NET Framework,
4

Object class, 84

availability
, 5

public members,
84

languages supported,
4

Object Explorer,
309

.NET Framework SDK Documentation,

Security > Logins node,
356

107

T
ables node, 283

.NET Framework Class Library,
85

object IDs

new condition

naming using Camel Casing,
105

creating, 500

object oriented programming, 75

New Connection... button, 492

classes, 76
,
77
,
80

constructors, 80

events, 82

Licensed to [email protected]

728

inheritance,
82

OOP (
see
object oriented programming)

methods,
79

Open T
able Definition, 283

objects,
75
,
77

OpenText method,
604,
606

properties,
78

operators, 65–67

Rayne (dog) example, 77–80

definition, 65

scope, 81–82

to break long lines of code, 67

Object s (C#),
51

to combine lines of code,
67

ObjectDataSource object,
489

operators (SQL),
326–328

objects

OR operator,
327

behaviour,
76

OracleCommand,
349

declaring, 77

OracleConnection, 349

definition,
76

ORDER BY clause

disposal,
602

for sorting query results,
320–321

events,
76,
82

specifying,
493

fields,
76

ORDER BY... button,
494

in .NET,
83–85

out parameters,
366

methods,
76

overwriting text,
603

properties,
76

state, 76

P

ODBC interface, 349

page

OleDbCommand, 349

definition, 51

OleDbConnection,
349

Page class,
97

OnCheckChanged attribute, 111

documentation,
84

OnClick attribute,
46,
48,
49
,
109

page counter,
188

OnClick property,
232
,
260

page counters,
180–187

OnCommand attribute, 49

Page directive,
30
,
41,
89
,
146

OnDataBinding attribute, 50

page events,
51–54

OnDisposed attribute, 49

order of execution, 52

one-to-many relationships,
302–304

subroutines, 52

one-to-one relationship,
301

page templates,
143–148

OnInit attribute,
49

Page.IsValid property
, 234,
235
, 252,
255

OnItemUpdating property,
491

Page_Init event,
52

OnLoad attribute,
49

Page_Load event, 52
,
54

OnModeChanging property
, 491

Page_Load event handler,
63

OnPreRender attribute,
49

Page_Load method, 187,
352
,
378
,
382,

OnSelectedIndexChanged property
, 491

383,
386,
426
,
448

Page_PreRender event, 52

Licensed to [email protected]

729

Page_UnLoad event,
52

permissions

PageIndex property
, 527

reading and writing text files, 597–599

PageIndexChanging event,
526

persistent cookies,
191

PageIndexChanging event handler,
526

physical design (database), 270

PagerStyle,
496

Place code in separate file checkbox,

pages element, 201

202,
206
,
210
,
350,
376

PageSize,
495

PlaceHolder control, 113,
671

paging,
498,
525–527

PolygonHotSpot control, 112

paging buttons, 496

populating data tables, 286–289

Panel control,
114–115,
131,
671

positioning,
152

parameters,
363

post back,
386

in functions and subroutines,
64

PostBackTriggers,
645

out, 366

PostedFile property,
616

use with queries,
360–368

POWER function,
330

parent tag,
371

primary keys,
278–280,
291

parser errors, 218

and IDENTITY property,
280

partial classes

as constraints, 279

usage,
92

setting columns as,
281

Pascal Casing,
105

Private (access modifier), 81

Passport accounts,
554

Private (VB), 50

Passport authentication,
553

productList,
72

password

programming language, preferred, 160

SQL Server
, 356

emplate> tags, 641

password confirmation text box,
236

properties

password strength requirements

Other books

Whispers Beyond the Veil by Jessica Estevao
His For Christmas by Kinsley Gibb
RISK by Deborah Bladon
Barbara's Plea by Stacy Eaton, Dominque Agnew
Divine Grace by Heather Rainier
It's All Good by Nikki Carter
The Mission War by Wesley Ellis
Brought to Book by Anthea Fraser