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;
using?System.Data.SqlClient;

public?partial?class?admin?:?System.Web.UI.Page
{
????DBManage?db;
????string?strUserID;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????????if?（!Page.IsPostBack）
????????{
????????????MyBind（“select?*?from?tb_user“）;
????????????strUserID?=?Request.QueryString[“userID“].ToString（）;
????????
????????????Hyperlink1_pwd.NavigateUrl?=?“~/pwd.aspx?userID=“?+?strUserID;
????????}??

????}

????void?MyBind（String?strSql）
????{
????????db?=?new?DBManage（）;
????????db.sqlConn（）;??????
????????SqlDataAdapter?da?=?new?SqlDataAdapter（strSql?db.conn）;
????????DataSet?ds?=?new?DataSet（）;
????????da.Fill（ds）;
????????GridView1.DataSource?=?ds;
????????GridView1.DataBind（）;
????}??

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

????????string?strKey?=?TextBox1_key.Text.Trim（）;
????????string?strID?=?““;
????????if?（DropDownList1_select.Text?==?“用戶名“）
????????{
????????????strID?=?“userID“;
????????}
????????if?（DropDownList1_select.Text?==?“姓名“）
????????{
????????????strID?=?“userName“;
????????}
????????if?（DropDownList1_select.Text?==?“權限“）
????????{
????????????strID?=?“role“;
????????}

????????String?strSql?=?“select?*?from?tb_user?where?“?+?strID?+?“?like?‘“?+?strKey?+?“%‘“;

????????MyBind（strSql）;??

????}
????protected?void?GridView1_RowDeleting（object?sender?GridViewDeleteEventArgs?e）
????{
????????db?=?new?DBManage（）;
????????db.sqlConn（）;
????????
????????string?sql?=?“delete?from?tb_user?where?userID=‘“?+?GridView1.DataKeys[e.RowIndex].Value.ToString（）?+?“‘“;
????????SqlCommand?cmd?=?new?SqlCommand（sql?db.conn）;??????
????????cmd.ExecuteNonQuery（）;
????????db.closeDB（）;
????????MyBind（“select?*?from?tb_user“）;//調用MyBind（）子程序??
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-06-25?01:38??AddressBook\
?????目錄???????????0??2013-06-23?22:30??AddressBook\App_Code\
?????文件????????2594??2013-06-23?22:30??AddressBook\App_Code\DBManage.cs
?????文件????????1546??2013-06-23?16:47??AddressBook\Web.Config
?????文件?????3145728??2013-07-17?23:37??AddressBook\addressBook.mdf
?????文件?????1048576??2013-07-17?23:37??AddressBook\addressBook_log.ldf
?????文件????????3217??2013-06-25?00:04??AddressBook\admin.aspx
?????文件????????2100??2013-06-24?23:53??AddressBook\admin.aspx.cs
?????文件????????2482??2013-06-24?14:48??AddressBook\login.aspx
?????文件????????2310??2013-06-24?22:55??AddressBook\login.aspx.cs
?????文件????????5231??2013-06-24?14:48??AddressBook\mystyle.css
?????文件????????5127??2013-06-24?23:40??AddressBook\newInfo.aspx
?????文件????????2223??2013-06-24?23:40??AddressBook\newInfo.aspx.cs
?????文件????????3049??2013-06-24?09:35??AddressBook\pwd.aspx
?????文件????????1692??2013-06-24?09:42??AddressBook\pwd.aspx.cs
?????文件????????3513??2013-06-24?09:35??AddressBook\register.aspx
?????文件????????1142??2013-06-24?09:27??AddressBook\register.aspx.cs
?????文件????????3702??2013-06-25?01:36??AddressBook\userInfo.aspx
?????文件????????3857??2013-06-25?01:38??AddressBook\userInfo.aspx.cs