Index

T

\t character spaces, 366

table-level SQL dependencies, support for, 63–66

tbh_Articles table, 188–190

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_GetCommentCountByArticle procedure, 192

tbh_Articles_GetComments procedure, 192

tbh_Articles_GetCommentsByArticle procedure, 192

tbh_Articles_GetPublishedArticleCount procedure, 192

tbh_Articles_GetPublishedArticle CountByCategory procedure, 192, 216

tbh_Articles_GetPublishedArticles procedure, 192

tbh_Articles_GetPublishedArticlesBy Category 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

tbh_Categories table, 187–188

tbh_Comments table, 190

tbh_Forums_ApprovePost property, 388

tbh_Forums_CloseThread property, 388

tbh_Forums_DeleteForum property, 388

tbh_Forums_DeletePost property, 389

tbh_Forums_GetForumByID property, 389

tbh_Forums_GetForums property, 389

tbh_Forums_GetPostBody property, 389

tbh_Forums_GetPostByID property, 389

tbh_Forums_GetPostCountByThread property, 389

tbh_Forums_GetThreadByID property, 389

tbh_Forums_GetThreadCount property, 389

tbh_Forums_GetThreadCountByForum property, 389

tbh_Forums_GetUnapprovedPosts property, 389

tbh_Forums_IncrementViewCount property, 389

tbh_Forums_InsertForum property, 389

tbh_Forums_InsertPost property, 389

tbh_Forums_MoveThread property, 389

tbh_Forums_UpdateForum property, 389

tbh_Forums_UpdatePost property, 389

tbh_Newsletters_DeleteNewsletter property, 348

tbh_Newsletters_GetNewsletters property, 348

tbh_Newsletters_GetNewslettersByID property, 348

tbh_Newsletters_InsertNewsletter property, 348

tbh_Newsletters_UpdateNewsletter property, 348

tbh_Polls_ArchivePoll property, 288

tbh_Polls_ArchivePoll stored procedure, 296

tbh_Polls_DeleteOption property, 288

tbh_Polls_DeletePoll property, 288

tbh_Polls_GetCurrentPollByID stored procedure, 297–298

tbh_Polls_GetCurrentPollID property, 288

tbh_Polls_GetOptionByID property, 289

tbh_Polls_GetOptionByID stored procedure, 299

tbh_Polls_GetOptions property, 289

tbh_Polls_GetOptions stored procedure, 298

tbh_Polls_GetPollByID property, 288

tbh_Polls_GetPollByID stored procedure, 297

tbh_Polls_GetPolls property, 288

tbh_Polls_GetPolls stored procedure, 296–297

tbh_Polls_InsertOption property, 288

tbh_Polls_InsertPoll property, 288

tbh_Polls_InsertPoll stored procedure, 295–296

tbh_Polls_InsertVote property, 289

tbh_Polls_UpdateOption property, 288

tbh_Polls_UpdatePoll property, 288

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

technologies used to implement site layout design, 10–11

TemplatedMailWebEventProvider class, 77

TemplateMonster, 10

TheBeerHouse project

AccessDenied.aspx page, 151–152

administration

edit users administrative page, 175–180

manage users administrative page, 170–175

overview, 170

BLL base class, 107–109

configuration file, 145–148

custom BasePage class, 42–45

custom configuration section, 101–105

DataAccess base DAL class, 105–107

edit profile page, 167–169

features needed for, 2–4

first theme, creating, 33–36

health monitoring system, 109–110

marketing issues, 1–2

master page, creating, 30–32

password recovery page, 163–166

PayPal integration, 427–429

registration page, 159–163

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

themes saved between sessions, 169–170

UserProfile control

loading and editing a profile, 157–158

overview, 152–156

persisting properties through the new control state, 156–157

themes

all pages, applying theme to, 20

master pages, 21

overview, 19–22

saved between sessions, 169–170

single page, applying theme to, 20

skin files, 19–22

theme selector user control, creating, 38–42

ThreadsPageSize property, 390

[3-7a-dA-D] character class, 367

Title property, 198, 207

TotalRating property, 199

TraceWebEventProvider class, 77

transaction management

ADO.NET transactions, 69–70

COM+ transactions, 70–73

declarative transactions, 71

overview, 69

SWC transactions, 71–73

System.Transactions namespace, 72–73

transparent server request, 342