資源簡介
這是用SQL和ASP.NET設計的一個動態網頁,可以實現用戶登錄,用戶管理,忘記密碼,修改密碼,并留言等功能~我們老師做的,讓我們作參考~

代碼片段和文件信息
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?
{
????int?usType;
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
???????
????}
????
????protected?void?btnLogin_Click(object?sender?EventArgs?e)
????{
?????
????????string?strSel=““;??
????????string?strCon?=?“server=(local);database=chart;Integrated?Security=True“;
????????SqlConnection?con?=?new?SqlConnection(strCon);
????????con.Open();
????????if(rblUser.Items?[0].Selected?)
????????????strSel?=?“select?*?from?usinfio?where?u_name=‘“?+?txtUsname.Text?+?“‘?and?u_password=‘“?+?txtPwd.Text?+?“‘“;
????????else
????????????strSel?=?“select?*?from?manager?where?u_name=‘“?+?txtUsname.Text?+?“‘?and?u_password=‘“?+?txtPwd.Text?+?“‘“;
????????
????????SqlCommand?cmd?=?new?SqlCommand(strSel?con);
????????SqlDataReader?dr?=?cmd.ExecuteReader();
????????if?(dr.Read())
????????{???Session[“name“]?=?txtUsname.Text;
????????????Response.Redirect(“Msg.aspx“);
????????????
????????}
????????else
????????????Response.Write(“ript>alert(‘用戶名或密碼錯誤,請重新登錄!‘) ript>“);
????}
????protected?void?rblUser_SelectedIndexChanged(object?sender?EventArgs?e)
????{
????????if?(rblUser.SelectedValue?==?“1“)
????????????rblUser?.Items?[0].Selected?=true?;
????????//?
????????else?if?(rblUser.SelectedValue?==?“2“)
????????????rblUser.Items?[1].Selected?=true?;
????????//?
????????else
????????????Response.Write(“ript>alert(‘請選擇用戶類型!‘) ript>“);
????}
????protected?void?btnReg_Click(object?sender?EventArgs?e)
????{
????????Response.Redirect(“~/Reg.aspx“);
????}
????protected?void?btnRcove_Click(object?sender?EventArgs?e)
????{
????????if?(txtUsname.Text?==?““)
????????????Response.Write(“ript>alert(‘請輸入用戶名!‘) ript>“);
????????else
????????{
????????????Session[“nm“]?=?txtUsname.Text;
????????????Response.Redirect(“~/recover.aspx“);
????????}
????}
????protected?void?btnManage_Click(object?sender?EventArgs?e)
????{
????????string?strSel?=?““;
????????string?strCon?=?“server=(local);database=chart;Integrated?Security=True“;
????????SqlConnection?con?=?new?SqlConnection(strCon);
????????con.Open();
????????if?(rblUser.Items[0].Selected)
????????????Response.Write(“ript>alert(‘只有管理員才能執行此功能!‘) ript>“);
????????else
????????{
????????????strSel?=?“select?*?from?manager?where?u_name=‘“?+?txtUsname.Text?+?“‘?and?u_password=‘“?+?txtPwd.Text?+?“‘“;
????????????SqlCommand?cmd?=?new?SqlCommand(strSel?con);
????????????SqlDataReader?dr?=?cmd.ExecuteReader();
????????????if?(dr.Read())
????????????{
????????????????Session[“name“]?=?txtUsname.Text;
????????????????Response.Redirect(“manage.aspx“);
????????????}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????2927??2012-12-03?08:55??Message\Login.aspx
?????文件???????3236??2012-12-03?08:55??Message\Login.aspx.cs
?????文件???????2739??2012-12-03?09:28??Message\manage.aspx
?????文件???????2004??2012-12-03?09:28??Message\manage.aspx.cs
?????文件???????2323??2012-12-02?11:03??Message\Msg.aspx
?????文件???????2426??2012-12-02?11:21??Message\Msg.aspx.cs
?????文件???????2573??2012-12-03?08:39??Message\recover.aspx
?????文件???????2802??2012-12-03?08:55??Message\recover.aspx.cs
?????文件???????2629??2012-12-02?11:21??Message\Reg.aspx
?????文件???????2308??2012-12-02?11:22??Message\Reg.aspx.cs
?????文件???????1825??2012-12-03?08:08??Message\web.config
?????目錄??????????0??2012-12-02?10:10??Message\App_Data
?????目錄??????????0??2012-12-03?09:40??Message
?????文件????1835008??2012-12-03?09:41??Message\App_Data\chart_Data.MDF
?????文件????3211264??2012-12-03?09:41??Message\App_Data\chart_Log.LDF
-----------?---------??----------?-----??----
??????????????5074064????????????????????15
- 上一篇:共享單車騎行數據分析
- 下一篇:用ASP.NET實現簡單的辦公用品管理系統
評論
共有 條評論