using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;

public?partial?class?addclass?:?System.Web.UI.Page
{

????SqlConnection?sms_conn;

????//?protected?System.Web.UI.WebControls.DataGrid?sms_teacher;
????//??protected?System.Web.UI.WebControls.Label?sms_lbl_note;

????string??sms_sqlstr2;
????private?void?Page_Load（object?sender?System.EventArgs?e）
????{
????????//?在此處放置用戶代碼以初始化頁面
????????string?sms_connstr?=?ConfigurationSettings.AppSettings[“SMS_dbconn“];
????????sms_conn?=?new?SqlConnection（sms_connstr）;
????????if?（!IsPostBack）
????????????SMS_DataBind（）;
????}

????public??void?SMS_DataBind（）
????{
????????
????????sms_sqlstr2?=?“select?*?from?[speciality]“;
????????SqlDataAdapter?sms_da2?=?new?SqlDataAdapter（sms_sqlstr2?sms_conn）;
????????DataSet?sms_ds2?=?new?DataSet（）;
????????sms_da2.Fill（sms_ds2?“T“）;
????????for?（int?i?=?2000;?i?<=?2020;?i++）
????????{
????????????DropDownList2.Items.Add（new?ListItem（i.ToString（）?i.ToString（）））;
????????}
????????for?（int?i?=?0;?i?????????{
????????????DropDownList1.Items.Add（new?ListItem（sms_ds2.Tables[“T“].Rows[i][“specialityname“].ToString（）?sms_ds2.Tables[“T“].Rows[i][“specialityid“].ToString（）））;
????????}
????????Label5.Text?=?DropDownList1.SelectedValue.ToString（）;
????????sms_conn.Close（）;
????????sms_ds2.Clear（）;
????????sms_ds2.Dispose（）;
????}
????public?void?DDL1selsctedchange（object?sender?EventArgs?e）
????{
????????Label5.Text?=DropDownList1.SelectedValue.ToString（）;?
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????string?sms_sqlstr?=?“insert?into?class?（classidclassnamespecialityidspecialitynameentranceyearmonitorid）?values（‘“?+?TextBox1.Text?+?“‘‘“?+?TextBox2.Text?+?“‘‘“?+?Label5.Text?+?“‘‘“?+?DropDownList1.SelectedItem.Text?+?“‘‘“?+?DropDownList2.SelectedItem.Text?+?“‘‘“?+?TextBox3.Text?+?“‘）“;
????????SqlCommand?sms_comm?=?new?SqlCommand（sms_sqlstr?sms_conn）;
????????sms_comm.Connection.Open（）;
????????try
????????{
????????????sms_comm.ExecuteNonQuery（）;
????????????sms_lbl_note.Text?=?“編輯成功“;

????????}
????????catch?（SqlException）
????????{
????????????sms_lbl_note.Text?=?“編輯失敗“;
????????????sms_lbl_note.style[“color“]?=?“red“;
????????}
????????sms_comm.Connection.Close（）;
????????Response.Redirect（“class.aspx“）;
????}
????protected?void?Button3_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“class.aspx“）;
????}

????protected?void?Button6_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“addclass.aspx“）;
????}
????public?void?Button2_Click（object?sender?EventArgs?e）
????{
????????string?sms_sqlstr?=?“select?studentid?from?student?where?st

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-08-28?11:48??App_Code\
?????文件????????1911??2007-07-05?11:27??App_Code\Class.cs
?????文件????????9654??2007-05-08?15:25??App_Code\ClassConn.cs
?????文件?????????828??2007-07-05?11:28??App_Code\connDB.cs
?????文件????????1129??2007-05-16?10:00??App_Code\data.cs
?????目錄???????????0??2014-08-28?11:48??Bin\
?????文件???????16384??2004-04-12?11:00??Bin\dbconnection.dll
?????文件??????122880??2007-03-30?12:03??Bin\xinshouyemanager.dll
?????文件??????273920??2007-03-30?12:03??Bin\xinshouyemanager.pdb
?????目錄???????????0??2014-08-29?10:50??Css\
?????目錄???????????0??2014-08-28?11:48??DB\
?????文件?????2228224??2014-08-29?10:49??DB\student_Data.MDF
?????文件?????3932160??2014-08-29?10:49??DB\student_Log.LDF
?????文件????????1327??2007-07-05?11:04??Default.aspx
?????文件?????????430??2007-05-07?16:11??Default.aspx.cs
?????文件????????5942??2007-05-10?17:23??Department.aspx
?????文件????????4884??2007-07-05?11:28??Department.aspx.cs
?????文件????????7701??2007-05-10?15:26??Editstu.aspx
?????文件????????4528??2007-07-05?11:27??Editstu.aspx.cs
?????文件?????????948??2005-05-19?15:31??Global.asax
?????目錄???????????0??2014-08-28?11:48??Image\
?????文件????????2020??2007-05-06?13:03??Image\Mlogo.gif
?????文件????????5632??2007-05-05?19:31??Image\Thumbs.db
?????文件????????1151??2007-02-15?08:37??Image\diqu.gif
?????文件???????13166??2007-03-21?15:21??Image\e.jpg
?????文件????????1674??2007-02-15?08:37??Image\exit.gif
?????文件????????1154??2007-02-15?08:37??Image\fabu.gif
?????文件????????1044??2007-02-15?08:37??Image\fenlei.gif
?????文件????????1146??2007-02-15?08:37??Image\guanggao.gif
?????文件????????1468??2007-04-04?17:15??Image\icon_top_exit.gif
?????文件????????1492??2007-04-04?17:15??Image\icon_top_help.gif
............此處省略174個文件信息