admin/diandongcheUpdate1.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_diandongcheUpdate1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sql;
            sql = "select * from diandongche where id=" + Request.QueryString["id"].ToString().Trim();
            DataSet result = new DataSet();
            sqlConn conn = new sqlConn();
            result = conn.hsggetdata(sql);
            if (result != null)
            {
                this.bianhao.Text = result.Tables[0].Rows[0]["bianhao"].ToString();
                this.mingcheng.Text = result.Tables[0].Rows[0]["mingcheng"].ToString();
                this.shengchanshang.Text = result.Tables[0].Rows[0]["shengchanshang"].ToString();
                this.goumairiqi.Text = result.Tables[0].Rows[0]["goumairiqi"].ToString();
                this.DropDownList1.Text = result.Tables[0].Rows[0]["leixing"].ToString();
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        sqlConn conn = new sqlConn();
        string bianhao = this.bianhao.Text;
        string mingcheng = this.mingcheng.Text;
        string shengchanshang = this.shengchanshang.Text;
        string goumairiqi = this.goumairiqi.Text;
        string leixing = this.DropDownList1.Text;
        string strsql= "Update  diandongche set mingcheng='" + mingcheng + "',shengchanshang='" + shengchanshang + "',goumairiqi='" + goumairiqi + "',leixing='"+leixing+"' where bianhao='"+bianhao+"'";
        int result;
        result = conn.hsgexucute(strsql);
        if (result == 1)
        {
            Response.Write("<script language=javascript>alert('修改成功！');location='diandongcheUpdate.aspx'</script>");
        }
        else
        {
            Response.Write("<script>javascript:alert('系统错误，请检查数据库的连?);</script>");
        }
    }
}