使用asp.net在线检查 [英] On line examination using asp.net

问题描述

大家好.
实际上，我想创建用于在线检查的数据库.但是我没有为我的数据库进行适当的设计.我应该制作两个不同的表来进行问答，还是可以使用一个表来做到这一点.我网站上的另一件事是，我必须在特定时间仅显示一个问题，并且应该更改问题而不刷新页面操作方法.请给我适当的指导.

Hi every one.
Actually i want to create database for online examination. But i am not getting proper design for my database.Should i make two different tables for question and answers or i can do this using one table. Another thing in my web site i have to show only one question at a particular time And questions should be changed without refreshing page how to do that please give me your proper guidance.

推荐答案

问题和答案的独立数据库?你吓到我了！请告诉我，您的意思是表而不是数据库...如果您不这样做，那么我建议您彻底了解数据库是什么以及它们如何工作...这可能需要两个表，并具有以下关系/字段(列):

问题表:
QuestionId -唯一标识符，主键
QuestionText -nvarchar(MAX)
AnswerId -Uniqueidentifier:已实现到答案表AnswerId字段

答案表:
AnswerId -唯一标识符，主键
QuestionId -Uniqueidentifier:与问题表QuestionId字段相关
QuestionText -nvarchar(MAX)

为了清楚起见，所有这些都应该放在一个数据库中.我不会尝试解释数据库的工作方式-如果您对上述表格结构的细节感到完全迷失，请使用Google进行阅读，因为如果您不理解它，那可能是因为您不了解无法正确理解数据库.

希望这会有所帮助，
Ed

Separate databases for questions and answers??!! You horrify me! Please tell me you meant tables not databases... If you didn''t I suggest you take a thorough crash course in what databases are and how they work... For this you will probably need two tables, with following relationships/fields (columns):

Questions Table:
QuestionId - Uniqueidentifier, Primary Key
QuestionText - nvarchar(MAX)
AnswerId - Uniqueidentifier : Realted to Answers Table AnswerId field

Answers Table:
AnswerId - Uniqueidentifier, Primary Key
QuestionId - Uniqueidentifier : Related to Questions Table QuestionId field
QuestionText - nvarchar(MAX)

Just for clarity this should all be in one database. I will not attempt to explain how databases work here - please use Google to read up on this if you are feeling at all lost by my above detailing of table structure because if you can''t understand it, it is probably because you don''t understand databases properly.

Hope this helps,
Ed

好吧，无法提供完整的数据库或项目，但我们可以为您提供一些参考，以便您继续前进.因此，请参考提供的一些链接:
http://lovelycodes.dotnetsquare .com/net/create-online-exam-project-with-asp-net-c-net-with-javascript-timer/ [在此处获取一些代码 [

Well, the complete database or project can not get provided but we can give you some reference by which you can move on. So please refer some links provided:
http://lovelycodes.dotnetsquare.com/net/create-online-exam-project-with-asp-net-c-net-with-javascript-timer/[^]

Get some code here[^]

这篇关于使用asp.net在线检查的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！