updatemember.aspx.cs

这是我做的第一个网络购书中心asp.net网站!

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

[Serializable]
public partial class User_UpdateMember : System.Web.UI.Page
{
    DBConn dbconn = new DBConn();
    UserInfo ui = new UserInfo();
    DataSet ds=new DataSet();
    OleDbDataAdapter da=new OleDbDataAdapter();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            getUserInfo();            
        }
    }
    
    private void getUserInfo()
    {
        if (Session["UserName"] != null)
        {
            string name = Session["UserName"].ToString();
            ds = ui.getUserInfo(name,out da);              
            txtName.Text = ds.Tables["tb_Member"].Rows[0]["Name"].ToString();
            ddlSex.SelectedIndex = Convert.ToInt32(ds.Tables["tb_Member"].Rows[0][2]);
            txtTrueName.Text = ds.Tables["tb_Member"].Rows[0]["TrueName"].ToString();
            ddlCity.SelectedValue = ds.Tables["tb_Member"].Rows[0]["City"].ToString();
            txtAddress.Text = ds.Tables["tb_Member"].Rows[0]["Address"].ToString();
            txtPostCode.Text = ds.Tables["tb_Member"].Rows[0]["PostCode"].ToString();
            txtPhone.Text = ds.Tables["tb_Member"].Rows[0]["Phonecode"].ToString();
            txtEmail.Text = ds.Tables["tb_Member"].Rows[0]["Emails"].ToString();
            ViewState["ds"] = ds;
            
        }
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        
        string name = Session["UserName"].ToString();
        ds = ui.getUserInfo(name, out da);
        if (txtPassword.Text!=ds.Tables["tb_Member"].Rows[0]["Password"].ToString())
        {
            ui.MessageBox(Page, "原密码错误");
        }
        else if (txtPawF.Text != txtPawS.Text)
        {
            ui.MessageBox(Page, "新密码和验证密码不一致");
        }
        else if (txtPawF.Text == txtPawS.Text)
        {
            string sql = "UPDATE tb_Member SET Sex ='" + ddlSex.SelectedIndex + "', [Password] ='" + txtPawS.Text
                + "', TrueName ='" + txtTrueName.Text + "',  Phonecode ='" + txtPhone.Text + "', Emails ='" + txtEmail.Text + "', City ='"
                + ddlCity.SelectedValue + "', Address ='" + txtAddress.Text + "', PostCode ='" + txtPostCode.Text + "'WHERE Name='" + name + "'";
            //ds.Tables["tb_Member"].Rows[0]["Name"] = txtName.Text;
            //ds.Tables["tb_Member"].Rows[0][2] = ddlSex.SelectedIndex;
            //ds.Tables["tb_Member"].Rows[0]["TrueName"] = txtTrueName.Text;
            //ds.Tables["tb_Member"].Rows[0]["City"] = ddlCity.SelectedValue;
            //ds.Tables["tb_Member"].Rows[0]["Address"] = txtAddress.Text;
            //ds.Tables["tb_Member"].Rows[0]["PostCode"] = txtPostCode.Text;
            //ds.Tables["tb_Member"].Rows[0]["Phonecode"] = txtPhone.Text;
            //ds.Tables["tb_Member"].Rows[0]["Emails"] = txtEmail.Text;            
            if (dbconn.upDate(sql))
                ui.MessageBox(Page, "修改成功~");
            else
                ui.MessageBox(Page, "出错，请联系管理员");
        }
    }
}