Table of Contents
Preface
Chapter 1: Planning and Building your First Content Management System
Chapter 2: Adding a Database to a Content Management System
Chapter 3: Content Management System Architecture
Chapter 4: Adding Security and Membership to a Content Management System
Chapter 5: Creating the Articles Module
Chapter 6: Pages and Zones
Chapter 7: Images, Files, and RSS
Chapter 8: Administrator Control Panel
Chapter 9: Further Possibilities
Index
- Chapter 1: Planning and Building your First Content Management System
- What a Content Management System is
- Web Content Management Systems
- Why use ASP.NET
- ASP.NET membership and profiles
- ASP.NET Master Pages and Themes
- ASP.NET 3.5
- Setting up your environment
- Installing IIS
- Operating systems and IIS versions
- Installing IIS in Windows XP Pro
- Installing IIS in Windows Vista
- Installing ASP.NET 3.5
- Installing Visual Web Developer Express 2008
- Configuring and testing your setup
- Configuring IIS on Windows XP
- Configuring IIS on Windows Vista
- Setting NTFS permissions
- Testing IIS
- Installing IIS
- Writing a simple content management application
- Default.aspx
- Content.txt
- FCKEditor
- Edit.aspx
- Default.aspx
- Summary
- What a Content Management System is
- Chapter 2: Adding a Database to a Content Management System
- Why use a database
- Why use SQL Server Express
- Installing and configuring SQL Server 2005 Express
- Installing SQL Server 2005 Management Studio Express
- Running SQL Server 2005 Management Studio Express
- Creating a database for our simple Content Management System
- Creating a new database with Management Studio Express
- Windows authentication vs SQL server authentication
- Configuring an SQL user account
- Configuring the database to use the SQL Server account
- Creating a database table with Management Studio Express
- Using the SimpleCMS database in Visual Web Developer
- Using the SimpleCMS database in the CMS application
- Creating a new Default.aspx file
- Configuring the data source
- Binding the Data Source to a Repeater control
- Creating a new Edit.aspx
- Creating a new Default.aspx file
- Creating multiple content pages
- Altering the database table
- Adding data to the new column
- Altering the SqlDataSource code
- Altering the database table
- Understanding SQL Server commands
- SQL query syntax
- SELECT queries
- WHERE clause
- TOP
- ALL | DISTINCT
- COUNT
- GROUP BY clause
- ORDER BY clause
- INSERT queries
- UPDATE queries
- DELETE queries
- Other queries
- Entities and relationships in brief
- Entities
- Entity relationships
- SQL injection
- Preventing SQL injection
- Changing the database user account
- Summary
- Chapter 3: Content Management System Architecture
- Multi-tier architecture
- The data store
- The Pages table
- The Panes table
- The Articles table
- The data access layer
- Creating the typed dataset
- Filtering data from the dataset
- Insert method
- Update and delete methods
- The business logic layer
- The ArticlesBLL class
- The presentation layer
- Building the Master Page
- The data store
- Summary
- Multi-tier architecture
- Chapter 4: Adding Security and Membership to a Content Management System
- ASP.NET membership
- Configuring and using forms authentication
- Creating a new application
- Creating the home page
- Create the Master Page
- Enabling forms authentication
- Creating the membership database
- Configuring the SqlMembershipProvider
- Creating the login page
- Creating a user account with the ASP.NET configuration tool
- Creating a login
- Adding forms authentication to our CMS
- Preparing an existing SQL database
- The aspnet_regsql.exe tool
- User accounts
- Membership roles
- Adding users to roles
- Login page
- New user registration
- Securing content
- Login status
- Preparing an existing SQL database
- Summary
- Chapter 5: Creating the Articles Module
- Application specifications
- The Article publication process
- User controls
- Building a user control
- Additional specifications
- Building the Articles module
- Database layout
- Data access layer
- Business logic layer
- User controls
- Listing Articles
- Author, Editor, and Publisher roles
- Additional features
- Summary
- Application specifications
- Chapter 6: Pages and Zones
- Master Pages
- Themes
- Menus
- Page hierarchy
- Regions and Zones
- Summary
- Chapter 7: Images, Files, and RSS
- How images and files work on the Web
- File upload control and beyond
- Image gallery
- Document repositories
- RSS feeds
- Summary
- Chapter 8: Administrator Control Panel
- Basic site settings
- User accounts
- Articles
- Reporting
- Search Engine Optimization
- Summary
- Chapter 9: Further Possibilities
- Upsizing to the SQL Server
- Additional modules
- Base pages
- Error trapping
- Summary



