資源簡介
通過該系統，學校不同角色的用戶可以通過網路完成選課系統功能：管理員通過該系統實現對學生、教師、課程的添加和維護和學生成績的維護；教師通過該系統實現查看課程選修情況和錄入學生成績；學生通過該系統實現選課、退課等功能；還有公有模塊：修改密碼功能。
\MyElectCourse \DB \MyElectCourse.sql 網上選課系統數據數據庫創建腳本
\MyElectCourse \DB \MyElectCourse.bak 網上選課系統數據數據庫備份
\MyElectCourse \Images\ 網上選課系統圖片文件夾
\MyElectCourse \Controls\left.ascx 網上選課系統用戶控件
\MyElectCourse \Login.aspx 登錄頁面
\MyElectCourse \Main.aspx 管理員主頁面
\MyElectCourse \adminStudentAdd.aspx 添加學生頁面
\MyElectCourse \adminStudentDetails.aspx 學生維護頁面
\MyElectCourse \adminCourse.aspx 添加課程頁面
\MyElectCourse \adminCourseDetails.aspx 課程維護頁面
\MyElectCourse \adminTeacherAdd.aspx 添加教師頁面
\MyElectCourse \adminTeacherDetails.aspx 教師維護頁面
\MyElectCourse \adminStudentScore.aspx 成績維護頁面
\MyElectCourse \studentElect.aspx 學生選課頁面
\MyElectCourse \courseDetail.aspx 課程詳細信息頁面
\MyElectCourse \teacherQueryElect.aspx 教師查詢選課情況頁面
\MyElectCourse \teacherSubmitScore.aspx 教師提交成績頁面
\MyElectCourse \ModifyPwd.aspx 修改密碼頁面
代碼片段和文件信息
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?adminCourse?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!this.IsPostBack）
????????{
????????????ddlBind（）;
????????????CourceDetailsShow（）;
????????}
????}
????private?void?ddlBind（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?teaIDteaName?from?Teacher“;
????????DataSet?ds?=?new?DataSet（）;
????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創建連接對象
????????if?（conn.State.ToString（）?==?“Closed“）??????????????//如果連接關閉打開
????????????conn.Open（）;
????????SqlDataAdapter?da?=?new?SqlDataAdapter（SqlStr?conn）;
????????da.Fill（ds）;????????????????????????????????????????//從數據庫中取數據放到DataSet數據集中
????????if?（conn.State.ToString（）?==?“Open“）
????????????conn.Close（）;
????????ddlTeacherName.DataSource?=?ds.Tables[0].DefaultView;
????????ddlTeacherName.DataTextField?=?“teaName“;?????????????//下拉列表框每項顯示教師姓名
????????ddlTeacherName.DataValueField?=?“teaID“;??????????????//下拉列表框每項的值為教師編號
????????ddlTeacherName.DataBind（）;????????
????}
????private?void?CourceDetailsShow（）
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings[“ConnectionString“].ConnectionString;???//取出連接字符串
????????string?SqlStr?=?“SELECT?Cource.*Teacher.teaName?from?CourceTeacher?where?Cource.teaID=Teacher.teaID?and?Cource.courceID=‘“?+?Request[“courceID“].ToString（）?+?“‘?and?Cource.teaID=‘“?+?Request[“teaID“].ToString（）?+?“‘“;
????????SqlConnection?conn?=?new?SqlConnection（connStr）;????//創建連接對象
????????try
????????{
????????????if?（conn.State.ToString（）?==?“Closed“）??????????//連接如果關閉，打開
????????????????conn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（SqlStr?conn）;
????????????SqlDataReader?sdr?=?cmd.ExecuteReader（）;
????????????if?（sdr.Read（））
????????????{
????????????????courceName.Text?=?sdr[“courceName“].ToString（）;
????????????????txtName.Text?=?sdr[“courceName“].ToString（）;
????????????????ddlTeacherName.SelectedItem.Text?=?sdr[“teaName“].ToString（）;
????????????????txtTime.Text?=?sdr[“courceTime“].ToString（）;
????????????????txtAddress.Text?=?sdr[“courceAddress“].ToString（）;
????????????????txtDetails.Text?=?sdr[“courceInfo“].ToString（）;
????????????}
????????????else
????????????{
????????????????Response.Write（“數據庫錯誤，沒查詢到該門課程！“）;
????????????????Response.End（）;
????????????}
????????}
????????catch?（Exception?ex）????????????????????????????????//異常處理
????????{
????????????Response.Write（“數據庫錯誤，錯誤原因：“?+?ex.Message）;
????????????Response.End（）;
????????}
????????finally
????????{
????????????if?（conn.State.To ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????2330??2007-03-05?17:25??網上選課系統\MyElectCourse\adminCourse.aspx
?????文件???????4908??2007-03-05?17:25??網上選課系統\MyElectCourse\adminCourse.aspx.cs
?????文件???????9713??2007-03-05?17:25??網上選課系統\MyElectCourse\adminCourseDetails.aspx
?????文件???????8518??2007-03-05?17:25??網上選課系統\MyElectCourse\adminCourseDetails.aspx.cs
?????文件???????3516??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentAdd.aspx
?????文件???????2607??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentAdd.aspx.cs
?????文件???????4824??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentDetails.aspx
?????文件???????7840??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentDetails.aspx.cs
?????文件???????3574??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentScore.aspx
?????文件???????8329??2007-03-05?17:25??網上選課系統\MyElectCourse\adminStudentScore.aspx.cs
?????文件???????2227??2007-03-05?17:25??網上選課系統\MyElectCourse\adminTeacherAdd.aspx
?????文件???????2420??2007-03-05?17:25??網上選課系統\MyElectCourse\adminTeacherAdd.aspx.cs
?????文件???????3328??2007-03-05?17:25??網上選課系統\MyElectCourse\adminTeacherDetails.aspx
?????文件???????5711??2007-03-05?17:25??網上選課系統\MyElectCourse\adminTeacherDetails.aspx.cs
?????文件???10485760??2007-03-05?17:25??網上選課系統\MyElectCourse\App_Data\ASPNETDB.MDF
?????文件?????516096??2007-03-05?17:25??網上選課系統\MyElectCourse\App_Data\aspnetdb_log.ldf
?????文件???????2224??2007-03-05?17:25??網上選課系統\MyElectCourse\Controls\left.ascx
?????文件????????534??2007-03-05?17:25??網上選課系統\MyElectCourse\Controls\left.ascx.cs
?????文件???????1977??2007-03-05?17:25??網上選課系統\MyElectCourse\courseDetail.aspx
?????文件???????2461??2007-03-05?17:25??網上選課系統\MyElectCourse\courseDetail.aspx.cs
?????文件???????9502??2007-03-05?17:25??網上選課系統\MyElectCourse\DB\ElectClass.sql
?????文件???????1265??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\ADD.GIF
?????文件???????1056??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\Close.GIF
?????文件????????505??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\CONFIRM.GIF
?????文件???????1584??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\FangKuai.gif
?????文件???????1073??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\Login.GIF
?????文件????????322??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\mm.gif
?????文件????????922??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\movetool1.gif
?????文件????????171??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\movetoolright1.gif
?????文件????????988??2007-03-05?17:25??網上選課系統\MyElectCourse\Images\name.gif
............此處省略30個文件信息
- 上一篇：個人簡歷c#寫的
- 下一篇：先知新聞發布系統 ASP.NET動態新聞網站
評論
共有 條評論
川公網安備 51152502000135號