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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1330??2007-05-10?17:27??Web.sitemap

?????文件????????878??2007-07-05?11:29??crm_admin_main.htm

?????文件??????12447??2007-05-10?17:33??left.htm

?????文件???????1888??2007-05-05?23:02??switch.htm

?????文件???????2961??2007-05-15?14:19??top.htm

?????文件???????3314??2007-04-28?14:01??addclass.aspx.cs

?????文件???????1658??2007-04-23?09:22??addcourse.aspx.cs

?????文件???????1710??2007-04-30?11:24??addcoursetype.aspx.cs

?????文件???????1796??2007-04-30?09:29??addDepartment.aspx.cs

?????文件???????3072??2007-04-26?10:15??addgrade.aspx.cs

?????文件???????4239??2007-05-16?09:52??addlogoin.aspx.cs

?????文件???????2787??2007-04-29?11:10??addspeciality.aspx.cs

?????文件???????3267??2007-04-23?17:32??addstu.aspx.cs

?????文件???????1880??2007-04-18?11:36??addteacher.aspx.cs

?????文件???????8802??2007-07-05?11:29??class.aspx.cs

?????文件???????9782??2007-05-06?15:04??course.aspx.cs

?????文件???????4502??2007-04-30?11:25??coursetype.aspx.cs

?????文件????????430??2007-05-07?16:11??Default.aspx.cs

?????文件???????4884??2007-07-05?11:28??Department.aspx.cs

?????文件???????4528??2007-07-05?11:27??Editstu.aspx.cs

?????文件???????9852??2007-05-09?14:29??grade.aspx.cs

?????文件???????1811??2007-05-15?11:37??Logoin.aspx.cs

?????文件???????8039??2007-04-29?11:50??speciality.aspx.cs

?????文件????????952??2007-04-16?09:32??stuadd.aspx.cs

?????文件???????8361??2007-05-16?17:20??student.aspx.cs

?????文件???????5207??2007-05-16?17:20??teacher.aspx.cs

?????文件???????3813??2007-04-23?14:51??teacherlist.aspx.cs

?????文件???????1306??2007-05-17?14:04??Text.aspx.cs

?????文件???????4789??2007-07-05?11:01??Web.Config

?????文件???????1196??2007-05-07?10:23??style.css

............此處省略159個(gè)文件信息