Client/ClientUpdate.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.Configuration;
using System.Data.SqlClient;
using System.Data;

public partial class Client_ClientUpdate : 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_Client where id=" + id + "";
        SqlDataAdapter sqlDa = new SqlDataAdapter(strCmd, sqlCon);
        DataSet dsClientinfo = new DataSet();
        sqlCon.Open();
        sqlDa.Fill(dsClientinfo, "tb_Client");
        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]["Tel"].ToString();
            TextBox3.Text = dsClientinfo.Tables[0].Rows[0]["Address"].ToString();
            TextBox4.Text = dsClientinfo.Tables[0].Rows[0]["Email"].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 Tel = this.TextBox2.Text;
        string Address = this.TextBox3.Text;
        string Email = this.TextBox4.Text;