This article takes the driving school management system as an example, describes how to use asp.net and SQL Server 2000来 to carry on the Dynamic Web page design, satisfies the user to the database real-time update and the inquiry request.
Introduction
In recent years, with the rapid development of Internet and the improvement of Web page making technology, the design of information management system software of driving school is becoming simpler and more standardized. Here we will adopt asp.net Dynamic Web technology, by writing C # script language to the SQL Server 2000 database operation, to achieve many of the functions of the system, such as "Registration entry", "Registration Information query", "Confirm qualified students", "Student data query" and so on.
asp.net, C # and Ado.net
1, ASP. NET is a powerful Web server-side technology introduced by Microsoft, ASP, compared with ASP. NET has more high-performance compilation features and caching mechanisms. Supports multiple development languages, including C #, J #, Visual Basic, and JScript. ASP. NET Detach program code and display content, make the code look more concise. Because ASP.net's program code is compiled, it executes more quickly than an ASP.
2. The C # language is a new programming language developed by Microsoft for the. NET platform. It is a developing language of object-oriented objects, so it has encapsulation, inheritance and polymorphism. C # syntax is concise, efficient, and can be used with other. NET language is compatible with code written in the
3, ADO. NET is used to provide data access services in the Microsoft. NET platform. It acts on the server side to access and update the database by executing SQL commands. Ado.net mainly includes Connection,dataset and command three objects, their main functions are as follows:
Connection对象:连接数据库;
Dataset对象:存取数据库的内容;
Command对象:对数据库执行查询指令,以及执行非查询(更新、删除和添加等)命令。
Web Design
The following will take the driving school management system software "student data query and modify" as an example to explain the problem of web design. (C #)
First, build a database named "JX" in SQL Server 2000 that contains tables "model", "Student data", and view "v Student data".
Secondly, "Student data query and modification" mainly consists of three pages, for: xy_search.aspx, xy_search_win.aspx, xy_search_detail.aspx, respectively for the input query conditions, display query results, Displays the details of one of the records and modifies them as needed.
1, xy_search.aspx
In this page, you design the page based on the user's query criteria by selecting the control in the Toolbox Web form with the left mouse button, dragging it to the page, placing it in the appropriate place, and then setting the properties of the control, and other controls are similar. As shown in Figure 1.
Figure 1