Label3.Visible=false; } } }

protected void Button2_Click(object sender,EventArgs e) {

txtStuID.Text=\; txtStuName.Text=\; txtStuPwd.Text=\; txtStuFPwd.Text=\; txtQuePwd.Text=\; txtAnsPwd.Text=\; txtStuID.Focus(); }

protected void Button3_Click(object sender,EventArgs e) {

Response.Redirect(\); }

protected void Button1_ Click(object sender,EventArgs e) {

//调用公共类中的eccom,执行SQL语句命令 dataconn.eccom(\

tb_student+\(ID.namespace,PWD,question,answer,Sex,profession)\values(\,\,\t+\,\,\,\addProfession.SelectedValue)+\)\

//如果添加成功，弹出添加成功对话框

Label1.Visible=true; }

protected void Button1_Click1(object sender,EventArges e) {

SqlDataReader read=dataconn.ExceRead(\ID=\+this.txtStuID.Text+\); read.Read();

if(read.HashRows) {

if(this.txtStuID.Text==read[\].toString()) {

Label2.Visible=true; }

read.Close(); }}

24

6.3.3考生在线考试模块

该页面中考生首先阅读考试规则，在同意规则后，选择考试试题和套题

代码为：

using System.Data.SqlClient;

public partial class QianUser_StartExamfra:System.Web.UI.Page {

Datacon dataconn=new Datacon();

static int int_row1=0;//单选题号索引 static int int_row2=0;//多选题号索引 static int int_row1Point=0;//单选题分数 static int int_row2Point=0;//多选题分数

//****************页面加载事件，从数据库提取题目**********// protected void Page_Load(object sender,EventArgs e) {

if(!IsPostBack) {

this.getCom(1);

this.getCom(2); } }

//***********提交试卷***********//

protected void btnSubmit_Click(object sender,EventArgs e) {

int_row1=0;//单选题号索引 int_row2=0;//多选题号索引

25

int_row1Point=0;//单选题分数 int_row2Point=0;//多选题分数 //try //{

Label3.Visible=Label4.Visible=Lable7.Visible=Lable8.Visible=Label9.Visible=Label10.Visible=true;

this.lblStuID.Text=Session[\].ToString();

this.lblSubject.Text=Session[\].ToString(); this.lblQuestion.Text=Session[\].ToString(); this.getCom(3); this.getCom(4);

this.lblTotal.Text=Covert.ToString(int_rowPoint+int_row2Point); dataconn.eccom(\

+\

+\lblStuID.Text+\+lblSubject.Text+\+int_row1Point+\+int_row2Point+\);

this.getCom(5);

Response.Write(\您确定要交卷吗？’);location='StartExamfra.aspx':\); //this.btnSubmit.Enabled=false; //}

//Response.Write(\您已经答应过该试卷’）;window.close()\ //} }

//***********执行与数据库的关联操作*****// protected void getCom(int i) {

string ddl=Application[\].ToString(); string dd2=Application[\].ToString(); SqlConnection con=dataconn.getcon(); switch(i) {

//从数据库中选择单选题 case 1;

SqlDataAdapter myaddapter1=new SqlDataAdapter(\+

\单选题'and que_lessonid=\+ddl+\,con); DataSet myds1=new DateSet();

26

myaddapter1.Fill(mydsl); DataLis1.DataSource DataList.DataBind(); //生成单选题题号

for(int tID1=1;tID1<=DataList1.Item.Count;tID1++) {

Label lblSelect=(Label)DataList.Items[tID1++）{

Label

lblSelect=(Label)DataList1.Items[tID1].FindControl(\); lblSelect.Text=tID1.ToString()+\、\; }

break;

//从数据库中选择多选题 case 2：

SqlDataAdapter myadapter2=new SqlDataAdapter(\

+\tb_Questions where que_type='多选题'and que_lessonid=\

+ddl+\and que_taotiid=\order by id desc\

DataSet myds2=new DataSet(); myadapter2.Fill(myds2); DataList2.DataSource=myds2; DataList2.DataBind(); //生成多选题题号 for(int

tID2=1;tID2<=DataList2.Items.Count;tID2++) {

Label

lblDselect=(Label)DataList2.Items[tID2-1].FindControl(\); lblDselect.Text=tID2.ToString()+\、\; }

break;

//核对单选题 case 3:

SqlDataAdapter myadapter3=new SqlDataAdapter(\

+\单选题'and que_lessonid=\

+ddl+\+dd2+\desc\,con);

DataSet myds3=new DataSet(); myadapter3.Fill(myds3);

27