using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.Web;
using?System.Web.SessionState;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.HtmlControls;
using?System.Configuration;

namespace?sms
{
	///?

	///?addclass?的摘要說明。
	///?

	public?class?addclass?:?System.Web.UI.Page
	{
		protected?System.Web.UI.WebControls.TextBox?Tbx_id;
		protected?System.Web.UI.WebControls.CustomValidator?Cv_id;
		protected?System.Web.UI.WebControls.RequiredFieldValidator?Rfv_id;
		protected?System.Web.UI.WebControls.TextBox?Tbx_department;
		protected?System.Web.UI.WebControls.DropDownList?Ddl_college;
		protected?System.Web.UI.WebControls.Button?Btn_add;
		protected?System.Web.UI.WebControls.Label?Lbl_note;
		protected?System.Web.UI.WebControls.TextBox?Tbx_teacher;
		protected?System.Web.UI.WebControls.TextBox?Tbx_name;
	????SqlConnection?cn;
		private?void?Page_Load（object?sender?System.EventArgs?e）
		{
			//?在此處放置用戶代碼以初始化頁面
			string?strconn=?ConfigurationSettings.AppSettings[“dsn“];
			cn=new?SqlConnection（strconn）;
			cn.Open（）;
		}

		#region?Web?Form?Designer?generated?code
		override?protected?void?OnInit（EventArgs?e）
		{
			//
			//?CODEGEN：該調用是?ASP.NET?Web?窗體設計器所必需的。
			//
			InitializeComponent（）;
			base.OnInit（e）;
		}
		
		///?

		///?設計器支持所需的方法?-?不要使用代碼編輯器修改
		///?此方法的內容。
		///?

		private?void?InitializeComponent（）
		{????
			this.Cv_id.ServerValidate?+=?new?System.Web.UI.WebControls.ServerValidateEventHandler（this.Cv_id_ServerValidate）;
			this.Btn_add.Click?+=?new?System.EventHandler（this.Btn_add_Click）;
			this.Load?+=?new?System.EventHandler（this.Page_Load）;

		}
		#endregion

		
		private?void?Cv_id_ServerValidate（object?source?System.Web.UI.WebControls.ServerValidateEventArgs?args）
		{
			SqlCommand?cm=new?SqlCommand（“select?*?from?class?where?Class_id=@Class_id“cn）;
			cm.Parameters.Add（“@Class_id“SqlDbType.VarChar50）;
			cm.Parameters[“@Class_id“].Value=Tbx_id.Text;
			SqlDataReader?dr=cm.ExecuteReader（）;
			if（dr.Read（））
			{
				args.IsValid=false;
			}
			else
			{
				args.IsValid=true;
			}
			cn.Close（）;
		}

		private?void?Btn_add_Click（object?sender?System.EventArgs?e）
		{
			SqlCommand?cm=new?SqlCommand（“insert_class_1“cn）;
			cm.CommandType=CommandType.StoredProcedure;
			cm.Parameters.Add（new?SqlParameter（“@Class_id“SqlDbType.VarChar50））;
			cm.Parameters[“@Class_id“].Value=Tbx_id.Text;
			cm.Parameters.Add（new?SqlParameter（“@Class_department“SqlDbType.VarChar50））;
			cm.Parameters[“@Class_department“].Value=Tbx_department.Text;
			cm.Parameters.Add（new?SqlParameter（“@Class_college“SqlDbType.VarChar50））;
			cm.Parameters[“@Class_college“].Value=Ddl_college.SelectedItem.Text;
			cm.Parameters.Add（new?SqlParameter（“@Class_teacherid“SqlDbType.VarChar50））;
			cm.Parameters[“@Clas

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

?????文件????1196544??2004-09-01?12:32??chap05\Database\SMS

?????目錄??????????0??2005-12-21?10:30??chap05\Database

?????文件??????23464??2004-09-01?12:32??chap05\PowerDesigner建模\SMS.cdm

?????文件??????34585??2004-09-01?12:32??chap05\PowerDesigner建模\SMS.pdm

?????文件??????11942??2004-09-01?12:32??chap05\PowerDesigner建模\SMS1.cdm

?????目錄??????????0??2005-12-21?10:30??chap05\PowerDesigner建模

?????文件??????28672??2004-09-01?12:32??chap05\readme.doc

?????文件???????3196??2004-09-01?12:32??chap05\SMS\addclass.aspx

?????文件???????3498??2004-09-01?12:32??chap05\SMS\addclass.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addclass.aspx.resx

?????文件???????3419??2004-09-01?12:32??chap05\SMS\addcourse.aspx

?????文件???????3996??2004-09-01?12:32??chap05\SMS\addcourse.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addcourse.aspx.resx

?????文件???????2601??2004-09-01?12:32??chap05\SMS\addgrade.aspx

?????文件???????4406??2004-09-01?12:32??chap05\SMS\addgrade.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addgrade.aspx.resx

?????文件???????5316??2004-09-01?12:32??chap05\SMS\addstudent.aspx

?????文件???????6160??2004-09-01?12:32??chap05\SMS\addstudent.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addstudent.aspx.resx

?????文件???????2263??2004-09-01?12:32??chap05\SMS\addstudentcourse.aspx

?????文件???????3765??2004-09-01?12:32??chap05\SMS\addstudentcourse.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addstudentcourse.aspx.resx

?????文件???????2930??2004-09-01?12:32??chap05\SMS\addteacher.aspx

?????文件???????3115??2004-09-01?12:32??chap05\SMS\addteacher.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\addteacher.aspx.resx

?????文件???????2102??2004-09-01?12:32??chap05\SMS\AssemblyInfo.cs

?????文件???????2997??2004-09-01?12:32??chap05\SMS\assigncourse.aspx

?????文件???????4131??2004-09-01?12:32??chap05\SMS\assigncourse.aspx.cs

?????文件???????1733??2004-09-01?12:32??chap05\SMS\assigncourse.aspx.resx

?????文件??????77824??2004-09-01?12:32??chap05\SMS\bin\sms.dll

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