addquestions.aspx.cs

在线考试系统： 1、为了保证示例代码正确运行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;

namespace TestOnline
{
	/// <summary>
	/// AddQuestions 的摘要说明。
	/// </summary>
	public class AddQuestions : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnfinish;
		protected System.Web.UI.WebControls.Button btnnext;
		protected System.Web.UI.WebControls.Button btnsave;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox tbxanswer;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox tbxquestion;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox tbxscore;
		protected System.Web.UI.WebControls.DropDownList dplqt;
		protected System.Web.UI.WebControls.Label lblshow;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string papername  =Session["papername"].ToString();
			lblshow.Text = Session["username"] +"，您正在为" + papername + "试卷添加试题";
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnsave.Click += new System.EventHandler(this.btnsave_Click);
			this.btnnext.Click += new System.EventHandler(this.btnnext_Click);
			this.btnfinish.Click += new System.EventHandler(this.btnfinish_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnsave_Click(object sender, System.EventArgs e)
		{
			//获取问题的最大编号
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			string getInsertID; 
			string papername;
			papername = Session["papername"].ToString();
			getInsertID = "select Max(QuestionID) from " ;
			getInsertID = getInsertID + papername;
			SqlCommand cmd0 = new SqlCommand(getInsertID, objconn);
			objconn.Open();
			SqlDataReader objdr = cmd0.ExecuteReader();
			objdr.Read();
			int Varid;
			if (objdr[0].ToString() == "")
			{
				Varid = 1;
			}
			else
			{
				Varid = Convert.ToInt32(objdr[0].ToString()) + 1;
			}
	        
			cmd0.Connection.Close();
        string objsql;
        string qtype  = dplqt.SelectedIndex.ToString();
        string qcontent = tbxquestion.Text.ToString();
        string qanswer = tbxanswer.Text.ToString();
        int qscore  = Convert.ToInt32(tbxscore.Text);

        objsql = "Insert into " + papername;
        objsql = objsql + "(QuestionID,QuestionType,Question,Answer,Score) values(";
        objsql = objsql + Varid + ",";
        objsql = objsql + qtype + ",";
        objsql = objsql +"'"+ qcontent +"'"+ ",";
        objsql = objsql + "'"+qanswer +"'"+ ",";
        objsql = objsql + qscore + " )";
        objconn.Open();
        //创建命令对象
	    //Response.Write(objsql);
		//Response.End();
        SqlCommand objcmd =new SqlCommand(objsql, objconn);
        //执行数据库操作
        objcmd.ExecuteNonQuery();
        objconn.Close();
		}

		private void btnnext_Click(object sender, System.EventArgs e)
		{
			        tbxquestion.Text = "";
        tbxanswer.Text = "";
        tbxscore.Text = "";
		}

		private void btnfinish_Click(object sender, System.EventArgs e)
		{
			        Session["papername"] = "";
        Response.Redirect("TDefault.aspx");
		}
	}
}