b2c信息网

您现在的位置是:首页 > 昨日新闻 > 正文

昨日新闻

asp在线考试系统源码(ASPNET考试)

hacker2022-06-13 19:39:15昨日新闻45
本文目录一览:1、在网上弄了一套asp在线考试系统的源码,用iis运行的时候连接不上数据库

本文目录一览:

在网上弄了一套asp在线考试系统的源码,用iis运行的时候连接不上数据库

这是系统预设的错误提示

即表示你的源码有问题--相关路径有错误

如果你对IIS不是很熟悉

最好百度一下"简易ASP测试工具"

可能更靠谱

ASP 在线考试系统 源代码

这个亲测可用,你看符不符合你的要求,里面的内容可以随便改动的。

基于ASP.NET在线考试系统开发实例源码,SQL Server 2008数据库

有完整源代码,附上数据库部分代码参考:

CREATE TABLE [dbo].[JudgeProblem](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CourseID] [int] NOT NULL,

[Title] [varchar](1000) NOT NULL,

[Answer] [bit] NOT NULL,

CONSTRAINT [PK_JudgeProblem] 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

CREATE TABLE [dbo].[MultiProblem](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CourseID] [int] NOT NULL,

[Title] [varchar](1000) NOT NULL,

[AnswerA] [varchar](500) NOT NULL,

[AnswerB] [varchar](500) NOT NULL,

[AnswerC] [varchar](500) NOT NULL,

[AnswerD] [varchar](500) NOT NULL,

[Answer] [varchar](50) NOT NULL,

CONSTRAINT [PK_MultiProblem] 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

CREATE TABLE [dbo].[Student](

[ID] [varchar](50) NOT NULL,

[Name] [varchar](20) NULL,

[PWD] [varchar](20) NULL,

[Sex] [varchar](2) NULL,

[JoinTime] [varchar](20) NULL,

[Question] [varchar](50) NULL,

[Answer] [varchar](50) NULL,

[profession] [varchar](50) NULL,

CONSTRAINT [PK_tb_Student] 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

CREATE TABLE [dbo].[Score](

[ID] [int] IDENTITY(1,1) NOT NULL,

[UserID] [varchar](20) NOT NULL,

[PaperID] [int] NOT NULL,

[Score] [int] NOT NULL,

[ExamTime] [datetime] NOT NULL CONSTRAINT [DF_Score_ExamTime] DEFAULT (getdate()),

CONSTRAINT [PK_Score] 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

CREATE TABLE [dbo].[Course](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Name] [varchar](200) NOT NULL,

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

发表评论

评论列表

  • 闹旅扶弦(2022-06-14 06:54:20)回复取消回复

    1,1) NOT NULL, [Name] [varchar](200) NOT NULL,PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORE

  • 舔夺酒废(2022-06-13 22:50:34)回复取消回复

    IMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_

  • 惑心春慵(2022-06-13 22:10:36)回复取消回复

    [ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIM