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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????6209??2007-05-10?17:29??葛芳芳\代碼\addclass.aspx

?????文件???????3314??2007-04-28?14:01??葛芳芳\代碼\addclass.aspx.cs

?????文件???????7345??2007-05-10?17:14??葛芳芳\代碼\addcourse.aspx

?????文件???????1658??2007-04-23?09:22??葛芳芳\代碼\addcourse.aspx.cs

?????文件???????4334??2007-04-30?11:20??葛芳芳\代碼\addcoursetype.aspx

?????文件???????1710??2007-04-30?11:24??葛芳芳\代碼\addcoursetype.aspx.cs

?????文件???????5025??2007-04-30?09:28??葛芳芳\代碼\addDepartment.aspx

?????文件???????1796??2007-04-30?09:29??葛芳芳\代碼\addDepartment.aspx.cs

?????文件???????6221??2007-05-10?17:49??葛芳芳\代碼\addgrade.aspx

?????文件???????3072??2007-04-26?10:15??葛芳芳\代碼\addgrade.aspx.cs

?????文件???????3939??2007-05-15?16:45??葛芳芳\代碼\addlogoin.aspx

?????文件???????4239??2007-05-16?09:52??葛芳芳\代碼\addlogoin.aspx.cs

?????文件???????6066??2007-04-29?11:58??葛芳芳\代碼\addspeciality.aspx

?????文件???????2787??2007-04-29?11:10??葛芳芳\代碼\addspeciality.aspx.cs

?????文件???????7798??2007-05-10?17:22??葛芳芳\代碼\addstu.aspx

?????文件???????3267??2007-04-23?17:32??葛芳芳\代碼\addstu.aspx.cs

?????文件???????8322??2007-05-10?17:20??葛芳芳\代碼\addteacher.aspx

?????文件???????1880??2007-04-18?11:36??葛芳芳\代碼\addteacher.aspx.cs

?????文件???????1857??2009-04-04?14:26??葛芳芳\代碼\App_Code\Class.cs

?????文件???????9628??2009-04-04?14:24??葛芳芳\代碼\App_Code\ClassConn.cs

?????文件????????776??2009-04-04?14:20??葛芳芳\代碼\App_Code\connDB.cs

?????文件???????1129??2007-05-16?10:00??葛芳芳\代碼\App_Code\data.cs

?????文件????1310720??2009-05-21?22:09??葛芳芳\代碼\App_Data\student_Data.MDF

?????文件????1048576??2009-05-21?22:09??葛芳芳\代碼\App_Data\student_Log.LDF

?????文件???????5299??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\CSs\default.css

?????文件????????602??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendar.html

?????文件?????????95??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendarbottom.html

?????文件?????????92??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\calendartop.html

?????文件???????2189??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\crystalexportdialog.htm

?????文件???????2707??2005-09-23?07:56??葛芳芳\代碼\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\crystalprinthost.html

............此處省略166個文件信息