Web/mem/Modi.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using UBW.Common;

public partial class mem_Default : System.Web.UI.Page
{
    UBW.BLL.members bll = new UBW.BLL.members();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack && Session["lname"]!=null)
        {
            chushi();
        }
    }

    /// <summary>
    /// 初始化
    /// </summary>
    protected void chushi()
    {

        //根据编号得到相应的记录
        DataSet ds = bll.GetData("*","lname='" + Session["lname"].ToString() + "' ");
        if (ds.Tables[0].Rows.Count > 0)
        {
            txt_lname.Text = ds.Tables[0].Rows[0]["lname"].ToString();    
            txt_mname.Text = ds.Tables[0].Rows[0]["mname"].ToString();
            rtsex.SelectedValue = ds.Tables[0].Rows[0]["sex"].ToString();
            txt_tel.Text = ds.Tables[0].Rows[0]["tel"].ToString();
            txt_address.Text = ds.Tables[0].Rows[0]["address"].ToString();

        }
    }

    /// <summary>
    /// 编辑
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {


        //提交到数据库
        bll.ExecuteUpdate(" mname='" + txt_mname.Text + "',sex='" + rtsex.SelectedValue + "',tel='" + txt_tel.Text + "',address='" + txt_address.Text + "' ", " lname='" + txt_lname.Text + "' ");

       Msg.Show( "修改成功！");
    }
}