webform1.aspx.cs

北大青鸟2007年7月毕业考试题目

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.Data.SqlClient;
using System.Web.UI.HtmlControls;

namespace AddQuestions
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox txtTitle;
		protected System.Web.UI.WebControls.DropDownList ddlSemester;
		protected System.Web.UI.WebControls.DropDownList ddlCourseID;
		protected System.Web.UI.WebControls.TextBox txtA;
		protected System.Web.UI.WebControls.TextBox txtB;
		protected System.Web.UI.WebControls.TextBox txtC;
		protected System.Web.UI.WebControls.TextBox txtD;
		protected System.Web.UI.WebControls.DropDownList ddlAnswer;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)//回发
			{
				
			}// 在此处放置用户代码以初始化页面
		}

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

		}
		#endregion

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			System.Data.SqlClient.SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sasa;database=T19_rhm");//数据库连接
			string course=this.ddlSemester.SelectedValue;//等到文本框的值
			int courseid=Convert.ToInt32(course);//强制转换为INT型
			string title=this.txtTitle.Text;
			string a=this.txtA.Text;
			string b=this.txtB.Text;
			string c=this.txtC.Text;
			string d=this.txtD.Text;
			string Answer=this.ddlAnswer.SelectedValue;
			try
			{
				con.Open();
				System.Data.SqlClient.SqlCommand com=new SqlCommand("insert into Question (CourseID,Title,OptionA,OptionB,OptionC,OptionD,Answer) values("+courseid+",'"+title+"','"+a+"','"+b+"','"+c+"','"+d+"','"+Answer+"')",
					con);//执行插入操作
				com.ExecuteNonQuery();
				this.txtA.Text="";//清空文本框
				this.txtB.Text="";
				this.txtC.Text="";
				this.txtD.Text="";
				this.txtTitle.Text="";
				this.lblMessage.Text="添加题目完毕";//显示操作信息
				this.btnAdd.Text="继续保存";
			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally{
				con.Close();//关闭数据库
			}
			
		}
		public  void getCourse(int id){//获取科目名称
			System.Data.SqlClient.SqlConnection con=new SqlConnection("server=.;uid=sa;pwd=sasa;database=T19_rhm");
			try
			{
				con.Open();
				System.Data.SqlClient.SqlDataAdapter da=new SqlDataAdapter("select * from course where CourseID="+id+"",con);//根据学期的values
																															//值查询出这条科目信息
				System.Data.DataSet ds=new DataSet();
				da.Fill(ds,"course");//填充DataSet
				this.ddlCourseID.DataTextField="courseName";//填充文本值是courseName
				this.ddlCourseID.DataValueField="courseID";//填充values值是courseName
				this.ddlCourseID.DataSource=ds.Tables[0].DefaultView;
				this.ddlCourseID.DataBind();//拌定到下拉框
			}
			catch(Exception ex)
			{
				throw(ex);
			}
			finally{
				con.Close();//关闭数据库
			}
			
		}

		private void ddlSemester_SelectedIndexChanged(object sender, System.EventArgs e)//根据学期选择 得到相应的科目
		{
			string var=this.ddlSemester.SelectedValue;//得到values值
			int id=Convert.ToInt32(var);//转换为INT型
			this.getCourse(id);//调用带参数的方法获取科目名称
		}


		

	}
}