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
{
	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（）;
			}
		}

		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
			{}
		}


		override?protected?void?OnInit（EventArgs?e）
		{
			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）;

		}


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


		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?課程號(hào)?=?‘{0}‘“sid）;
			ExeSql（sql）;
			this.DataGrid1.EditItemIndex=-1;
			GetData（）;
		
		}

		private?void?DataGrid1_CancelCommand（object?source?System.Web.UI.WebControls.DataGridCommandEventArgs?e）
		{
			this.DataGrid1.EditItemIndex=-1;
			GetData（）;
		
		}

		private?void?DataGrid1_UpdateCommand（object?source?System.Web.UI.WebControls.DataGrid

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-08-08?12:52??GradeSystem\
?????文件????????1537??2013-07-05?11:40??GradeSystem\AdminCourse.aspx
?????文件????????3564??2013-07-08?14:00??GradeSystem\AdminCourse.aspx.cs
?????文件????????1695??2006-03-30?00:05??GradeSystem\AdminCourseAdd.aspx
?????文件????????2166??2013-07-05?11:12??GradeSystem\AdminCourseAdd.aspx.cs
?????文件????????1042??2006-03-30?00:17??GradeSystem\AdminGrade.aspx
?????文件????????1632??2013-07-05?11:13??GradeSystem\AdminGrade.aspx.cs
?????文件????????2719??2006-04-02?23:19??GradeSystem\AdminGradeAdd.aspx
?????文件????????2635??2013-07-05?11:15??GradeSystem\AdminGradeAdd.aspx.cs
?????文件????????1825??2006-03-30?00:59??GradeSystem\AdminGradeAddNext.aspx
?????文件????????2252??2013-07-05?11:18??GradeSystem\AdminGradeAddNext.aspx.cs
?????文件????????2466??2006-03-30?23:58??GradeSystem\AdminGroup.aspx
?????文件????????6159??2013-07-05?11:20??GradeSystem\AdminGroup.aspx.cs
?????文件????????1441??2006-03-29?23:27??GradeSystem\AdminGroupAdd.aspx
?????文件????????1662??2013-07-05?11:21??GradeSystem\AdminGroupAdd.aspx.cs
?????文件????????1924??2006-04-02?23:04??GradeSystem\AdminStu.aspx
?????文件????????5632??2013-07-05?11:22??GradeSystem\AdminStu.aspx.cs
?????文件????????2791??2006-04-02?23:30??GradeSystem\AdminStuAdd.aspx
?????文件????????3037??2013-07-05?11:28??GradeSystem\AdminStuAdd.aspx.cs
?????文件????????2002??2006-03-31?00:30??GradeSystem\AdminStuSearch.aspx
?????文件????????3084??2013-07-05?11:25??GradeSystem\AdminStuSearch.aspx.cs
?????文件?????????929??2006-03-31?01:34??GradeSystem\AdminStuStat.aspx
?????文件????????1664??2013-07-05?11:25??GradeSystem\AdminStuStat.aspx.cs
?????文件????????1662??2006-04-02?23:26??GradeSystem\AdminTeacher.aspx
?????文件????????4035??2013-07-05?11:26??GradeSystem\AdminTeacher.aspx.cs
?????文件????????1509??2006-03-30?01:07??GradeSystem\AdminTeacherAdd.aspx
?????文件????????1689??2013-07-05?11:27??GradeSystem\AdminTeacherAdd.aspx.cs
?????文件????????1786??2006-03-29?23:02??GradeSystem\AdminUrl.aspx
?????文件????????1565??2013-07-05?11:27??GradeSystem\AdminUrl.aspx.cs
?????文件????????1947??2006-03-29?23:21??GradeSystem\AdminUrlAdd.aspx
?????文件????????1768??2013-07-05?11:28??GradeSystem\AdminUrlAdd.aspx.cs
............此處省略70個(gè)文件信息