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

Summary


In this chapter, we replaced the file-based CMS from Chapter 1 with a database version. You should now have a basic understanding of working with SQL Server Express 2005 and ASP.NET, as well as a basic understanding of how SQL Server works. You should be able to create a database, create a table in that database, and add columns to that table within SQL Server Management Studio Express.

We also explored the SqlDataSource, and using SQL Server 2005 Express as a source for data in our application. We created both a SelectCommand and an UpdateCommand to be used in that SqlDataSource to select records and modify the data in specific fields. You should also understand the role of the ConnectionString in the web.config in providing a connection to the database. As you work with ASP.NET and databases, you will find that moving applications to new systems will require changes to the connection string to get the database connected to the application. The web site at http://www.connectionstrings...