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

Changing the database user account


In this chapter, we used the sa account to connect to our database, even though earlier we created the SimpleCMSUser account for this purpose. There's nothing wrong with this for developing a site that will not be published on the Internet, but the sa account is the master account for your database and it's not a smart idea to use it on a production system. In addition, many hosts will not allow you to use it, and will make you create an account or use one they create for you. Fortunately, it's simple to change the account we use.

Assuming you created the account in SQL Server Management Studio, or by using your host's control panel, you simply need to change the connection string in the web.config file. In your web.config, you will find a line similar to:

<add name="SimpleCMS_DatabaseConnectionString"
connectionString="Data Source=HP\SQLEXPRESS;
Initial Catalog=SimpleCMS_Database;
Persist Security Info=True;
User ID=sa;Password=SimpleCMS"
providerName...