Book Image

ASP.NET 3.5 CMS Development

Book Image

ASP.NET 3.5 CMS Development

Overview of this book

ASP.NET 3.5 is equipped with a built-in security system, standard design templates, and easy configurations for database connections, which make it the ideal language for building a content management system. With the strong community support for the ASP.NET platform, you can be assured that what you write today will be around and supported for years to come. You can imagine how easy it is to get lost in the myriad features especially if you are a newcomer. This book shows you how to make use of ASP.NET's features and create a functional Content Management System quickly and conveniently. You will learn how to build your site and see the different ways in which you can customize your code to fit your needs. With this book in hand, you can easily set up users and groups, create valuable content for your users, and manage the layout of your site efficiently. All you need is a basic understanding of coding and a desire to learn, and this book will take care of the rest. This book will teach you to get your site up and running quickly, and maintain its content even if you have little or no web design or programming experience. It will give you all the knowledge you need to use the tools as well as the code required to make yourself a strong developer far beyond your site. It begins with setting up your programming environment and coding a Content Management System. You will learn how to install and configure a database and connect it to your CMS. You will be able to create content and manage the layout of your site, and also make it available beyond the browser. At the end of this book, you will have designed and built a CMS that allows you to administer an Articles section, Images and Files sections, as well as a full set of Administrator tools for your site.
Table of Contents (14 chapters)
ASP.NET 3.5 Content Management System Development
Credits
About the Authors
About the Reviewer
Preface

Creating a database for our simple Content Management System


The simple Content Management System we developed in Chapter 1 suffers from many problems, one of which is the limited storage capabilities provided by the file system. The way to overcome the limitations and problems with file system storage is through the use of a database, so we'll create and use an SQL Server 2005 Express database for this project. There are quite a few ways to create this database, some easy and some less so, but we'll work through a process that would be similar to using any other database server, rather than relying on the development shortcuts found in many ASP.NET tutorials.

We are going to create a database and some initial structure using SQL Server Management Studio Express, instead of using wizards to create a database with a mysterious underlying structure, so that you can learn some ASP.NET techniques for working with data connections. At some point you will need a deeper knowledge of the database...