teachermake.aspx.cs

yi ge xue sheng cheng ji guan li xi tong de yuan ma .

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;
namespace myResult
{
	/// <summary>
	/// teachermake 的摘要说明。
	/// </summary>
	public class teachermake : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnsearch;
		protected System.Web.UI.WebControls.DataGrid dg_result;
		protected System.Web.UI.WebControls.DropDownList ddlcourse;
		protected SqlConnection conn;
		protected SqlDataAdapter myDa;
		protected System.Web.UI.WebControls.DropDownList ddlclass;
		protected DataSet ds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			string str_user=Session["user"].ToString();
			conn=connDB.createConn();
			ds=new DataSet();
			if(!IsPostBack)
			{
				this.bindDdl();
				this.bindDdlCourse();
			}
		}
		private void bindDdl()
		{
			string str_sel="select ClassNumber from Class";
			myDa=new SqlDataAdapter(str_sel,conn);
			myDa.Fill(ds,"Class");
			ddlclass.DataSource=ds.Tables["Class"].DefaultView;
			ddlclass.DataTextField="ClassNumber";
			ddlclass.DataBind();
		}
		private void bindDdlCourse()
		{
			string str_sel="select CourseId,CourseName from Course";
			myDa=new SqlDataAdapter(str_sel,conn);
			myDa.Fill(ds,"Course");
			ddlcourse.DataSource=ds.Tables["Course"].DefaultView;
			ddlcourse.DataTextField="CourseName";
			ddlcourse.DataBind();
		}
		private void bindDg()
		{
			string str_class=this.ddlclass.SelectedValue.ToString();
			string str_course=this.ddlcourse.SelectedValue.ToString();
			myDa=new SqlDataAdapter("procSelResult2",conn);
			myDa.SelectCommand.CommandType=CommandType.StoredProcedure;
			SqlParameter param=new SqlParameter("@Aclass",SqlDbType.VarChar,50);
			SqlParameter param1=new SqlParameter("@Acourse",SqlDbType.VarChar,50);
			param.Direction=ParameterDirection.Input;
			param1.Direction=ParameterDirection.Input;
			param.Value=str_class;
			param1.Value=str_course;
			myDa.SelectCommand.Parameters.Add(param);
			myDa.SelectCommand.Parameters.Add(param1);
			myDa.Fill(ds,"Result");
			dg_result.DataSource=ds.Tables["Result"].DefaultView;
			dg_result.DataBind();
		}

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

		}
		#endregion

		private void btnsearch_Click(object sender, System.EventArgs e)
		{
			if(this.IsValid)
			{
				this.bindDg();
			}
		}
	}
}