editing.aspx.cs

小型物理试验管理系统Management system for small-scale physical experiments

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;
using System.Data.SqlClient;

public partial class Editing : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = Session["uid"].ToString() + ",请对您负责的实验进行修改!";
        Label2.Text = "取消请返回!";
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection myconnection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        DBConnection conn = new DBConnection();

        string enumber = Session["eid"].ToString();
        string ename = TextBox2.Text.ToString();
        string etime = TextBox3.Text.ToString();
        string eaddress = TextBox4.Text.ToString();
       
        string str1 = TextBox6.Text.ToString();
        string sql = "";
        
        if (ename != "")
        {
            sql = "update shiyan set ename='" + ename + "'where enumber ='" + enumber + "'";
            SqlDataReader rs1 = conn.ExecuteReader(sql);
            rs1.Close();
        }
        if (etime != "")
        {
            sql = "update shiyan set edate='" + etime + "'where enumber ='" + enumber + "'";
            SqlDataReader rs2 = conn.ExecuteReader(sql);
            rs2.Close();
        }
        if (eaddress != "")
        {
            sql = "update shiyan set eaddress='" + eaddress + "'where enumber ='" + enumber + "'";
            SqlDataReader rs3 = conn.ExecuteReader(sql);
            rs3.Close();
        }
        
        if (str1 != "")
        {
            int n = Convert.ToInt32(str1);
            sql = "update shiyan set total='" + n + "'where enumber ='" + enumber + "'";
            SqlDataReader rs5 = conn.ExecuteReader(sql);
            rs5.Close();
        }

        Page.Response.Redirect("TeacherXG.aspx");                                     
    }
}