using?System;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;

using?System.Data.SqlClient;


public?partial?class?_Default?:?System.Web.UI.Page
{
????public?SqlConnection?sqlConection;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????//?string?sqlCon?=?“Server=userb28\\sqlexpress;Database=1;uid=01;PassWord=123“;
????????string?sqlCon?=?“Server=userb28\\sqlexpress;database=1;Integrated?Security=SSPI;“;
????????sqlConection?=?new?SqlConnection（sqlCon）;
????????if?（sqlConection.State?==?ConnectionState.Open）
????????????sqlConection.Close（）;
????????sqlConection.Open（）;
????????//?if?（sqlConection.State?==?ConnectionState.Open）
????????//?Response.Write（“ript>alert（‘數據庫連接成功‘）ript>“）;
????????//?sqlConection.Open（）;
????}
????protected?void?btnLogin_Click（object?sender?EventArgs?e）
????{


????}
????//?protected?void?TextBox1_TextChanged（object?sender?EventArgs?e）
????//{

????//?}
????//?protected?void?Button1_Click（object?sender?EventArgs?e）
????//{

????//?}
????protected?void?Button2_Click（object?sender?EventArgs?e）
????{

????????string?cmd?=?“select?*?from?登錄表?where?登錄名=‘“?+?txtusername.Text?+?“‘?and?密碼=‘“?+?txtpassword.Text?+?“‘“;
????????//?Response.Write（cmd）;
????????SqlCommand?sqlCommand?=?new?SqlCommand（cmd?sqlConection）;
????????SqlDataReader?sqlDataRead?=?sqlCommand.ExecuteReader（）;
????????if?（sqlDataRead.HasRows?==?true）
????????{
????????????Response.Write（“ript>alert（‘恭喜你登錄成功‘）ript>“）;
????????????Response.Redirect（“Default2.aspx“）;
????????}
????????else
????????????Response.Write（“ript>alert（‘你沒有權限‘）ript>“）;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????txtusername.Text?=?““;
????????txtpassword.Text?=?““;
????}
}

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

?????文件????1048576??2014-06-09?17:31??1_log.ldf

?????文件????????464??2014-06-09?16:07??教師查詢系統數據庫\App_Code\Class1.cs

?????文件???????1602??2014-06-16?15:28??教師查詢系統數據庫\App_Code\DBoperation.cs

?????文件???????1286??2014-06-16?15:26??教師查詢系統數據庫\App_Code\Logic.cs

?????文件???????2709??2014-05-22?15:52??教師查詢系統數據庫\Default.aspx

?????文件???????2079??2014-05-26?17:19??教師查詢系統數據庫\Default.aspx.cs

?????文件???????2232??2014-05-26?16:16??教師查詢系統數據庫\Default2.aspx

?????文件???????4934??2014-06-16?17:38??教師查詢系統數據庫\Default2.aspx.cs

?????文件???????2419??2014-06-09?16:48??教師查詢系統數據庫\Detailmessage.aspx

?????文件????????587??2014-06-09?16:49??教師查詢系統數據庫\Detailmessage.aspx.cs

?????文件???????7572??2014-06-09?16:56??教師查詢系統數據庫\others.aspx

?????文件???????2395??2014-06-16?17:22??教師查詢系統數據庫\others.aspx.cs

?????文件???????8428??2014-06-05?15:06??教師查詢系統數據庫\web.config

?????文件????3145728??2014-06-09?17:31??1.mdf

?????目錄??????????0??2014-06-26?17:00??教師查詢系統數據庫\App_Code

?????目錄??????????0??2014-06-05?14:40??教師查詢系統數據庫\App_Data

?????目錄??????????0??2014-06-26?17:00??教師查詢系統數據庫

-----------?---------??----------?-----??----

??????????????4231011????????????????????17