st_modifycourse.aspx.cs

学生管理系统（asp.net+sql server）

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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 STGROUP
{
	/// <summary>
	/// ST_modifycourse 的摘要说明。
	/// </summary>
	public class ST_modifycourse : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList st_ddl_teacher;
		protected System.Web.UI.WebControls.DropDownList st_ddl_class;
		protected System.Web.UI.WebControls.TextBox st_tbx_year;
		protected System.Web.UI.WebControls.Button st_btn_ok;
		protected System.Web.UI.WebControls.Label st_lbl_note;
		protected System.Web.UI.WebControls.TextBox st_tbx_course;
		protected System.Web.UI.WebControls.RequiredFieldValidator st_rv_year;
		protected System.Web.UI.WebControls.Button st_btn_delete;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			//教师名称下拉列表框绑定
			string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
			//连接本地计算机的sms数据库
			SqlConnection st_conn0= new SqlConnection (st_connstr);
			if(!IsPostBack)
			{	
				st_conn0.Open ();
				string st_sql="select * from ST_teacher";
				SqlCommand st_comm0=new SqlCommand  (st_sql,st_conn0);
				SqlDataReader st_dr0=st_comm0.ExecuteReader ();
				while(st_dr0.Read ())
				{
					st_ddl_teacher.Items .Add (new ListItem(st_dr0["ST_Teacher_name"].ToString(),st_dr0["ST_Teacher_id"].ToString()) );
				}
				st_conn0.Close ();				
				//班级名称下拉列表框绑定
				st_conn0.Open ();
				string st_sql2="select * from ST_class";
				SqlCommand st_comm2=new SqlCommand  (st_sql2,st_conn0);
				SqlDataReader st_dr2=st_comm2.ExecuteReader ();
				while(st_dr2.Read ())
				{
					st_ddl_class.Items .Add (new ListItem(st_dr2["ST_Class_name"].ToString() ,st_dr2["ST_Class_id"].ToString()) );
				}
				st_conn0.Close ();
				st_conn0.Open();
				string st_sql1="select * from ST_teacher_course where ST_Course_id=@Course_id";
				SqlCommand st_comm1=new SqlCommand  (st_sql1,st_conn0);				
				st_comm1.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
				st_comm1.Parameters["@Course_id"].Value=Request.QueryString["ST_Course_id"].ToString();
                SqlDataReader st_dr1=st_comm1.ExecuteReader ();
				if(st_dr1.Read())
				{
					st_tbx_course.Text=st_dr1["ST_Course_id"].ToString();
					st_ddl_teacher.Items.FindByValue(st_dr1["ST_Teacher_id"].ToString()).Selected=true;
					st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Selected=true;
					st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Attributes.CssStyle["color"]="red";
					st_tbx_year.Text=st_dr1["ST_Course_year"].ToString();
				}
				else
			   {Response.Write("<LINK href=\"ST_COMMAN/style.css\" type=\"text/css\" rel=\"stylesheet\">此课程未分配教师！请<a href=\"ST_course.aspx\">返回</a>");
				Response.End();				
			   }
			    st_conn0.Close();
			}

		}

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

		}
		#endregion

		private void st_btn_ok_Click(object sender, System.EventArgs e)
		{
			//获得字符串连接字符串
			string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
		    SqlConnection st_conn=new SqlConnection(st_connstr);
			st_conn.Open();
			//更新sql语句字符串
			string st_sqlstr="update ST_teacher_course set ST_Teacher_id=@Teacher_id,ST_Class_id=@Class_id,ST_Course_year=@Course_year where ST_Course_id=@Course_id";
			SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);				
			st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
			st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
			st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
			st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
			st_comm.Parameters["@Course_id"].Value=Request.QueryString["ST_Course_id"].ToString();
            st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
            st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
			st_comm.Parameters["@course_year"].Value=st_tbx_year.Text;			
			st_comm.ExecuteNonQuery();
			try
			{
			st_lbl_note.Text="修改成功，请返回！";
			}
			catch
			{
					st_lbl_note.Text="修改有误，请检查输入！";
			 }
           st_conn.Close();
		}

		private void st_btn_delete_Click(object sender, System.EventArgs e)
		{
				string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
			SqlConnection st_conn=new SqlConnection(st_connstr);
			st_conn.Open();
			//删除语句
			string st_sqlstr="delete from ST_teacher_course  where ST_Teacher_id=@Teacher_id and ST_Class_id=@Class_id and ST_Course_year=@Course_year and ST_Course_id=@Course_id";
			SqlCommand st_comm=new SqlCommand  (st_sqlstr,st_conn);
			
				st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
				st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
				st_comm.Parameters["@Course_id"].Value=st_tbx_course.Text;
				st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
				st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
				st_comm.Parameters["@course_year"].Value=st_tbx_year.Text;
			try
			{	
				//删除语句
				st_comm.ExecuteNonQuery();
				st_lbl_note.Text="删除成功，请返回！";
				st_btn_ok.Enabled=false;
				st_btn_delete.Enabled=false;
			}
			catch
			{
				st_lbl_note.Text="删除有误,请查明对应关系，再做删除！";
				}
			st_conn.Close();		
		}		
	}
}