asp.net 在线答题系统源码(含数据库)

【实例简介】基于asp.net sql server开发的在线答题系统

本人学习时开发的一个简单的在线答题系统，采用Asp.Net开发，现在个大家分享交流希望给些宝贵意见！
开发工具：vs2005 或更高版本
数据库：SqlSevrer2005 或者更高版本
测试帐号：
管理员：admin 密码:123
学生： huangyang 密码：123 

【实例截图】

【核心代码】

protected void Button1_Click(object sender, EventArgs e)
    {
        
        if (rbA.Checked == true || rbB.Checked == true || rbC.Checked == true || rbD.Checked == true || rbE.Checked == true)
        {

            int a = dvCQ.PageCount;
            int b = dvCQ.PageIndex;
            dvCQ.PageIndex = b 1;
            string answer = "";
            if (rbA.Checked == true)
            {
                answer = "A";
            }
            else if (rbB.Checked == true)
            {
                answer = "B";
            }
            else if (rbC.Checked == true)
            {
                answer = "C";
            }
            else if (rbD.Checked == true)
            {
                answer = "D";
            }
            else if (rbE.Checked == true)
            {
                answer = "E";
            }
            User user = Session["user"] as User;
            UserAnswer ua = new UserAnswer();
            ua.UAnswer = answer;
            ua.U = user;
            Subject sb = new Subject();
            sb.SId = Convert.ToInt32(Request.QueryString["subId"]);
            ua.S = sb;
            Label lblRightAnswer = dvCQ.FindControl("lblRightAnswer") as Label;
            ua.RightAnswer = lblRightAnswer.Text;
            ChoiceQuestion cq = new ChoiceQuestion();
            Label lblQid = dvCQ.FindControl("lblCQid") as Label;
            cq.Qid = Convert.ToInt32(lblQid.Text);
            ua.C = cq;
            UserAnswerBLL uab = new UserAnswerBLL();
            uab.addUserAnswer(ua);
            rbA.Checked = false;
            rbB.Checked = false;
            rbC.Checked = false;
            rbD.Checked = false;
            rbE.Checked = false;
           
            if (b==a-1)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('已经答完所有题目，请提交！')", true);
                btnNext.Visible = false;
                btnOk.Visible = true;
            }
        }
        else
        {
            ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('请选择一个答案！')",true);
        }
    }

    
    protected void Timer1_Tick(object sender, EventArgs e)
    {
            int times = Convert.ToInt32(ViewState["times"]);
            times --;
            ViewState.Add("times",times);
            int a = times;
            int b = a / 60;
            int c = a % 60;
            if (c.ToString().Length < 2)
            {
                lblTimes.Text = b ":" "0" c.ToString();
            }
            else
            {
                lblTimes.Text = b ":" c.ToString();
            }
            if (b == 0 && c == 0)
            {
                Timer1.Enabled = false;
                ScoreBLL scb = new ScoreBLL();
                User user = Session["user"] as User;
                int uid = user.UId;   
                int sid = Convert.ToInt32(Request.QueryString["subId"]);
                double score = scb.SelScore(sid, uid);
              
                btnNext.Enabled = false;
                Score scores = new Score();
                scores.U = user;
                Subject sub = new Subject();
                sub.SId = Convert.ToInt32(Request.QueryString["subId"]);
                scores.Sub = sub;
                scores.Core = score.ToString();
                scb.AddUserScore(scores);
                ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('你的答题时间已到！你的本次成绩为：" score "分')", true);
                
            }      
    }

    protected void btnOk_Click(object sender, EventArgs e)
    {
        
        ScoreBLL scb = new ScoreBLL();
        User user = Session["user"] as User;
        int uid = user.UId;
        int sid = Convert.ToInt32(Request.QueryString["subId"]);
        double score = scb.SelScore(sid,uid);
        Timer1.Enabled = false;
        Score scores = new Score();
        scores.U = user;
        Subject sub = new Subject();
        sub.SId = Convert.ToInt32(Request.QueryString["subId"]);
        scores.Sub = sub;
        scores.Core = score.ToString();
        scb.AddUserScore(scores);
        ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('你的本次成绩为：" score "分')", true);
            
    }
}