Book Image

Building Websites with the ASP.NET Community Starter Kit

Book Image

Building Websites with the ASP.NET Community Starter Kit

Overview of this book

Microsoft's ASP.NET Community Starter Kit (CSK) is a powerful, freely available application that allows you to quickly create a fully featured community-driven website, complete with article and news management, downloads, forums, and user handling. Supported and tested by thousands of developers in the ASP.NET community across the world, the Community Starter Kit offers you the luxury of a scalable and extensible architecture, and the ability to brand your own site. This book will take you inside the Community Starter Kit, allowing you to harness its power for easily creating your own websites. The book is structured to help you understand, implement and extend the Community Starter Kit: Understand how the Community Starter Kit works. Build the skills to implement your own site. Develop the confidence to extend the system for your own needs. With this book, you will learn how to: Install and configure the CSK Find your way around the CSKs towering range of features Create and administer community websites Become familiar with the common CSK ASP.NET controls Customize your CSK site Discover the secrets of the CSK core architecture Explore the inner workings of CSK modules Extend the CSK by creating new modules Customize existing modules with Web controls Add an RSS feed to share your content with others Deploy your CSK website This book is for ASP.NET developers with a sound grasp of C# and access to Visual Studio .NET. This book uses the Visual Studio. NET version of the ASP.NET Community Starter Kit available from http://www.asp.net/StarterKits/

Related Content you might be interested in

Current Title:

Small book image
Building Websites with the ASP.NET Community Starter Kit
May, 2004 | 284 pages
No titles found
Table of Contents (16 chapters)
TrixBox Made Easy
TrixBox Made Easy
Credits
Credits
About the Authors
About the Authors
Introduction
Introduction
Free Chapter
1
The ASP.NET Community Starter Kit
The ASP.NET Community Starter Kit
What Can the Community Starter Kit Do for You?
The License Agreement
Installing the Community Starter Kit
Summary
2
Touring a Community Starter Kit Website
Touring a Community Starter Kit Website
Overview of the Community Starter Kit
The Main Page
Overview of the CSK Modules
Common Features in the CSK Modules
Creating and Using User Accounts
Summary
3
Creating and Administering Community Websites
Creating and Administering Community Websites
Using the Community Administration Menu
Summary
4
Themes, Skins, and the Common Controls
Themes, Skins, and the Common Controls
Meeting Themes, Skins, and Styles
Creating Themes
The Community Starter Kit Custom Controls
Summary
5
Customizing your Website
Customizing your Website
Setting up a New Community
Preparing the Folder Structure and the Page Skin
Adding Information
Changing the Layout
Summary
6
The Community Starter Kit Core Architecture
The Community Starter Kit Core Architecture
The CSK Folder Structure and Configuration Files
Building Pages for the Client
Processing the Request in the Middle Tier
The Database Structure
Online CSK Resources
Summary
7
Inside a CSK Module
Inside a CSK Module
Database Layer
Module Classes
Skins and Styles
Summary
8
Creating a New Module
Creating a New Module
Module Design
Module Construction Blueprint
The Community_Faq Table
The Community_Faqs Stored Procedures
Initializing the FAQ Module
FAQ Components
FAQ WebControls
Content Classes
FAQ Page Content Skins
Module Styles
Putting It Together
Summary
9
Customization with User Controls
Customization with User Controls
The Custom Module Section
Custom Web Boxes
Summary
10
Adding an RSS Feed
Adding an RSS Feed
The RSS 2.0 Specification
Community RSS Design
HttpModule Changes and Configuration
CommunityRSS.aspx
Testing the RSS Feed
Advertising the RSS Feed
Summary
11
Deployment
Deployment
Installing Content Files
Database Deployment
Community Starter Kit Configuration
Working with Other Sites
Summary
CSK Controls
CSK Controls

The Community_Faqs Stored Procedures

The next steps in our blueprint calls for us to create stored procedures to add an FAQ, edit an FAQ, retrieve a single FAQ, and retrieve a paged and sorted list of FAQs, for a total of four procedures. All of the data access in the CSK happens via stored procedures. There is no ad hoc SQL in the code, which is a good practice from both encapsulation and security standpoints. The first procedure we will write is to add new FAQ content.

Community_FaqsAddFaq

The stored procedure for adding a new FAQ to the database is shown now. We do not need to provide a parameter for every column in the two content tables. For example, we do not need to pass a parameter to populate the contentPage_ViewCount column. Many of the columns contain a sensible default value (contentPage_ViewCount defaults to 0) or allow NULL values (contentPage_dateCommented) for new content.

CREATE PROCEDURE Community_FaqsAddFaq
(
@communityID int,
@sectionID int,
@username nvarchar(50),
@topicID...
Previous Section
End of Section 5
Next Section