jiankangfuwu/yonghuUpdate.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class yonghuUpdate : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string id = Session["id"].ToString();
            string strsql = "select * from zinv where znID=" + id + "";//以id为条件查询
            DataTable tb = DbSQL.GetQuery(strsql);
            this.znxingming.Text = tb.Rows[0]["znxingming"].ToString();
            this.zndianhua.Text = tb.Rows[0]["zndianhua"].ToString();
            this.zndizhi.Text = tb.Rows[0]["zndizhi"].ToString();
            this.zndanwei.Text = tb.Rows[0]["zndanwei"].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string id = Session["id"].ToString();
        string znxingming = this.znxingming.Text;
        string zndianhua = this.zndianhua.Text;
        string zndizhi = this.zndizhi.Text;
        string zndanwei = this.zndanwei.Text;
        string strsql = "Update zinv set znxingming='" + znxingming + "',zndianhua='" + zndianhua + "'";
        strsql += ",zndizhi='" + zndizhi + "',zndanwei='" + zndanwei + "' where znID=" + id + "";
        int n = DbSQL.zhixing(strsql);
        if (n > 0)
        {
            MessageBox.ShowAndRedirect(this, "修改成功", "yonghuUpdate.aspx");
        }
        else
        {
            MessageBox.Show(this, "修改失败");
        }
    }
}