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;

public?partial?class?Bluehills?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????public?SqlDataReader?GetUserLogin（string?sUserName?string?sPassword）
????{
????????///創(chuàng)建鏈接
????????SqlConnection?myConnection?=?new?SqlConnection（
????????????ConfigurationManager.ConnectionStrings[“dada“].ConnectionString）;

????????///定義SQL語句
????????string?cmdText?=?“SELECT?UserID?FROM?Users?WHERE?UserName?=“
????????????+?“‘“?+?sUserName.ToString（）?+?“‘“
????????????+?“?AND?Password?=“
????????????+?“‘“?+?sPassword.ToString（）?+?“‘“;
????????///創(chuàng)建Command
????????SqlCommand?myCommand?=?new?SqlCommand（cmdText?myConnection）;

????????///定義DataReader
????????SqlDataReader?dr?=?null;
????????try
????????{
????????????///打開鏈接
????????????myConnection.Open（）;
????????????///讀取數(shù)據(jù)
????????????dr?=?myCommand.ExecuteReader（CommandBehavior.CloseConnection）;
????????}
????????catch?（SqlException?ex）
????????{
????????????///拋出異常
????????????throw?new?Exception（ex.Message?ex）;
????????}
????????///返回DataReader
????????return?dr;
????}
????protected?void?MyLogin_LoggingIn（object?sender?LoginCancelEventArgs?e）
????{
????????SqlDataReader?dr?=?GetUserLogin（MyLogin.UserName?MyLogin.Password）;
????????string?sUserID?=?““;
????????if?（dr.Read（））
????????{???///獲取登錄信息
????????????sUserID?=?dr[“UserID“].ToString（）;
????????}
????????dr.Close（）;
????????if?（sUserID.Length?>?0）
????????{???///登錄成功
????????????Response.Redirect（“~/2.aspx“）;
????????}
????}



}

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

?????文件???????6893??2008-11-09?18:41??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form1.frm

?????文件?????????21??2008-11-09?18:41??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form1.frx

?????文件???????5492??2008-11-09?21:00??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form2.frm

?????文件?????????21??2008-11-09?21:00??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form2.frx

?????文件???????6990??2008-11-09?18:51??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form3.frm

?????文件?????????21??2008-11-09?18:51??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form3.frx

?????文件????????144??2008-11-09?20:54??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form3.log

?????文件???????6259??2008-11-09?18:41??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form4.frm

?????文件?????????21??2008-11-09?18:41??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\Form4.frx

?????文件???????1301??2008-11-09?20:59??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\MDIForm1.frm

?????文件?????167985??2008-11-09?20:59??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\MDIForm1.frx

?????文件???????1428??2008-11-09?21:00??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\工程1.vbp

?????文件????????254??2008-11-11?16:08??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\工程1.vbw

?????文件?????163617??2008-11-16?22:03??最終上交\數(shù)據(jù)庫課程設(shè)計\cs\1.jpg

?????文件????????737??2008-11-07?17:09??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Login.aspx

?????文件???????4142??2008-11-08?18:54??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Readsite.aspx

?????文件???????1678??2008-11-08?13:19??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Login.aspx.cs

?????文件???????3636??2008-11-08?18:51??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Addsite.aspx

?????文件???????2097??2008-11-08?13:18??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Managesite.aspx

?????文件???????1680??2008-11-08?18:48??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\site.master

?????文件???????3670??2008-11-08?18:53??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Editsite.aspx

?????文件???????3449??2008-11-08?18:52??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Deletesite.aspx

?????文件???????1907??2008-11-08?12:59??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Readsite.aspx.cs

?????文件???????1899??2008-11-08?16:17??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Addsite.aspx.cs

?????文件????????410??2008-11-07?21:34??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Deletesite.aspx.cs

?????文件????????410??2008-11-07?21:34??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Editsite.aspx.cs

?????文件????????411??2008-11-08?13:10??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\Managesite.aspx.cs

?????文件????????443??2008-11-08?12:29??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\site.master.cs

?????文件????????685??2008-11-05?15:05??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\ErrorPage.aspx.cs

?????文件???????2049??2008-11-05?15:05??最終上交\數(shù)據(jù)庫課程設(shè)計\bs\ErrorPage.aspx

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