qiye/gangweiUpdate.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 qiye_gangweiUpdate : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Info();
        }
    }
    private void Info()
    {
        string id = Request.QueryString["ID"];
        DataSet ds = sqlconn.dataquery("select * from gangwei where ID=" + id + "");
        if (ds.Tables[0].Rows.Count > 0)
        {
            this.mingcheng.Text = ds.Tables[0].Rows[0]["gangweiName"].ToString();
            this.yuexin.Text = ds.Tables[0].Rows[0]["yuexin"].ToString();
            this.renshu.Text = ds.Tables[0].Rows[0]["renshu"].ToString();
            this.xueli.Text = ds.Tables[0].Rows[0]["xueli"].ToString();
            this.jingyan.Text = ds.Tables[0].Rows[0]["jingyan"].ToString();
            this.zhize.Text = ds.Tables[0].Rows[0]["zhize"].ToString();
            this.yaoqiu.Text = ds.Tables[0].Rows[0]["yaoqiu"].ToString();

        }
    }
    protected void btnAdd_Click(object sender, ImageClickEventArgs e)
    {
        string id = Request.QueryString["ID"];
        string mingcheng = this.mingcheng.Text;
        string yuexin = this.yuexin.Text;
        string renshu = this.renshu.Text;
        string xueli = this.xueli.Text;
        string jingyan = this.jingyan.Text;
        string zhize = this.zhize.Text;
        string yaoqiu = this.yaoqiu.Text;
        string riqi = this.riqi.Text;
        string strsql = " Update gangwei set gangweiname='" + mingcheng + "',yuexin='" + yuexin + "',renshu='" + renshu + "',xueli='" + xueli + "',";
        strsql += " jingyan='" + jingyan + "',zhize='" + zhize + "',yaoqiu='" + yaoqiu + "',shijian='" + riqi + "' where ID=" + id + "";

        int n = sqlconn.exucutesql(strsql);
        if (n > 0)
        {
            Response.Write("<script language=javascript>alert('修改成功！');location='gangweiManage.aspx'</script>");

        }
        else
        {
            Response.Write("<script>javascript:alert('修改失败！');</script>");
            return;
        }
    }
}