datas/modify_dw.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Datas_modify_dw : System.Web.UI.Page
{
    DataBase db = new DataBase();
    string num = "";
    string sql = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        num = Request.QueryString["id"];
        if (!IsPostBack)
        {
            if (Session["ano"] == null)
            {
                Response.Write("<script> javascript:alert('请先登录！'); </script>");
                Response.Redirect("../login.aspx");
            }
            else
            {
                sql = "select * from dw where dno='" + num + "'";
                Databind(sql);
            }
        }

    }
    protected void Databind(string sqls)
    {
        DataSet ds = db.Getdata(sqls);
        DataRow[] dr = ds.Tables[0].Select();
        foreach (DataRow dw in dr)
        {
            TextBox1.Text = dw["dno"].ToString();
            TextBox2.Text = dw["dname"].ToString();
            TextBox3.Text = dw["lxr"].ToString();
            TextBox4.Text = dw["phone"].ToString();
            TextBox5.Text = dw["address"].ToString();
        }
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        string sql = "";
        if (TextBox1.Text == "" || TextBox2.Text == "" || TextBox3.Text == "" || TextBox4.Text == "" || TextBox5.Text == "")
            Response.Write("<script>javascript:alert('打星号的内容不能为空！');</script>");
        else
        {
            sql = "update dw set dno='" + TextBox1.Text.Trim() + "',dname='" + TextBox2.Text.Trim() + "',lxr='" + TextBox3.Text.Trim() + "',phone='" + TextBox4.Text.Trim() + "',address='" + TextBox5.Text.Trim() + "' where dno='" + num + "'";
            if (db.Exucute(sql))
            {
                Response.Write("<script> javascript:alert('修改成功！'); </script>");
                Response.Redirect("index_dw.aspx");
            }