using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Data.SqlClient;
using?System.Data;

//public?class?napawo
//{
//????public?static?string?name?=?null?password?=?null;
//}

public?partial?class?_Default?:?System.Web.UI.Page
{//連接數據庫
????static?string?con?=?“Data?Source?=?localhost;?Initial?Catalog?=?test;?User?ID?=?sa;?Password?=?551188“;
????SqlConnection?mycon?=?new?SqlConnection（con）;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????if?（CheckBox1.Checked?&&?CheckBox2.Checked）
????????{
????????????Label3.Text?=?“請選擇登錄身份（學生或教師）“;
????????????return;
????????}
????????if?（!CheckBox1.Checked?&&?!CheckBox2.Checked）
????????{
????????????Label3.Text?=?“請選擇登錄身份（學生或教師）“;
????????????return;
????????}
????????if（（TextBox1.Text?==?““）||（TextBox2.Text?==?““））
????????{
????????????Label3.Text?=?“請輸入用戶名和密碼“;
????????????return;
????????}
????????mycon.Open（）;//開啟數據庫

????????if?（CheckBox2.Checked）//判斷是否為學生登錄
????????{
????????????string?name1?=?TextBox1.Text?password1?=?TextBox2.Text;
????????????string?sql?=?“select?count（*）?from?User1?where?username?=‘“?+?name1?+?“‘?AND?password?=?‘“?+?password1?+?“‘“;//獲取符合條件（where）行的數量
????????????SqlDataAdapter?myda?=?new?SqlDataAdapter（sql?mycon）;
????????????DataSet?myds?=?new?DataSet（）;//將數據庫里的表獨到Dataset對象（myds）里面
????????????myda.Fill（myds?“User1“）;
????????????if?（Convert.ToInt16（myds.Tables[“User1“].Rows[0][0]）?!=?0）
????????????{
????????????????Session[“role“]?=?“Student“;//全局變量在瀏覽器關閉之前存儲各個網頁公用數據
????????????????Session[“Pubname“]?=?name1;
????????????????Session[“Pubpassword“]?=?password1;
????????????????myds.Dispose（）;
????????????????myda.Dispose（）;
????????????????Server.Transfer（“Layout.aspx“）;//跳轉網頁，有多種方法“注意整理”
????????????}
????????????else
????????????{
????????????????Label3.Text?=?“用戶名或密碼錯誤“;
????????????????myds.Dispose（）;
????????????????myda.Dispose（）;
????????????}
????????}

????????if?（CheckBox1.Checked）//判斷是否為教師登錄
????????{
????????????string?sql?=?“select?username?password?from?t_User“;
????????????SqlDataAdapter?myda?=?new?SqlDataAdapter（sql?mycon）;
????????????DataSet?myds?=?new?DataSet（）;
????????????myda.Fill（myds?“t_User“）;
????????????for?（int?i?=?0;?i?????????????{
????????????????if?（（myds.Tables[“t_User“].Rows[i][0].ToString（）?==?TextBox1.Text）?&&?（myds.Tables[“t_User“].Rows[i][1].ToString（）?==?TextBox2.Text））
????????????????{
????????????????????Session[“role“]?=?“Teacher“;
????????????????????Session[“Pubname“]?=?TextBox1.Text;
????????????????????Session[“Pubpassword“]?=?TextBox2.Text;
????????????????????myds.Dispose（）;
????????????????????Server.Transfer（“Layout.aspx“）;
????????????????}
????????????????else
????????????????{
????????????????????Label3

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

?????文件?????190605??2014-03-27?10:35??EducationSystem\1.jpg

?????文件???????1281??2014-03-28?13:46??EducationSystem\Entry.aspx

?????文件???????3551??2014-04-02?16:37??EducationSystem\Entry.aspx.cs

?????文件???????9439??2014-04-08?13:18??EducationSystem\Layout.aspx

?????文件????????902??2014-04-09?09:23??EducationSystem\Layout.aspx.cs

?????文件????????880??2014-04-09?09:51??EducationSystem\mainpage.aspx

?????文件????????385??2014-03-31?15:03??EducationSystem\mainpage.aspx.cs

?????文件?????238126??2014-03-31?14:59??EducationSystem\mainpage.png

?????文件???????1911??2014-03-27?11:17??EducationSystem\Register.aspx

?????文件???????8809??2014-04-03?11:06??EducationSystem\Register.aspx.cs

?????文件???????3813??2014-04-08?16:30??EducationSystem\Select.aspx

?????文件??????11971??2014-04-08?14:06??EducationSystem\Select.aspx.cs

?????文件????????630??2014-03-31?15:10??EducationSystem\S_Class.aspx

?????文件???????1553??2014-04-08?13:26??EducationSystem\S_Class.aspx.cs

?????文件????????632??2014-03-31?15:06??EducationSystem\S_Information.aspx

?????文件???????1450??2014-04-08?13:43??EducationSystem\S_Information.aspx.cs

?????文件????????628??2014-03-31?15:51??EducationSystem\S_Mark.aspx

?????文件???????1530??2014-04-08?13:30??EducationSystem\S_Mark.aspx.cs

?????文件???????1381??2014-04-01?10:30??EducationSystem\T_AddClass.aspx

?????文件???????4660??2014-04-08?14:21??EducationSystem\T_AddClass.aspx.cs

?????文件???????1545??2014-04-01?09:47??EducationSystem\T_Change.aspx

?????文件???????2868??2014-04-08?14:51??EducationSystem\T_Change.aspx.cs

?????文件???????1800??2014-04-03?14:11??EducationSystem\T_ChangeMark.aspx

?????文件???????7848??2014-04-08?16:12??EducationSystem\T_ChangeMark.aspx.cs

?????文件????????630??2014-04-01?09:54??EducationSystem\T_Class.aspx

?????文件???????1510??2014-04-08?16:13??EducationSystem\T_Class.aspx.cs

?????文件???????1733??2014-04-02?15:52??EducationSystem\T_ClassMark.aspx

?????文件??????10887??2014-04-08?16:22??EducationSystem\T_ClassMark.aspx.cs

?????文件???????3783??2014-04-08?16:30??EducationSystem\T_DeleteClass.aspx

?????文件???????7516??2014-04-08?16:44??EducationSystem\T_DeleteClass.aspx.cs

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