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?Edit?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Session[“UserName“]?!=?null?&&?Session[“UserName“].ToString（）?!=?““）
????????{
????????????if?（!Page.IsPostBack）
????????????{
????????????????ShowUserInfo（）;
????????????}
????????}
????????else
????????{
????????????Response.Redirect（“Login.aspx“）;
????????}
????}
????//顯示用戶的當(dāng)前信息
????public?void?ShowUserInfo（）
????{
????????string?strConn=
????????????System.Configuration.ConfigurationManager.AppSettings[“DSN“];
????????SqlConnection?conn?=?new?SqlConnection（strConn）;
????????lblName.Text?=?Session[“UserName“].ToString（）;
????????//從數(shù)據(jù)庫讀取用戶信息
????????string?sql?=?“select?*?from?Users?where?UserName=‘“+lblName.Text+“‘“;
????????SqlCommand?cmd?=?new?SqlCommand（sqlconn）;
????????conn.Open（）;
????????SqlDataReader?reader?=?cmd.ExecuteReader（）;
????????reader.Read（）;
????????//把用戶信息顯示在頁面上
????????txtRealName.Text?=?reader[“RealName“].ToString（）;
????????lstSex.SelectedValue?=?reader[“Sex“].ToString（）;
????????lstQuestion.SelectedValue?=?reader[“Question“].ToString（）;
????????txtAnswer.Text?=?reader[“Answer“].ToString（）;
????????txtEmail.Text?=?reader[“Email“].ToString（）;
????????reader.Close（）;
????????conn.Close（）;
????}
????protected?void?btnSubmit_Click（object?sender?EventArgs?e）
????{
????????if?（Page.IsPostBack）
????????{
????????????string?strConn=
????????????????System.Configuration.ConfigurationManager.AppSettings[“DSN“];
????????????SqlConnection?conn?=?new?SqlConnection（strConn）;
????????????string?name?realName?sex?pwd?question?answer?email;
????????????//獲取用戶輸入
????????????name?=?Session[“UserName“].ToString（）;
????????????realName?=?txtRealName.Text.Trim（）;
????????????sex?=?lstSex.SelectedItem.Text.Trim（）;
????????????question?=?lstQuestion.SelectedItem.Text;
????????????answer?=?txtAnswer.Text.Trim（）;
????????????email?=?txtEmail.Text.Trim（）;
????????????//構(gòu)建UPDATE語句
????????????string?sql?=?@“update?Users?set?RealName=@RealNameSex=@SexQuestion=@QuestionAnswer=@AnswerEmail=@Email?where?UserName=‘“+name+“‘“;
????????????SqlCommand?cmd?=?new?SqlCommand（sqlconn）;
????????????//加入Command的參數(shù)
????????????cmd.Parameters.Add（new?SqlParameter（“@realName“SqlDbType.VarChar））;
????????????cmd.Parameters.Add（new?SqlParameter（“@sex“SqlDbType.VarChar））;
????????????cmd.Parameters.Add（new?SqlParameter（“@question“SqlDbType.VarChar））;
????????????cmd.Parameters.Add（new?SqlParameter（“@answer“SqlDbType.VarChar））;
????????????cmd.Parameters.Add（new?SqlParameter（“@email“SqlDbType.VarChar））;
????????????//為Command的參數(shù)賦值
????????????cmd.Parameters[“@realName“].

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

?????文件????3145728??2011-05-27?10:13??會員系統(tǒng)\demo.mdf

?????文件????1048576??2011-05-27?10:13??會員系統(tǒng)\demo_log.ldf

?????文件???????3929??2011-05-27?09:04??會員系統(tǒng)\Edit.aspx

?????文件???????3485??2011-05-27?09:24??會員系統(tǒng)\Edit.aspx.cs

?????文件???????2406??2011-05-26?17:51??會員系統(tǒng)\Login.aspx

?????文件???????2098??2011-05-26?17:51??會員系統(tǒng)\Login.aspx.cs

?????文件???????1155??2011-05-26?17:57??會員系統(tǒng)\Main.aspx

?????文件????????606??2011-05-26?18:01??會員系統(tǒng)\Main.aspx.cs

?????文件???????1804??2011-05-26?21:27??會員系統(tǒng)\Person.aspx

?????文件???????1556??2011-05-26?21:46??會員系統(tǒng)\Person.aspx.cs

?????文件???????4980??2011-05-26?20:24??會員系統(tǒng)\Register.aspx

?????文件???????2318??2011-05-26?20:27??會員系統(tǒng)\Register.aspx.cs

?????文件???????1531??2011-05-27?10:11??會員系統(tǒng)\Step2.aspx

?????文件???????1552??2011-05-27?09:43??會員系統(tǒng)\Step1.aspx

?????文件???????1104??2011-05-27?10:12??會員系統(tǒng)\Step2.aspx.cs

?????文件???????1697??2011-05-26?17:20??會員系統(tǒng)\Web.config

?????文件???????1767??2011-05-27?09:56??會員系統(tǒng)\Step1.aspx.cs

?????目錄??????????0??2011-05-27?08:17??會員系統(tǒng)

-----------?---------??----------?-----??----

??????????????4226292????????????????????18