subselinfoselect.aspx.cs

学生选课系统开发工具VS2003.NET+Sqlserver2000 功能：基本学生及老师信息

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;

namespace SbElect.SubSelInfo
{
	/// <summary>
	/// SubSelInfoSelect 的摘要说明。
	/// </summary>
	public class SubSelInfoSelect : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Btn_Search;
		protected System.Web.UI.WebControls.DropDownList Type;
		protected System.Web.UI.WebControls.TextBox Key;
		protected System.Web.UI.WebControls.DataGrid Dg_Stu;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{
				Sub_View();

			}
		}

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

		}
		#endregion

		#region 选定课程信息显示
		public void Sub_View()
		{
			int State=int.Parse(Request.Cookies["State"].Value);
			int UserID=int.Parse(Request.Cookies["UserID"].Value);
			Dal.Stu Dal=new SbElect.Dal.Stu();
			DataSet ds=Dal.StuView(State,UserID,5);
			this.Dg_Stu.DataSource=ds;
			this.Dg_Stu.DataBind();
		}
		#endregion

		private void Btn_Search_Click(object sender, System.EventArgs e)
		{
			int State=int.Parse(Request.Cookies["State"].Value);
			int UserID=int.Parse(Request.Cookies["UserID"].Value);
			string Type=this.Type.SelectedItem.Text;
			string Key=this.Key.Text;
			Dal.SubSel Dal=new SbElect.Dal.SubSel();
			DataSet ds=Dal.SelectView(Type,Key);
			this.Dg_Stu.DataSource=ds;
			this.Dg_Stu.DataBind();
		}

		private void Dg_Stu_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			int State=int.Parse(Request.Cookies["State"].Value);
			int UserID=int.Parse(Request.Cookies["UserID"].Value);
			Dal.Stu Dal=new SbElect.Dal.Stu();
			DataSet ds=Dal.StuView(State,UserID,5);
			this.Dg_Stu.CurrentPageIndex=e.NewPageIndex;
			this.Dg_Stu.DataSource=ds;
			this.Dg_Stu.DataBind();

		}
	}
}