chanpin/chanpinmod.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using dao;
public partial class chanpinmod : System.Web.UI.Page
{
    string id = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        id = Request.QueryString["id"].ToString();
        if (!IsPostBack)
        {

            string sql = "select * from chanpin where cpid='" + id + "'";
            DataTable dt = DBHelper.GetDataSet(sql);
            if (dt.Rows.Count > 0)
            {
               this.cp.Text =dt.Rows[0]["cp"].ToString();
this.ms.Text =dt.Rows[0]["ms"].ToString();
this.jg.Text =dt.Rows[0]["jg"].ToString();
this.cd.Text =dt.Rows[0]["cd"].ToString();
this.sx.Text =dt.Rows[0]["sx"].ToString();
this.djrq.Text =dt.Rows[0]["djrq"].ToString();
this.djr.Text =dt.Rows[0]["djr"].ToString();


     
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      string cp=this.cp.Text;//产品
string ms=this.ms.Text;//描述
string jg=this.jg.Text;//价格
string cd=this.cd.Text;//产地
string sx=this.sx.Text;//属性
string djrq=this.djrq.Text;//登记日期
string djr=this.djr.Text;//登记人

		
     
        string sql = "update chanpin set  cp='"+cp+"',ms='"+ms+"',jg='"+jg+"',cd='"+cd+"',sx='"+sx+"',djrq='"+djrq+"',djr='"+djr+"' where cpid ='"+id+"'";
        int row = 0;
        try
        {
            row = DBHelper.ExecuteCommand(sql);
        }
        catch (Exception ex)
        {
            MessageBox.ShowAndRedirect(this.Page, ex.Message, "chanpinlist.aspx");