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

public?partial?class?chengjichaxun?:?System.Web.UI.Page
{
????public?static?string?kemu1;
????public?static?string?xingming1;
????public?static?string?zhanghao1;
????public?static?string?leixing1;
????SqlConnection?con?=?new?SqlConnection（“server=.;database=TestSystemDatabase;uid=shenghai;pwd=123456“）;
????SqlDataAdapter?adapter?=?new?SqlDataAdapter（）;
????DataSet?dataset?=?new?DataSet（）;
???//給datagridview綁定數據
????private?void?Binder（）
????{
????????//定義zongchengji變量用于存儲總成績
????????int?zongchengji?=?0;
????????SqlConnection?con?=?new?SqlConnection（“server=.;database=TestSystemDatabase;uid=shenghai;pwd=123456“）;
????????con.Open（）;
????????SqlDataAdapter?adapter?=?new?SqlDataAdapter（）;
????????DataSet?dataset?=?new?DataSet（）;
????????SqlCommand?mycommand?=?con.CreateCommand（）;
?????????//查找相應的記錄
????????mycommand.CommandText?=?“select?*?from?Results?where??賬號=‘“?+?zhanghao1?+?“‘or?姓名=‘“+xingming1+“‘“;
????????adapter.SelectCommand?=?mycommand;
????????dataset.Clear（）;
????????int?n=（int）adapter.Fill（dataset“chengji“）;
????????GridView1.DataSource?=?dataset;
?????????Label1.Text?=?“總成績：“;
????????if?（n?????????{
????????????lblmessage.Text?=?“沒有該同學的成績！“;
????????????Label1.Visible?=?false;
????????}
????????//計算總成績
????????for?（int?i?=?0;?i?????????{
????????????zongchengji?+=?Convert.ToInt32（dataset.Tables[“chengji“].Rows[i][“成績“]）;
????????}
????????Label1.Text?+=?“??“+zongchengji.ToString（）;
????????GridView1.DataBind（）;
????}
????//身份驗證方法
????protected?void?shenfenyanzheng（）
????{
????????//例行身份驗證
????????try
????????{
????????????kemu1?=?Session[“kemu“].ToString（）;
????????????xingming1?=?Session[“xingming“].ToString（）;
????????????zhanghao1?=?Session[“zhanghao“].ToString（）;
????????????leixing1?=?Session[“leixing“].ToString（）;
????????????con.Open（）;
????????????SqlCommand?command?=?new?SqlCommand（“select?count（*）?from?userInfo?where?賬號=‘“?+?zhanghao1?+?“‘?and?用戶類型=‘學生‘“?con）;
????????????int?i?=?（int）command.ExecuteScalar（）;
????????????con.Close（）;
????????????if?（i?<=?0）
????????????{
????????????????Response.Redirect（“denglujiemian.aspx“）;
????????????}
????????}
????????catch?（Exception?exc）
????????{
????????????Response.Write（“denglujiemian.aspx“）;
????????}
????}
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!IsPostBack）
????????{
????????????zhanghao1?=?Session[“zhanghao“].ToString（）;
????????????shenfenyanzheng（）;
????????????Binder（）;
????????}
????}
????protected?void?GridView1_PageIndexChanging（object?sender?GridViewPageEventArgs?e）
????{
????????GridView1.PageIndex?=?e.NewPageIndex;
????????Binder（）;
????}
?

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

?????文件??????13497??2008-11-17?19:25??考試系統\考試系統\544.gif

?????文件???????3311??2008-12-03?21:06??考試系統\考試系統\chengjichaxun.aspx.cs

?????文件???????2084??2008-11-25?12:11??考試系統\考試系統\Global.asax

?????文件??????15752??2008-12-04?08:48??考試系統\考試系統\jiaoshichulichengji.aspx.cs

?????文件??????15613??2008-12-03?22:01??考試系統\考試系統\kaoshijiemian.aspx.cs

?????文件??????11709??2008-12-01?09:39??考試系統\考試系統\kaotishezhi.aspx.cs

?????文件???????1546??2008-11-13?13:21??考試系統\考試系統\Web.Config

?????文件???????2917??2008-12-03?22:28??考試系統\考試系統\zhucejiemian.aspx.cs

????..A..H.?????11776??2008-12-04?23:04??考試系統\考試系統\考試系統.suo

?????文件???????1524??2008-12-04?22:57??考試系統\考試系統\文本文件\教師須知.doc

?????文件???????1599??2008-12-04?22:58??考試系統\考試系統\文本文件\學生須知.doc

?????文件???????1564??2008-12-04?22:59??考試系統\考試系統\文本文件\考試須知.doc

?????文件??????10752??2008-12-04?23:01??考試系統\考試系統\文本文件\考試須知.doc.wps

?????文件?????100817??2008-11-27?10:41??考試系統\考試系統\images\meihua.jpg

?????文件??????36670??2008-11-27?11:23??考試系統\考試系統\images\meihua2.jpg

?????文件??????15366??2008-12-04?22:51??考試系統\考試系統\jiaoshichulichengji.aspx

?????文件???????5425??2008-12-04?22:51??考試系統\考試系統\zhucejiemian.aspx

?????文件???????3143??2008-12-04?22:52??考試系統\考試系統\xueshengjiemian.aspx

?????文件??????10062??2008-12-04?22:52??考試系統\考試系統\kaotishezhi.aspx

?????文件???????5371??2008-12-04?22:53??考試系統\考試系統\kaoshijiemian.aspx

?????文件???????4727??2008-12-04?22:53??考試系統\考試系統\jiaoshijiemian.aspx

?????文件???????6339??2008-12-04?22:54??考試系統\考試系統\denglujiemian.aspx

?????文件???????4462??2008-12-04?22:54??考試系統\考試系統\chengjichaxun.aspx

?????文件???????2840??2008-12-04?22:58??考試系統\考試系統\denglujiemian.aspx.cs

?????文件???????3110??2008-12-04?22:58??考試系統\考試系統\jiaoshijiemian.aspx.cs

?????文件???????3287??2008-12-04?23:01??考試系統\考試系統\xueshengjiemian.aspx.cs

?????文件???????1549??2008-12-04?23:02??考試系統\考試系統\考試系統.sln

????..A..H.??????8704??2008-12-04?23:03??考試系統\考試系統\考試系統?（3）.suo

?????文件????1179648??2008-12-04?09:45??考試系統\考試系統\Database\TestSystemDatabase_Data.MDF

?????文件????1048576??2008-12-04?09:45??考試系統\考試系統\Database\TestSystemDatabase_Log.LDF

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