jiankangfuwu/admin/danganUpdate.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 admin_danganUpdate : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string id = Request.QueryString["id"].ToString();
            string strsql = "select * from jiankangdangan where daID=" + id + "";//以id为条件查询
            DataTable tb = DbSQL.GetQuery(strsql);
            this.daxingming.Text = tb.Rows[0]["daxingming"].ToString();
            this.daxingbie.Text = tb.Rows[0]["daxingbie"].ToString();
            this.danianling.Text = tb.Rows[0]["danianling"].ToString();
            this.dabingshi.Text = tb.Rows[0]["dabingshi"].ToString();
            this.dadizhi.Text = tb.Rows[0]["dadizhi"].ToString();
            this.dajiuzhenshijian.Text = tb.Rows[0]["dajiuzhenshijian"].ToString();
            this.dafuyaotixing.Text = tb.Rows[0]["dafuyaotixing"].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string id = Request.QueryString["id"].ToString();
        string daxingming = this.daxingming.Text;
        string daxingbie = this.daxingbie.Text;
        string danianling = this.danianling.Text;
        string dabingshi = this.dabingshi.Text;
        string dadizhi = this.dadizhi.Text;
        string dajiuzhenshijian = this.dajiuzhenshijian.Text;
        string dafuyaotixing = this.dafuyaotixing.Text;
        //更新科普知识
        string strsql = "Update jiankangdangan set daxingming='" + daxingming + "',daxingbie='" + daxingbie + "'";
        strsql += ",danianling='" + danianling + "',dabingshi='" + dabingshi + "'";
        strsql += ",dadizhi='" + dadizhi + "',dajiuzhenshijian='" + dajiuzhenshijian + "'";
        strsql += ",dafuyaotixing='" + dafuyaotixing + "' where daID=" + id + "";
        int n = DbSQL.zhixing(strsql);
        if (n > 0)
        {
            MessageBox.ShowAndRedirect(this, "修改成功", "danganManage.aspx");
        }
        else
        {
            MessageBox.Show(this, "修改失败");
        }
    }
}