asp.net article Management system: Database design and Configuration

asp.net| Design | data | database | Database Design the system uses Access 2003 database department. In the application's root directory, use Access 2003 to create a new database Articlesys_db.mdb, and the data tables in the database include the following three, depending on your system needs:

Related articles: ASP.net article Management system: System analysis and design

Akinds datasheet: For storing article category information, including article Category ID and article category information, table structure and field information as shown in Figure 14.4.

Figure 14.4 Akinds Datasheet

Articles data table: The user holds the article information, including the article ID, author, source, article content and so on information, table structure and field information as shown in Figure 14.5.

Figure 14.5 Articles Datasheet

Talks Datasheet: The user associates the comment, the article ID based, and the table structure and field information as shown in Figure 14.6.

Figure 14.6 Talks datasheet

14.2.2 web.config file configuration information

The configuration information for the Web.config file is as follows:

<?xml version= "1.0" encoding= "Utf-8"?>
<configuration>
<appSettings>
<!--Add Admin account-->
<add key= "Adminid" value= "admin"/>
<!--add Admin password-->
<add key= "PassWord" value= "12345"/>
<!--increase database-driven string-->
<add key= "Constr" value= "Provider=Microsoft.Jet.OLEDB.4.0;Data source="/>
<!--Add database name-->
<add key= "DBS" value= "\articlesys_db.mdb"/>
</appSettings>
<system.web>
<compilation defaultlanguage= "VB" debug= "true"/>
<customerrors mode= "RemoteOnly"/>
<authentication mode= "Windows"/>
<authorization>
<allow users= "*"/>
<!--allow all users to-->
</authorization>
<trace enabled= "false" requestlimit= "ten" pageoutput= "false" tracemode= "SortByTime" localonly= "true"/>
<pages validaterequest= "false"/>
<sessionstate mode= "InProc" stateconnectionstring= "tcpip=127.0.0.1:42424"
sqlconnectionstring= "Data source=127.0.0.1; Trusted_connection=yes "
Cookieless= "false"
Timeout= "20"
/>
<globalization requestencoding= "Utf-8" responseencoding= "Utf-8"/>
</system.web>
</configuration>

In Web.config configuration information, we create a new node <appSettings> use to save administrator information and database information.