Index

S

\S character class, 367

\s character class, 367

sample Default.aspx page, creating, 36–37

Sams Press (Teach Yourself Regular Expressions in 24 Hours), 366

Sandbox test environment, 428–429

SandboxMode property, 432

screen readers and site layout design, 14

screen-scraping, 183

script callback, 343

scripting-based attacks, 201

second theme for TheBeerHouse project, creating, 37–38

Secure Sockets Layer (SSL), 424

security

Administrator role, 208

Contributor role, 208

Editor role, 208

forums, 418–419

and news and article management, 207–208

programmatic security, 135–137

roles used for protecting pages and functions against unauthorized access, 135–138

settings, configuring, 280

Web Site Administration Tool, 142

SendingNewsletter.aspx page, 371–374

SendNewsletter.aspx page, 368–371

server and long operations management

asynchronous page processing, 346–347

background threads, 338–342

overview, 337–338

partial page updates with script callbacks, 342–346

Services Without Components (SWC) transactions, 71–73

shipping property, 428

ShoppingCart.ascx user control, 470–472

ShoppingCart.aspx page, 457–467

ShowArchiveLink property, 293

ShowArticle.aspx page, 268–274

ShowArticle.aspx.cs code-behind file, 271–274

ShowCategories.aspx page, 265–267

ShowCategoryPicker property, 205

ShowHeader property, 293

ShowNewsletter.aspx page, 376–378

ShowPageSizePicker property, 205

ShowProduct.aspx page, 454–457

ShowQuestion property, 293

ShowThread.aspx page, 413–417

SilverPosterDescription property, 391

SilverPosterPosts property, 391

SimpleMailWebEventProvider class, 77

single page, applying theme to, 20

site design for TheBeerHouse project

first theme, 33–36

overview, 27–29

master page creation, 30–32

sample Default.aspx page, 36–37

second theme, 37–38

site map file creation, 32–33

style, adding, 42–45

ThemeSelector user control, 38–42

site layout design

accessibility, 24–25

approval of, 10

common behavior shared among all pages, 25–26

common design shared among multiple pages, 15–19

CSS used to define styles in stylesheet

files, 11–13

HTML and, 10

HTML tables and, 13–14

loading speed and, 14

mock-ups, 9–10

navigation system, 22–24

overview, 9–10

partial classes and, 10

PollBox.ascx user control plugging into, 324

screen readers and, 14

technologies used to implement, 10–11

user-selectable themes, creating a set of, 19–22

site map file

for TheBeerHouse project, creating, 32–33

defining, 22–23

SiteProvider class, 228

skin files, 19–22

skinning, 7

sorting comments, 201–202

spam, 333–334

SpecifiedPickupDirectory delivery method, 335

SQL dependency support, 63

SQL Server 2005

deploying the site

creating standard ASP.NET objects, 528

database objects, scripting, 529–531

existing data, importing, 531–536

overview, 526–528

providers pointing to SQL Server 2005, 536

overview, 50

SQL Server 2005 Express Edition

overview, 50–51

XCopy deployment, 51

SQL Server Management Studio Express, 64

SQL Server Management Studio (SSMS), 526, 528

SQL Server 2005-specific SQL dependency support, 66–69

SQL text queries, 56–57

SqlArticlesProvider class, 223–228

SqlDataSource control, 85–91

SqlMembershipProvider, 120–126

SqlMembershipProvider class

applicationName attribute, 122

connectionStringName attribute, 122

default SQL Server data store, 124–126

description attribute, 123

enablePasswordReset attribute, 123

enablePasswordRetrieval attribute, 123

maxInvalidPasswordAttempts attribute, 123

minRequiredNonalphanumericCharacters attribute, 123

minRequiredPasswordLength attribute, 123

name attribute, 123

overview, 120–122

passwordAttemptWindow attribute, 123

passwordFormat attribute, 123

passwordStrengthRegularExpression attribute, 123

requiresQuestionAndAnswer attribute, 123

requiresUniqueEmail attribute, 123

SqlWebEventProvider class, 77

SSL (Secure Sockets Layer), 424

State property, 198

static content, 516

stored procedures

creating, 210–216

database tables, 210–216

e-commerce store, 429–431

executing, 224

forums, 388–390

managing database content, 191–193

newsletters, 348–349

overview, 56–57

tbh_Articles_ApproveArticle procedure, 191, 212

tbh_Articles_DeleteArticle procedure, 191, 212

tbh_Articles_DeleteCategory procedure, 191

tbh_Articles_DeleteComment procedure, 191

tbh_Articles_GetArticleByID procedure, 191, 213

tbh_Articles_GetArticleCount procedure, 191, 215

tbh_Articles_GetArticleCountBy Category procedure, 191

tbh_Articles_GetArticles procedure, 191, 213–215

tbh_Articles_GetArticlesByCategory procedure, 191

tbh_Articles_GetCategories procedure, 191

tbh_Articles_GetCategoriesByID procedure, 191

tbh_Articles_GetCommentByID procedure, 191

tbh_Articles_GetCommentCount procedure, 192

tbh_Articles_GetCommentCountBy Article procedure, 192

tbh_Articles_GetComments procedure, 192

tbh_Articles_GetCommentsByArticle procedure, 192

tbh_Articles_GetPublishedArticleCount procedure, 192

tbh_Articles_GetPublishedArticleCountByCategory procedure, 192, 216

tbh_Articles_GetPublishedArticles procedure, 192

tbh_Articles_GetPublishedArticlesByCategory procedure, 192, 215–216

tbh_Articles_IncrementViewCount procedure, 192, 212

tbh_Articles_InsertArticle procedure, 192, 210–211

tbh_Articles_InsertCategory procedure, 192

tbh_Articles_InsertComment procedure, 192

tbh_Articles_InsertVote procedure, 192, 212

tbh_Articles_UpdateArticle procedure, 192, 211

tbh_Articles_UpdateCategory procedure, 192

tbh_Articles_UpdateComment procedure, 192

Storekeeper role, 437

strategies for caching, 69

stylesheet files, using CSS to define styles in, 11–13

sub virtual folders, 33

SWC (Services Without Components) transactions, 71–73

switching master pages at runtime, 19

symmetric encryption, 113

synchronizing access to shared resources, 340–342

syndication, 205–207

System.Transactions namespace, 72–73