ASP.NET 3.5 CMS Development电子书

ASP.NET 3.5 Content Management System Development

Table of Contents

ASP.NET 3.5 Content Management System Development

Credits

About the Authors

About the Reviewer

Preface

What this book covers

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code for the book

Errata

Piracy

Questions

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

Writing a simple content management application

Default.aspx

Content.txt

FCKEditor

Edit.aspx

Summary

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 multiple content pages

Altering the database table

Adding data to the new column

Altering the SqlDataSource code

Understanding SQL Server commands

SQL query syntax

SELECT queries

WHERE clause

LIKE

AND | OR

TOP

ALL | DISTINCT

COUNT

GROUP BY clause

HAVING 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

3. Content Management System Architecture

Multi-tier architecture

The data store

The Pages table

The Panes table

The Articles table

Sample data for 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

Testing the business logic layer

The presentation layer

Building the Master Page

Designing the Master Page

Creating the Default.aspx home page

Adding dynamic content

Summary

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

Password recovery

Summary

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

6. Pages and Zones

Master Pages

Themes

Menus

Page hierarchy

Regions and Zones

Summary

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

8. Administrator Control Panel

Basic site settings

User accounts

Articles

Reporting

Search Engine Optimization

Summary

9. Further Possibilities

Upsizing to the SQL Server

Additional modules

Base pages

Error trapping

Summary

Index