官术网_书友最值得收藏!

  • ASP.NET 3.5 CMS Development
  • Curt Christianson Jeff Cochran
  • 310字
  • 2021-04-01 14:20:58

Chapter 2. Adding a Database to a Content Management System

The simple Content Management System we developed in the last chapter worked, but there were plenty of drawbacks to the system we created. One of the major drawbacks was the use of the file system for storing content. Files can be insecure, text files can be unwieldy in size, and you can hold only text content in one. We could use other file types, maybe save the text as HTML to overcome some issues, but that means our content and our presentation are part of the same file. In a CMS, this is one of the issues we need to avoid.

Imagine something as simple as your boss deciding that headings in the pages will now be formatted as a <h2> heading with a purple font color. If we stored 500 pages as simple files that included the HTML, we would have to edit 500 files to change every heading. And you know that, once we finished that task, the company president would want the headings formatted simply as bold text in green. And we would have to change all 500 files again. Even with a search and replace function that works across files, we would still have to check every page to make sure the changes take place. I don't know about you, but I would either rewrite the application or quit the company. As we both need to pay the rent and buy food, let's change the application to use a database to store our content.

In this chapter, we will cover:

  • Why to use a database
  • How to install, configure, and use SQL Server Express
  • How to install and use SQL Management Studio Express
  • Creating your database, creating a user, and setting user permissions
  • Connecting our CMS to the database
  • Managing data from our CMS application
主站蜘蛛池模板: 安阳县| 明水县| 电白县| 洱源县| 西青区| 富蕴县| 永城市| 介休市| 宜川县| 西峡县| 柏乡县| 麻城市| 普兰店市| 镇原县| 田东县| 七台河市| 平武县| 慈溪市| 息烽县| 辽中县| 邻水| 阿拉善右旗| 中阳县| 苍梧县| 敦煌市| 镇坪县| 亳州市| 年辖:市辖区| 无棣县| 绿春县| 泽库县| 额尔古纳市| 阜阳市| 大渡口区| 辽源市| 松阳县| 砀山县| 泰安市| 周宁县| 苍梧县| 馆陶县|