Index

D

\D character class, 367

\d character class, 367

data access layer (DAL)

abstract base class, 57–60

ArticleDetails class, 219–220

ArticlesProvider class, 221–223

content, 194–195

DataSet compared to custom entities, 53–55

described, 48

e-commerce store, 432–433

forums

designing, 391

implementing, 396–398

implementing, 219–228

multiple data stores, using provider model design pattern to support, 51–53

newsletters

designing, 350

implementing, 355–357

opinion polls

designing, 290

implementing, 301–303

overview, 51

providers, 52

SiteProvider class, 228

SQL text queries, 56–57

SqlArticlesProvider class, 223–228

stored procedures, 56–57

data store

choosing, 49–51

described, 48

Relational Database Management Systems (RDBMS), 50

DataAccess base DAL class, 105–107

database

forums, implementing, 394–396

opinion polls

overview, 294–295

tbh_Polls_ArchivePoll stored procedure, 296

tbh_Polls_GetCurrentPollByID stored procedure, 297–298

tbh_Polls_GetOptionByID stored procedure, 299

tbh_Polls_GetOptions stored procedure, 298

tbh_Polls_GetPollByID stored proceure, 297

tbh_Polls_GetPolls stored procedure, 296–297

tbh_Polls_InsertPoll stored procedure, 295–296

setup for SQL Server provider, 80

database tables

content, 186–190

e-commerce store, 429–431

forums, 385–388

newsletters, 348

opinion polls

designing, 287–288

stored procedures managing, 288–289

overview, 186–187

relationships between tables, 208–210

stored procedures, 210–216, 288–289

tbh_Articles table, 188–190

tbh_Categories table, 187–188

tbh_Comments table, 190

data-bound controls, 84–85

DataSets

advantages of, 54

custom entities compared, 53–55

disadvantages of, 54

DB2, 50

declarative coding, 208

declarative transactions, 71

DeclarativeCatalogPart control, 488

decoupling tiers, 47

default content, 17

default SQL Server data store, 124–126

DefaultOrderListInterval property, 432

Delete instance method, 199

DeleteArticle static method, 200

DeleteRole method, 134

DeleteUser method, 116

deploying the site

with external FTP client, 539

methods for

copying the site locally or remotely, 537–540

installer package, creating, 546–550

overview, 536–537

pre-compiling the site, 540–546

overview, 525–526

to SQL Server 2005

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

with Visual Studio Copy Web Site, 537–540

Web Setup Project, 547

description attribute, 123

design

approval of site layout design, 10

browsers and visual site design, 8

business logic layer (BLL)

forums, 391–393

newsletters, 350–352

opinion polls, 290–292

overview, 195–202

color blindness and visual site design, 8

common design shared among multiple pages, 15–19

configuration module

newsletters, 349

opinion polls, 289–290

data access layer (DAL)

forums, 391

multiple data stores, using provider model design pattern to support, 51–53

newsletters, 350

opinion polls, 290

database tables for opinion polls, 287–288

e-commerce store

business logic layer, 433–437

user interface, 437–439

forums

business logic layer, 391–393

configuration module, designing, 390–391

data access layer, 391

database tables, designing, 385–388

user interface, 394

HTML

site layout design and, 10

tables, site layout design and, 13–14

loading speed and site layout design, 14

multi-tier design

Data Access Layer (DAL), 51–60

data store, 49–51

edit and continue process, 49

overview, 48–49

news and article management, 202–207

newsletters

business logic layer, 350–352

configuration module, 349

data access layer, 350

database tables, designing, 348

user interface, designing, 352–353

opinion polls

business logic layer, 290–292

configuration module, 289–290

data access layer, 290

database tables for, 287–288

user interface, 292–293

partial classes and site layout design, 10

provider model design pattern, 119–122

screen readers and site layout design, 14

site design for TheBeerHouse project

creating, 27–45

custom BasePage class, 42–45

first theme, creating, 33–36

master page, creating, 30–32

sample Default.aspx page, creating, 36–37

second theme, creating, 37–38

site design, creating, 27–45

site map file, creating, 32–33

theme selector user control, creating, 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

technologies used to implement site layout design, 10–11

user interface

e-commerce store, 437–439

forums, 394

newsletters, 352–353

opinion polls, 292–293

overview, 202–207

visual site design

appearance, importance of, 7–8

browsers and, 8

color blindness and, 8

overview, 7–8

site layout design, 9–14

Design mode, 482

DetailsView control, 84

devices, targeting different classes of, 14

display modes

Browse mode, 482

Catalog mode, 482

Connect mode, 483

Design mode, 482

Edit mode, 482

overview, 482

divisions, 148

domain objects, 55

drop-down lists, 155

dynamically changing master pages, 19