Use ASP technology to develop a WEB survey (voting) system (1)

Outline
    
This article introduces the implementation of a WEB survey system (also called a voting system) implemented by ASP technology, the system allows you to create and maintain browser-based survey projects, dynamically generate survey forms, and analyze voting results.
Directory
    
I. System Overview
2. Create and maintain the survey project
III. Survey form generation and result analysis (with source program)
    
    
I. System Overview
Author: Cactus studio
    
The WEB survey system (or the voting system) introduced in this article supports browser-based survey project creation, management, and result analysis. Definitions of the survey items and their subordinate problems, and user voting results are stored in the Access Database. The survey forms are dynamically generated by scripts. You can use single-choice buttons or check boxes to answer questions. After the form is submitted, the server records the survey results in the same database. Through the analysis module of the WEB survey system, users can immediately obtain the voting results of any survey item.
    
The entire system is database-centric. Therefore, this article can also be seen as a demonstration of maintaining the database in ASP applications, such as creating and deleting tables, and browser-based database records creation, deletion, and editing are all implemented by SQL commands and JavaScript scripts dynamically generated by the server.
    
I. System Overview
    
(I) system composition
    
From the functional perspective, the entire system can be divided into four parts, which correspond to the four pages from Figure 1 to Figure 4. Figure 1 and Figure 2 are the system maintenance interfaces. The page shown in Figure 1 is used to create a survey project, delete the survey project or its voting results, and specify the survey project name and user password to access the editor shown in figure 2.
    
Figure 1 WEBPollSystem_1.gif]
    
    
    
The page shown in Figure 2 is used to edit the various problems that the specified survey project belongs to. The functions provided directly include creating new problems, deleting problems, changing prompt texts of problems, and browsing problems, using the above features, you can redefine the problem type. The system supports five types of questions: Yes/No (that is, you only need to answer "yes" or "no ), degree of consent (the system predefines five levels of answers from "strong opposition" to "full consent" for such questions) custom semantic classification (answers with 7 predefined levels are defined by the user ), multiple options of the custom prompt text (the number of options and each option prompt text are specified by the user, and only one answer can be selected for each question ), multiple options that can be checked (the number of options and the prompt text of each option are also specified by the user. You can select multiple answers). You can select up to 26 options for the following two question types. In Figure 2, the editing interface is displayed in the middle (above the prompt line at the bottom) of 4th problem types (multiple options.