using?System;
using?System.Data;
using?System.Configuration;
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?_Default?:?System.Web.UI.Page?
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????Labtime.Text?=?DateTime.Now.ToString（“yyyy年MM月dd日“）;//當前時間
????????Session[“userName“]?=?this.txtUserName.Text;//保存當前用戶名
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????//登錄
????????if?（cbAdmin.Checked?==?true）//如果選中則執行case2進入后臺管理頁面
????????{
????????????this.getcom（2）;
????????}
????????else
????????{
????????????this.getcom（1）;
????????}
????}
????private?void?getcom（int?i）
????{
????????SqlConnection?con?=?DB_Con.createConnection（）;//調用DB_Con數據庫連接類的方法連接數據庫
????????con.Open（）;
????????SqlCommand?com?=?con.CreateCommand（）;
????????//登錄控制
????????switch?（i）
????????{
????????????case?1:
????????????????com.CommandText?=?“select?count（*）?from?Tuser?where?userName=‘“?+?txtUserName.Text?+?“‘?and?userPwd=‘“?+?txtUserPwd.Text?+?“‘“;//判斷用戶
????????????????int?count1?=?Convert.ToInt32（com.ExecuteScalar（））;
????????????????if?（count1?>?0）
????????????????{
????????????????????Response.Redirect（“qmain.aspx“）;
????????????????}
????????????????else
????????????????{
????????????????????Response.Write（“ript?lanuage=javascript>alert（‘用戶名或密碼有誤!請重新登錄...‘）;location.href=locationript>“）;
????????????????????return;
????????????????}
????????????????break;
????????????case?2:
????????????????com.CommandText?=?“select?count（*）?from?TAdministrator?where?adName=‘“?+?txtUserName.Text?+?“‘?and?adPwd=‘“?+?txtUserPwd.Text?+?“‘“;
????????????????int?count2?=?Convert.ToInt32（com.ExecuteScalar（））;
????????????????if?（count2?>?0）
????????????????{
????????????????????Response.Redirect（“hmain.aspx“）;
????????????????}
????????????????else
????????????????{
????????????????????Response.Write（“ript?lanuage=javascript>alert（‘用戶名或密碼有誤!請重新登錄...‘）;location.href=locationript>“）;
????????????????????return;
????????????????}
????????????????break;
????????}
????????con.Close（）;
????}

????
???????
????protected?void?btnClose_Click（object?sender?EventArgs?e）
????{
????????this.txtUserName.Text?=?““;
????????this.txtUserPwd.Text?=?““;
????}
????protected?void?linkButton1_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“zhuce.aspx“）;
????}
????protected?void?linkButton2_Click（object?sender?EventArgs?e）
????{
????????Response.Redirect（“gengdou.aspx“）;
????}
}

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

?????文件??????12800??2009-03-22?20:42??ASP.NET+SQL社區居民管理系統\源代碼\b-PPTxiazhai\第一章.ppt

?????文件??????12800??2009-03-22?20:43??ASP.NET+SQL社區居民管理系統\源代碼\b-PPTxiazhai\第三章.ppt

?????文件??????12800??2009-03-22?20:43??ASP.NET+SQL社區居民管理系統\源代碼\b-PPTxiazhai\第二章.ppt

?????文件??????12800??2009-03-22?20:43??ASP.NET+SQL社區居民管理系統\源代碼\b-PPTxiazhai\第五章.ppt

?????文件??????12800??2009-03-22?20:43??ASP.NET+SQL社區居民管理系統\源代碼\b-PPTxiazhai\第四章.ppt

?????文件??????24064??2009-03-22?22:39??ASP.NET+SQL社區居民管理系統\源代碼\b-xitixiazhai\練習題.doc

?????文件???????8297??2009-04-05?02:14??ASP.NET+SQL社區居民管理系統\源代碼\Default.aspx

?????文件???????2865??2009-04-10?02:44??ASP.NET+SQL社區居民管理系統\源代碼\Default.aspx.cs

?????文件????????785??2009-03-20?03:55??ASP.NET+SQL社區居民管理系統\源代碼\gengdou.aspx

?????文件????????532??2009-03-20?03:55??ASP.NET+SQL社區居民管理系統\源代碼\gengdou.aspx.cs

?????文件???????6849??2009-04-17?03:22??ASP.NET+SQL社區居民管理系統\源代碼\hadmininsert.aspx

?????文件???????3312??2009-04-17?03:22??ASP.NET+SQL社區居民管理系統\源代碼\hadmininsert.aspx.cs

?????文件??????12587??2009-04-06?22:22??ASP.NET+SQL社區居民管理系統\源代碼\hbbs.aspx

?????文件???????1547??2009-04-06?14:18??ASP.NET+SQL社區居民管理系統\源代碼\hbbs.aspx.cs

?????文件??????11854??2009-04-06?22:22??ASP.NET+SQL社區居民管理系統\源代碼\hmain.aspx

?????文件???????2153??2009-04-06?14:19??ASP.NET+SQL社區居民管理系統\源代碼\hmain.aspx.cs

?????文件??????13386??2009-04-06?22:22??ASP.NET+SQL社區居民管理系統\源代碼\hpinjia.aspx

?????文件???????1549??2009-04-06?14:19??ASP.NET+SQL社區居民管理系統\源代碼\hpinjia.aspx.cs

?????文件???????7403??2009-04-06?22:22??ASP.NET+SQL社區居民管理系統\源代碼\hqmain.aspx

?????文件???????1548??2009-04-06?14:16??ASP.NET+SQL社區居民管理系統\源代碼\hqmain.aspx.cs

?????文件??????10322??2009-04-06?21:50??ASP.NET+SQL社區居民管理系統\源代碼\hquestion.aspx

?????文件???????1680??2009-04-06?19:53??ASP.NET+SQL社區居民管理系統\源代碼\hquestion.aspx.cs

?????文件???????6299??2009-04-06?21:40??ASP.NET+SQL社區居民管理系統\源代碼\hquestionAdd.aspx

?????文件???????1978??2009-04-06?21:47??ASP.NET+SQL社區居民管理系統\源代碼\hquestionAdd.aspx.cs

?????文件??????12270??2009-04-06?21:40??ASP.NET+SQL社區居民管理系統\源代碼\hquestionAdd2.aspx

?????文件??????16255??2009-04-07?10:43??ASP.NET+SQL社區居民管理系統\源代碼\hquestionAdd2.aspx.cs

?????文件???????8292??2009-04-10?05:28??ASP.NET+SQL社區居民管理系統\源代碼\hresult.aspx

?????文件???????1548??2009-04-06?14:26??ASP.NET+SQL社區居民管理系統\源代碼\hresult.aspx.cs

?????文件???????7366??2009-04-06?22:22??ASP.NET+SQL社區居民管理系統\源代碼\htaoti.aspx

?????文件???????1548??2009-04-06?14:28??ASP.NET+SQL社區居民管理系統\源代碼\htaoti.aspx.cs

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