parser errors, 210
partial classes, 91–92
usage, 92
Pascal Casing, 101
Passport accounts, 531
Passport authentication, 531
password confirmation text box, 226
password strength requirements
changing, 556–558
PasswordRecovery control, 562
passwords, 536
default security, 556
encryption, 529
hashing, 542–543
verification, 537
passwordStrengthRegularExpression,
558
PasswordTextBox control, 227, 230,
232
path attribute, 538
Path class, 573, 586, 588, 589
permissions
reading and writing text files, 573–
575
persistent cookies, 184
physical design (database), 258
Place code in separate file checkbox,
196, 199, 202, 334, 360
PlaceHolder control, 109, 625
PolygonHotSpot control, 108
populating data tables, 272–275
positioning, 139
post back, 369
PostedFile property, 590
POWER function, 315
primary keys, 265–267, 278
and IDENTITY property, 267
as constraints, 266
setting columns as, 268
Private (access modifier), 83
Private (VB), 55
properties
defining, 513
properties (class), 79, 81
properties (object), 77, 81
Properties dialog
options, 19
Properties window, 155–156, 289,
409, 444, 463, 477, 504
colour setting, 156
Property Builder, 424
Protected (access modifier), 83
protection attribute, 538
Public (access modifier), 83
public (C#), 55
Public (VB), 55
public interface, 84
Q
queries, 294
executing, 296
limiting the number of results with
TOP, 307
matching patterns with LIKE, 304–
305
multiple tables, 309
row filtering with WHERE, 302–303
SELECT statement, 297–299
selecting certain fields, 299–300
selecting ranges of values with
BETWEEN, 303–304
selecting unique data with DIS-
TINCT, 300–302
sorting results using ORDER BY,
306–307
table joins, 309–310
using parameters with, 344–350
using the IN operator, 305–306
query window, 296
question mark symbol ("?"), 533, 540
679