基于asp.net 在线考试答题系统（源码+数据库）

USE [master] GO /****** Object: Database [db_ExamOnline] Script Date: 03/05/2019 20:04:07 ******/ CREATE DATABASE [db_ExamOnline] ON PRIMARY ( NAME = N'db_ExamOnline_dat', FILENAME = N'D:\DB\db_ExamOnline.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) LOG ON ( NAME = N'db_ExamOnline_log', FILENAME = N'D:\DB\db_ExamOnline.ldf' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) GO ALTER DATABASE [db_ExamOnline] SET COMPATIBILITY_LEVEL = 80 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [db_ExamOnline].[dbo].[sp_fulltext_database] @action = 'disable' end GO ALTER DATABASE [db_ExamOnline] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [db_ExamOnline] SET ANSI_NULLS OFF GO ALTER DATABASE [db_ExamOnline] SET ANSI_PADDING OFF GO ALTER DATABASE [db_ExamOnline] SET ANSI_WARNINGS OFF GO ALTER DATABASE [db_ExamOnline] SET ARITHABORT OFF GO ALTER DATABASE [db_ExamOnline] SET AUTO_CLOSE OFF GO ALTER DATABASE [db_ExamOnline] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [db_ExamOnline] SET AUTO_SHRINK ON GO ALTER DATABASE [db_ExamOnline] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [db_ExamOnline] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [db_ExamOnline] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [db_ExamOnline] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [db_ExamOnline] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [db_ExamOnline] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [db_ExamOnline] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [db_ExamOnline] SET ENABLE_BROKER GO ALTER DATABASE [db_ExamOnline] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [db_ExamOnline] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [db_ExamOnline] SET TRUSTWORTHY OFF GO ALTER DATABASE [db_ExamOnline] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [db_ExamOnline] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [db_ExamOnline] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [db_ExamOnline] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [db_ExamOnline] SET READ_WRITE GO ALTER DATABASE [db_ExamOnline] SET RECOVERY SIMPLE GO ALTER DATABASE [db_ExamOnline] SET MULTI_USER GO ALTER DATABASE [db_ExamOnline] SET PAGE_VERIFY NONE GO ALTER DATABASE [db_ExamOnline] SET DB_CHAINING OFF GO EXEC sys.sp_db_vardecimal_storage_format N'db_ExamOnline', N'ON' GO USE [db_ExamOnline] GO /****** Object: Table [dbo].[tb_test] Script Date: 03/05/2019 20:04:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tb_test]( [ID] [int] IDENTITY(1,1) NOT NULL, [testContent] [varchar](200) NULL, [testAns1] [varchar](50) NULL, [testAns2] [varchar](50) NULL, [testAns3] [varchar](50) NULL, [testAns4] [varchar](50) NULL, [rightAns] [varchar](50) NULL, [pub] [int] NULL, [testCourse] [varchar](50) NULL, CONSTRAINT [PK_tb_test] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[tb_test] ON INSERT [dbo].[tb_test] ([ID], [testContent], [testAns1], [testAns2], [testAns3], [testAns4], [rightAns], [pub], [testCourse]) VALUES (26, N'1+1=', N'2', N'3', N'4', N'5', N'1', 1, N'小学数学') INSERT [dbo].[tb_test] ([ID], [testContent], [testAns1], [testAns2], [testAns3], [testAns4], [rightAns], [pub], [testCourse]) VALUES (27, N'2+2=', N'4', N'5', N'6', N'7', N'1', 1, N'小学数学') INSERT [dbo].[tb_test] ([ID], [testContent], [testAns1], [testAns2], [testAns3], [testAns4], [rightAns], [pub], [testCourse]) VALUES (28, N'3×3＝', N'9', N'10', N'11', N'12', N'1', 1, N'小学数学') INSERT [dbo].[tb_test] ([ID], [testContent], [testAns1], [testAns2], [testAns3], [testAns4], [rightAns], [pub], [testCourse]) VALUES (29, N'4×4=', N'16', N'17', N'18', N'19', N'1', 1, N'小学数学') INSERT [dbo].[tb_test�