Asp. NET website news management system design and realization

"Summary" leverages ASP. NET and Ado.net technology, the website News management system, which realizes the dynamic management of the website news, makes the management of information more timely and efficient, and improves the work efficiency. At the same time, the system development principle, the system function characteristic and the design plan are introduced.

"Keyword"asp.net ado.net news management database

With the popularization of the Internet, more and more enterprises set up their own WWW website, the enterprise can display products through the website, release the latest dynamic, communicate with the users, establish contact with the partners, and carry out e-commerce. The news management system is an important part of the enterprise Web site, it bears the double function, on the one hand can be used to dynamically release the relevant new products or new development projects, on the other hand, can timely announce the business performance, technology and research and development progress, special recommendation or preferential projects, products and services, In order to attract customers, expand customer base.

Traditional website News management method has two kinds, one is the static HTML page, the update information needs to re-create the page and then uploads the page and modifies the corresponding link, this way because the efficiency is too low has not much use. The second is based on ASP and scripting language, the combination of dynamic Web pages and databases, through the application of the processing of news, this is a more popular practice. However, due to the limitations of the ASP itself makes the system some insurmountable defects, and adopted the ASP.net technology of the systematic performance has been greatly improved, its main performance in the following areas:

1. Because the ASP page must be compiled after the first interpretation of the process, so the page is repeatedly open without any increase in speed, and the ASP.net page only need to compile once after compiling, until the page is modified or Web application restart. This allows for a significant increase in the speed of multiple accesses.

2. Because the ASP does not provide any components that output data as content, it is only possible to read records on a per-pen basis with ADO Recordset objects when composing a database page using ASP, while ASP.net database components, such as the DataGrid provided by Ado.net, can be directly linked to the database.

3.ASP. NET supports real-time updates of applications. An administrator can update the application file without shutting down the network server or even stopping the application from running. Application files are never locked, so files can be overwritten even while the program is running. When the file is updated, the system is gently converted to the new version.

4.ASP. NET takes "Code-behind" way to write code makes code easier to write, structure clearer, reduce the complexity and cost of system development and maintenance.

The development principle of 1 system

1.1 System structure model based on ASP.net technology

Asp. NET structure is a three-tier system: The UI layer, the business logic layer, and the data tier, as shown in Figure 1.

Figure 1 ASP. System Structure Model of net

The UI layer is responsible for interacting with the user, receiving input from the user and presenting the server-side data to the customer.

The business logic layer is responsible for receiving requests from the browser and passing the request to the data tier while sending the request processing results to the browser. It consists of Web Forms, XML Web services, and Component Services. The Web form is the core of the ASP.net application, which is the basis for presenting data and information to customers and is the basis for responding to and handling the information and data generated by the interaction between the customer and the displayed Web form.

The data layer provides data services for the transaction logic layer through ado.net manipulating data, such as storing data operation results, returning data retrieval results, etc.

1.2 ADO. NET access to the database principle

Connected to the database, ADO. NET provides 3 ways to connect through ODBC, connect via OLE DB, and connect directly to SQL Server. 3 ways because of the difference of application level, the efficiency from low to high, independence from high to low. There are 2 ways of data processing for connected databases, one is to isolate heterogeneous data sources through a dataset, and the other is to read from the data source in a streaming manner (DataReader way).

Traditional applications are designed by first establishing a connection to the database and maintaining the connection during the entire run of the program. Asp. NET takes a disconnected way of data structure. When a browser requests a Web page from a Web server, the server processes the request and sends the requested page to the browser, and the connection is disconnected until the browser makes the next request.

Ado. NET, another innovation is the introduction of Datasets (DataSet). A dataset is a high-speed buffer in memory that provides a data graph. Datasets are ignorant of data sources and can be generated and populated by programs or by the transfer of data from the Data warehouse. Regardless of where the data is obtained, the dataset is manipulated by using the same program template, and it uses the same potential data buffer.