using?System;
using?System.Collections;
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
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{if（!IsPostBack）
????????DataListBind（）;
????}
????//用于綁定DataList控件
????public?void?DataListBind（）
????{
????????//實例化公共類的對象
????????DB?db?=?new?DB（）;
????????//定義SQL語句
????????string?sqlstr?=?“select?*?from?tb_User?where?UserID=1“;
????????//實例化數據集DataTable用于存儲查詢結果
????????DataTable?dt?=?db.reDt（sqlstr）;
????????//綁定DataList控件
????????DataList1.DataSource?=?dt;//設置數據源，用于填充控件中的項的值列表
????????DataList1.DataBind（）;//將控件及其所有子控件綁定到指定的數據源
????}
????protected?void?DataList1_CancelCommand（object?source?DataListCommandEventArgs?e）
????{
????????//設置DataList1控件的編輯項的索引為－1，即取消編輯
????????DataList1.EditItemIndex?=?-1;
????????//數據綁定
????????DataListBind（）;
????}
????protected?void?DataList1_DeleteCommand（object?source?DataListCommandEventArgs?e）
????{
????????//實例化公共類的對象
????????DB?db?=?new?DB（）;
????????string?userID?=?e.CommandArgument.ToString（）;
????????string?sqlStr?=?“delete?from?tb_User?where?UserID=“?+?userID;
????????//更新數據庫，變量reValue用于保存執行Sql語句的返回值，成功為１，失敗為０
????????int?reValue?=?db.sqlEx（sqlStr）;
????????if?（reValue?==?0）
????????????Response.Write（“ript>alert（‘刪除失敗！‘）;ript>“）;
????????//重新綁定
????????DataListBind（）;
????}
????protected?void?DataList1_EditCommand（object?source?DataListCommandEventArgs?e）
????{
????????//設置DataList1控件的編輯項的索引為選擇的當前索引
????????DataList1.EditItemIndex?=?e.Item.ItemIndex;
????????//數據綁定
????????DataListBind（）;
????}
????protected?void?DataList1_UpdateCommand（object?source?DataListCommandEventArgs?e）
????{

????????//實例化公共類的對象
????????DB?db?=?new?DB（）;
????????//取得文本框中輸入的內容
????????string?userName?=?（（Label）e.Item.FindControl（“lblUserName“））.Text;
????????string?oldpassWord?=?（（TextBox）e.Item.FindControl（“txtOldpwd“））.Text;
????????string?newpassWord?=?（（TextBox）e.Item.FindControl（“txtNewpwd“））.Text;
????????if?（db.GetMD5（oldpassWord）?==?e.CommandArgument.ToString（））
????????{
????????????string?sqlStr?=?“update?tb_User?set?PassWord=‘“?+?db.GetMD5（newpassWord）?+?“‘where?UserName=‘“?+?userName?+?“‘“;
????????????//更新數據庫，變量reValue用于保存執行Sql語句的返回值，成功為１，失敗為０
????????????int?reValue?=?db.sqlEx（sqlStr）;

????????????if?（reValue?==?0）
????????????????Response.Write（“ript>alert（‘密碼修改失敗！‘）;ript>“）;
????????????else
????????????????Response.Write（“ript>alert（‘您的密碼已經成功修改！‘）;ript>“）;
????????????//取消編輯狀態
????????????DataList1.EditItemIndex?=?-1;
????????????DataListBind（）;
????????}
????????else
????????{
????????????Response.Write（“ript>alert（‘您輸入的舊密碼不正確。您的密碼沒有被更改。‘）;ript>“）;
??

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-27?12:08??chap23\
?????目錄???????????0??2018-05-21?07:58??chap23\App_Code\
?????文件????????3714??2010-02-11?10:25??chap23\App_Code\DB.cs
?????目錄???????????0??2018-05-21?07:59??chap23\App_Data\
?????文件?????3145728??2018-06-27?13:49??chap23\App_Data\db_Student.mdf
?????文件?????1048576??2018-06-27?13:49??chap23\App_Data\db_Student_log.ldf
?????文件????????9002??2017-04-10?10:00??chap23\Default.aspx
?????文件????????6141??2017-04-10?09:51??chap23\Default.aspx.cs
?????目錄???????????0??2018-05-21?07:59??chap23\Image\
?????文件???????25600??2007-04-05?16:32??chap23\Image\Thumbs.db
?????文件???????64615??2007-03-14?15:28??chap23\Image\注冊.jpg
?????文件???????44727??2007-03-14?15:31??chap23\Image\用戶管理.jpg
?????文件???????19783??2007-03-16?15:24??chap23\Image\用戶管理Bottom.jpg
?????文件???????24928??2007-03-16?15:24??chap23\Image\用戶管理Head.jpg
?????文件???????49512??2007-03-14?15:25??chap23\Image\登錄.jpg
?????文件????????2369??2018-06-27?11:57??chap23\Login.aspx
?????文件????????1975??2017-04-10?09:54??chap23\Login.aspx.cs
?????文件????????4631??2017-04-09?08:41??chap23\Register.aspx
?????文件????????3427??2017-04-09?08:47??chap23\Register.aspx.cs
?????文件???????11065??2018-06-27?12:07??chap23\UserManagement.aspx
?????文件????????7531??2009-11-30?19:17??chap23\UserManagement.aspx.cs
?????文件?????????448??2007-03-12?09:12??chap23\ValidateNum.aspx
?????文件????????3810??2017-04-10?10:43??chap23\ValidateNum.aspx.cs
?????文件????????7962??2017-04-09?08:40??chap23\web.config