Good/GoodUpdate.aspx.cs

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

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

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

public partial class Good_GoodUpdate : System.Web.UI.Page
{
    protected string sqlConString = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ToString();
    protected SqlConnection sqlCon;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            DataBindText();
        }

    }
    /// <summary>
    /// 绑定数据
    /// </summary>
    protected void DataBindText()
    {
        string id = (string)Request.QueryString["id"];
        SqlConnection sqlCon = new SqlConnection(sqlConString);
        string strCmd = "select * from tb_Good where id=" + id + "";
        SqlDataAdapter sqlDa = new SqlDataAdapter(strCmd, sqlCon);
        DataSet dsClientinfo = new DataSet();
        sqlCon.Open();
        sqlDa.Fill(dsClientinfo, "tb_Good");
        sqlCon.Close();
        if (dsClientinfo != null)
        {
            this.TextBox0.Text = dsClientinfo.Tables[0].Rows[0]["Number"].ToString();
            TextBox1.Text = dsClientinfo.Tables[0].Rows[0]["Name"].ToString();
            TextBox2.Text = dsClientinfo.Tables[0].Rows[0]["jiage"].ToString();
            TextBox3.Text = dsClientinfo.Tables[0].Rows[0]["changjia"].ToString();
            TextBox4.Text = dsClientinfo.Tables[0].Rows[0]["miaoshu"].ToString();
        }
        dsClientinfo.Dispose();

    }

    /// <summary>
    /// 更新数据
    /// </summary>
    protected void UpdateData()
    {
        string id = (string)Request.QueryString["id"];
        sqlCon = new SqlConnection(sqlConString);
        string Number = this.TextBox0.Text;
        string Name = this.TextBox1.Text;
        string jiage = this.TextBox2.Text;
        string changjia = this.TextBox3.Text;
        string miaoshu = this.TextBox4.Text;