Making a network application system with FrontPage 2003

frontpage| Network

Our school has two equipped with computer, projector, physical booth and other equipment multimedia function room, for the classroom is not a multi-media teaching platform for class sharing use, the use of very high frequency. If any teacher needs to use this function room, must advance to the computer department to fill in the application timetable, if the application succeeds then on time to handle the key to borrow the formalities, uses ends immediately to return for other teachers to use.

As the computer department is located in the teaching area at the back of the comprehensive experimental building, the five floor, teachers to apply for procedures need to run all the way, when the good luck can apply to, when the bad luck then white run a trip. Later, teachers began to use the telephone, but at the same time there will be no answer to the phone and other problems.

Now is the network era, every teacher in our school with a high-speed Internet office computer, if you can have an online application of the database system is better, everything can be networked, automated, paperless, can greatly improve work efficiency. But we are not familiar with ASP Web programming, temporarily from scratch to learn and spend a lot of time, I suddenly think of FrontPage 2003 when creating a new Web site as if there is a database Web site Generation Wizard, you can make the ASP site easier. After half a day of research, soon clear its function, not out of 10 minutes, I this ASP rookie will be able to build the required online function room application database system, very convenient.

1. Open FrontPage 2003, click on "file → new → new site → other site template", then select the Database Interface Wizard, given the site path, click the OK button (Figure 1).

2. You can choose to be ASP platform or ASP.net as the platform, the general selection of the default ASP, the database is recommended to use the first "create a new Microsoft Access in the Web site" database, this option does not necessarily require your machine to install Access, Only this database is built according to its format. If you do not change the options, you can click the Next button directly (Figure 2).

3. Specify the name of the database you want to connect to, or you can default, and do not recommend Chinese.

4. This step is very critical, your database has a number of fields, what the data type, in the Web page displayed as a text box or the next menu, and so on, are set here. First select a column name, click "Modify" can be done to modify the contents.

Where name is the field name, column type is the field data type, form field type is the user's input interface for data logging, and the user can choose as needed. When the selection is complete, all settings are completed (Figure 3).

5. The system automatically set up a database, click the [Next] button can be.

6. Set up the database and its Operation Web page storage path, need to be able to change themselves (Figure 4).

7. It is recommended to check the database editor to make it easier for super users to add, delete, and so on according to user name and password (Figure 5).

8. Given the system's super username and password (Figure 6).

9. Finally click the Finish button and the entire Database Wizard is complete.

At this point, the entire functional room online application system has been completed 90%, the next thing to do is to modify the text of each page, the background of the Web page replacement, to submit the form of the Drop-down list for the initial value of the assignment to work (Figure 7).

Finally, it's about setting up the operating system. Open IIS in the Control Panel's administrative tools, create a new virtual directory in the default Web site, according to the wizard prompts the settings, to remind you that when you set access rights, be sure to check the "execute" option, otherwise IE does not support the ASP Web page of the Analytic compilation (Figure 8).