SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Users](
[UserID] [varchar](20) NOT NULL,
[UserName] [varchar](20) NOT NULL,
[UserPwd] [varchar](20) NOT NULL,
[UserPower] [int] NOT NULL,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Score]') AND type in (N'U'))
BEGIN
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 (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SingleProblem]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SingleProblem](
[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](2) NOT NULL,
CONSTRAINT [PK_SingleProblem] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Course]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Course](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](200) NOT NULL,
CONSTRAINT [PK_Course] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[JudgeProblem]') AND type in (N'U'))
BEGIN
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 (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MultiProblem]') AND type in (N'U'))
BEGIN
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 (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FillBlankProblem]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[FillBlankProblem](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CourseID] [int] NOT NULL,
[FrontTitle] [varchar](500) NULL,
[BackTitle] [varchar](500) NULL,
[Answer] [varchar](200) NOT NULL,
CONSTRAINT [PK_FillBlankProblem] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Paper]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Paper](
[PaperID] [int] IDENTITY(1,1) NOT NULL,
[CourseID] [int] NOT NULL,
[PaperName] [varchar](200) NOT NULL,
[PaperState�
没有合适的资源?快使用搜索试试~ 我知道了~
C#+Sql 2005网络考试系统书本源码MyOnLineExam
共85个文件
cs:32个
gif:25个
aspx:20个
需积分: 3 5 下载量 146 浏览量
2011-08-04
16:39:19
上传
评论
收藏 359KB ZIP 举报
温馨提示
C#+Sql 2005网络考试系统书本源码MyOnLineExam
资源推荐
资源详情
资源评论
收起资源包目录
C#+Sql 2005网络考试系统书本源码MyOnLineExam.zip (85个子文件)
MyOnLineExam
App_Data
Module01.xls 14KB
Controls
admin_left.ascx 4KB
admin_left.ascx.cs 427B
App_Code
BusinessLogicLayer
Scores.cs 3KB
MultiProblem.cs 8KB
FillBlankProblem.cs 6KB
Course.cs 3KB
SingleProblem.cs 8KB
Paper.cs 4KB
JudgeProblem.cs 6KB
Users.cs 8KB
DataAccessHelper
GetSafeData.cs 3KB
SQLString.cs 470B
DataAccessLayer
DataBase.cs 9KB
Images
ico_Xp15.gif 1KB
ico_Xp14.gif 1KB
ico_Xp06.gif 1KB
ico_Xp11.gif 1KB
Answer.GIF 1KB
ico_Xp03.gif 1KB
ico_Xp05.gif 1KB
ico_Xp09.gif 1KB
ico_Xp01.gif 1KB
ico_Xp13.gif 1KB
left_bg_02.jpg 374B
ico_Xp04.gif 1KB
Login.GIF 1KB
ico_Xp10.gif 1KB
Excel.GIF 1KB
Delete.GIF 1KB
left_bg_01.jpg 8KB
ico_Xp02.gif 1KB
ico_Xp12.gif 1KB
ico_Xp08.gif 1KB
Return.GIF 1KB
Confirm.GIF 1KB
Save.GIF 1KB
left_bg_01.gif 3KB
ico_Xp07.gif 1KB
left_bg_03.jpg 926B
Update.GIF 1KB
Submit.GIF 1KB
Web
admin_UserLists.aspx 4KB
admin_FillBlankLists.aspx.cs 4KB
UserTest.aspx 11KB
admin_PaperLists.aspx 4KB
admin_SingleSelectLists.aspx.cs 3KB
admin_PaperLists.aspx.cs 3KB
admin_Login.aspx.cs 1KB
admin_CourseAdd.aspx 2KB
admin_CourseLists.aspx 4KB
admin_JudgeLists.aspx 4KB
Temp
admin_SingleSelectLists.aspx 4KB
admin_CourseLists.aspx.cs 3KB
admin_UserScore.aspx 5KB
admin_JudgeLists.aspx.cs 4KB
admin_UserLists.aspx.cs 4KB
admin_PaperSetup.aspx 12KB
admin_MultiSelectLists.aspx.cs 3KB
admin_PaperSetup.aspx.cs 5KB
admin_CourseAdd.aspx.cs 1KB
admin_FillBlankAdd.aspx.cs 4KB
admin_JudgeAdd.aspx 2KB
admin_MultiSelectAdd.aspx.cs 4KB
TestAnswer.aspx.cs 3KB
admin_JudgeAdd.aspx.cs 3KB
admin_SingleSelectAdd.aspx.cs 4KB
admin_UserAdd.aspx 3KB
admin_MultiSelectAdd.aspx 4KB
Login.aspx 2KB
admin_UserAdd.aspx.cs 1KB
admin_MultiSelectLists.aspx 4KB
admin_SingleSelectAdd.aspx 4KB
UserTest.aspx.cs 7KB
TestAnswer.aspx 11KB
adminMain.aspx.cs 414B
Login.aspx.cs 2KB
admin_FillBlankLists.aspx 5KB
adminMain.aspx 1KB
admin_FillBlankAdd.aspx 2KB
admin_Login.aspx 2KB
admin_UserScore.aspx.cs 6KB
Web.Config 2KB
DB
MyOnLineExam.bak 1.64MB
MyOnLineExam.sql 46KB
共 85 条
- 1
资源评论
kissjune
- 粉丝: 7
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功