1
using System;
2using System.Collections;
3using System.ComponentModel;
4using System.Data;
5using System.Data.SqlClient;
6using System.Configuration;
7using System.Drawing;
8using System.Web;
9using System.Web.SessionState;
10using System.Web.UI;
11using System.Web.UI.WebControls;
12using System.Web.UI.HtmlControls;
13
14namespace STGROUP
15
...{
16
/**//// <summary>
17
/// ST_modifycourse 的摘要说明。
18
/// </summary>
19 public class ST_modifycourse : System.Web.UI.Page
20 ...{
21 protected System.Web.UI.WebControls.DropDownList st_ddl_teacher;
22 protected System.Web.UI.WebControls.DropDownList st_ddl_class;
23 protected System.Web.UI.WebControls.TextBox st_tbx_year;
24 protected System.Web.UI.WebControls.Button st_btn_ok;
25 protected System.Web.UI.WebControls.Label st_lbl_note;
26 protected System.Web.UI.WebControls.TextBox st_tbx_course;
27 protected System.Web.UI.WebControls.RequiredFieldValidator st_rv_year;
28 protected System.Web.UI.WebControls.Button st_btn_delete;
29
30 private void Page_Load(object sender, System.EventArgs e)
31 ...{
32 //教师名称下拉列表框绑定
33 string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
34 //连接本地计算机的sms数据库
35 SqlConnection st_conn0= new SqlConnection (st_connstr);
36 if(!IsPostBack)
37 ...{
38 st_conn0.Open ();
39 string st_sql="select * from ST_teacher";
40 SqlCommand st_comm0=new SqlCommand (st_sql,st_conn0);
41 SqlDataReader st_dr0=st_comm0.ExecuteReader ();
42 while(st_dr0.Read ())
43 ...{
44 st_ddl_teacher.Items .Add (new ListItem(st_dr0["ST_Teacher_name"].ToString(),st_dr0["ST_Teacher_id"].ToString()) );
45 }
46 st_conn0.Close ();
47 //班级名称下拉列表框绑定
48 st_conn0.Open ();
49 string st_sql2="select * from ST_class";
50 SqlCommand st_comm2=new SqlCommand (st_sql2,st_conn0);
51 SqlDataReader st_dr2=st_comm2.ExecuteReader ();
52 while(st_dr2.Read ())
53 ...{
54 st_ddl_class.Items .Add (new ListItem(st_dr2["ST_Class_name"].ToString() ,st_dr2["ST_Class_id"].ToString()) );
55 }
56 st_conn0.Close ();
57 st_conn0.Open();
58 string st_sql1="select * from ST_teacher_course where ST_Course_id=@Course_id";
59 SqlCommand st_comm1=new SqlCommand (st_sql1,st_conn0);
60 st_comm1.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
61 st_comm1.Parameters["@Course_id"].Value=Request.QueryString["ST_Course_id"].ToString();
62 SqlDataReader st_dr1=st_comm1.ExecuteReader ();
63 if(st_dr1.Read())
64 ...{
65 st_tbx_course.Text=st_dr1["ST_Course_id"].ToString();
66 st_ddl_teacher.Items.FindByValue(st_dr1["ST_Teacher_id"].ToString()).Selected=true;
67 st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Selected=true;
68 st_ddl_class.Items.FindByValue(st_dr1["ST_Class_id"].ToString()).Attributes.CssStyle["color"]="red";
69 st_tbx_year.Text=st_dr1["ST_Course_year"].ToString();
70 }
71 else
72 ...{Response.Write("<LINK href=\"ST_COMMAN/style.css\" type=\"text/css\" rel=\"stylesheet\">此课程未分配教师！请<a href=\"ST_course.aspx\">返回</a>");
73 Response.End();
74 }
75 st_conn0.Close();
76 }
77
78 }
79
80 Web Form Designer generated code#region Web Form Designer generated code
81 override protected void OnInit(EventArgs e)
82 ...{
83 //
84 // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
85 //
86 InitializeComponent();
87 base.OnInit(e);
88 }
89
90 /**//// <summary>
91 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
92 /// 此方法的内容。
93 /// </summary>
94 private void InitializeComponent()
95 ...{
96 this.st_btn_ok.Click += new System.EventHandler(this.st_btn_ok_Click);
97 this.st_btn_delete.Click += new System.EventHandler(this.st_btn_delete_Click);
98 this.Load += new System.EventHandler(this.Page_Load);
99
100 }
101 #endregion
102
103 private void st_btn_ok_Click(object sender, System.EventArgs e)
104 ...{
105 //获得字符串连接字符串
106 string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
107 SqlConnection st_conn=new SqlConnection(st_connstr);
108 st_conn.Open();
109 //更新sql语句字符串
110 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";
111 SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
112 st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
113 st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
114 st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
115 st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
116 st_comm.Parameters["@Course_id"].Value=Request.QueryString["ST_Course_id"].ToString();
117 st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
118 st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
119 st_comm.Parameters["@course_year"].Value=st_tbx_year.Text;
120 st_comm.ExecuteNonQuery();
121 try
122 ...{
123 st_lbl_note.Text="修改成功，请返回！";
124 }
125 catch
126 ...{
127 st_lbl_note.Text="修改有误，请检查输入！";
128 }
129 st_conn.Close();
130 }
131
132 private void st_btn_delete_Click(object sender, System.EventArgs e)
133 ...{
134 string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
135 SqlConnection st_conn=new SqlConnection(st_connstr);
136 st_conn.Open();
137 //删除语句
138 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";
139 SqlCommand st_comm=new SqlCommand (st_sqlstr,st_conn);
140
141 st_comm.Parameters.Add(new SqlParameter("@Course_id",SqlDbType.VarChar,50));
142 st_comm.Parameters.Add(new SqlParameter("@Teacher_id",SqlDbType.VarChar,50));
143 st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
144 st_comm.Parameters.Add(new SqlParameter("@Course_year",SqlDbType.VarChar,50));
145 st_comm.Parameters["@Course_id"].Value=st_tbx_course.Text;
146 st_comm.Parameters["@Teacher_id"].Value=st_ddl_teacher.SelectedItem.Value;
147 st_comm.Parameters["@Class_id"].Value=st_ddl_class.SelectedItem.Value;
148 st_comm.Parameters["@course_year"].Value=st_tbx_year.Text;
149 try
150 ...{
151 //删除语句
152 st_comm.ExecuteNonQuery();
153 st_lbl_note.Text="删除成功，请返回！";
154 st_btn_ok.Enabled=false;
155 st_btn_delete.Enabled=false;
156 }
157 catch
158 ...{
159 st_lbl_note.Text="删除有误,请查明对应关系，再做删除！";
160 }
161 st_conn.Close();
162 }
163 }
164
}
165
StudentsInfo/ST_modifycourse.aspx.cs，打开代码结构图
打包下载该项目完整源码：某大学学生管理系统（毕业设计）源码
