using?System;
using?System.Collections;
using?System.ComponentModel;
using?System.Data;
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.Data.SqlClient;

namespace?GradeMis
{
	///?

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

	public?class?AdminCourse?:?System.Web.UI.Page
	{
		protected?System.Web.UI.WebControls.DataGrid?DataGrid1;
		protected?System.Web.UI.WebControls.Button?Button2;
		private?SqlConnection?conn?=?new?SqlConnection（System.Configuration.ConfigurationSettings.AppSettings[“GradeSys“]）;
	
		private?void?Page_Load（object?sender?System.EventArgs?e）
		{
			//?在此處放置用戶代碼以初始化頁面
			if（!Page.IsPostBack）
			{
				GetData（）;
			}
		}

		#region?取得數據
		private?void?GetData（）
		{
			string?sql?=?string.Empty;
			sql?=?string.Format（“select?*?from?課程表“）;
			SqlDataAdapter?da?=?new?SqlDataAdapter（sqlconn）;
			DataSet?ds?=?new?DataSet（）;
			try
			{
				da.Fill（ds“t“）;
				this.DataGrid1.DataSource?=?ds.Tables[“t“];
				this.DataGrid1.DataBind（）;
			}
			catch
			{}
		}
		#endregion
		#region?Web?窗體設計器生成的代碼
		override?protected?void?OnInit（EventArgs?e）
		{
			//
			//?CODEGEN:?該調用是?ASP.NET?Web?窗體設計器所必需的。
			//
			InitializeComponent（）;
			base.OnInit（e）;
		}
		
		///?

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

		private?void?InitializeComponent（）
		{????
			this.Button2.Click?+=?new?System.EventHandler（this.Button2_Click）;
			this.DataGrid1.CancelCommand?+=?new?System.Web.UI.WebControls.DataGridCommandEventHandler（this.DataGrid1_CancelCommand）;
			this.DataGrid1.EditCommand?+=?new?System.Web.UI.WebControls.DataGridCommandEventHandler（this.DataGrid1_EditCommand）;
			this.DataGrid1.UpdateCommand?+=?new?System.Web.UI.WebControls.DataGridCommandEventHandler（this.DataGrid1_UpdateCommand）;
			this.DataGrid1.DeleteCommand?+=?new?System.Web.UI.WebControls.DataGridCommandEventHandler（this.DataGrid1_DeleteCommand）;
			this.Load?+=?new?System.EventHandler（this.Page_Load）;

		}
		#endregion



		#region?ExeSql
		private?void?ExeSql（string?sql）
		{
			SqlCommand?cmd?=?new?SqlCommand（sqlconn）;
			try
			{
				conn.Open（）;
				cmd.ExecuteNonQuery（）;
			}
			catch（Exception?ex）
			{
				Response.Write（ex）;
			}
			finally
			{
				conn.Close（）;
			}
		}
		#endregion

		private?void?Button2_Click（object?sender?System.EventArgs?e）
		{
			Response.Redirect（“AdminCourseAdd.aspx“）;
		}

		private?void?DataGrid1_EditCommand（object?source?System.Web.UI.WebControls.DataGridCommandEventArgs?e）
		{
			this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
			GetData（）;
		}

		private?void?DataGrid1_DeleteCommand（object?source?System.Web.UI.WebControls.DataGridCommandEventArgs?e）
		{
			string?sid?=?e.Item.Cells[0].Text;
			string?sql?=?string.Format（“delete?課程表?where?課程號?=?‘{0}‘“sid）;
			ExeSql（sql）;
			this.D

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-03-11?16:42??4\
?????文件????????1529??2006-04-02?23:16??4\AdminCourse.aspx
?????文件????????3960??2006-04-02?23:16??4\AdminCourse.aspx.cs
?????文件????????1695??2006-03-30?00:05??4\AdminCourseAdd.aspx
?????文件????????2522??2006-03-30?00:05??4\AdminCourseAdd.aspx.cs
?????文件????????1042??2006-03-30?00:17??4\AdminGrade.aspx
?????文件????????2040??2009-03-12?15:16??4\AdminGrade.aspx.cs
?????文件????????2719??2006-04-02?23:19??4\AdminGradeAdd.aspx
?????文件????????2969??2006-03-30?00:50??4\AdminGradeAdd.aspx.cs
?????文件????????1825??2006-03-30?00:59??4\AdminGradeAddNext.aspx
?????文件????????2332??2006-03-30?00:59??4\AdminGradeAddNext.aspx.cs
?????文件????????2466??2006-03-30?23:58??4\AdminGroup.aspx
?????文件????????6810??2006-03-30?01:48??4\AdminGroup.aspx.cs
?????文件????????1441??2006-03-29?23:27??4\AdminGroupAdd.aspx
?????文件????????2029??2006-03-30?01:49??4\AdminGroupAdd.aspx.cs
?????文件????????1924??2006-04-02?23:04??4\AdminStu.aspx
?????文件????????6031??2006-04-02?23:26??4\AdminStu.aspx.cs
?????文件????????2791??2006-04-02?23:30??4\AdminStuAdd.aspx
?????文件????????3435??2006-04-02?23:30??4\AdminStuAdd.aspx.cs
?????文件????????2002??2006-03-31?00:30??4\AdminStuSearch.aspx
?????文件????????3479??2006-03-31?00:30??4\AdminStuSearch.aspx.cs
?????文件?????????929??2006-03-31?01:34??4\AdminStuStat.aspx
?????文件????????2045??2006-03-31?01:34??4\AdminStuStat.aspx.cs
?????文件????????1662??2006-04-02?23:26??4\AdminTeacher.aspx
?????文件????????4442??2006-04-02?23:26??4\AdminTeacher.aspx.cs
?????文件????????1509??2006-03-30?01:07??4\AdminTeacherAdd.aspx
?????文件????????2027??2006-03-30?01:07??4\AdminTeacherAdd.aspx.cs
?????文件????????1786??2006-03-29?23:02??4\AdminUrl.aspx
?????文件????????1927??2006-03-29?23:02??4\AdminUrl.aspx.cs
?????文件????????1947??2006-03-29?23:21??4\AdminUrlAdd.aspx
?????文件????????2104??2006-03-29?23:00??4\AdminUrlAdd.aspx.cs
............此處省略64個文件信息