WebSite1/admin/viewData.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;
using System.Data.SqlClient;

public partial class WebSite1_admin_viewData : System.Web.UI.Page
{  
    protected void Page_Load(object sender, EventArgs e)
    {   
         Label1 .Text =Session ["NiName"].ToString ();
         Label3.Text = System.DateTime.Now.ToLocalTime().ToString(); ;
        
         Session["name"] = TextBox2.Text.Trim();
         Session["position"] = TextBox3.Text.Trim();
         Session["city"] = TextBox4.Text.Trim();
         Session["mayor"] = TextBox5.Text.Trim();
         Session["xueli"] = TextBox6.Text.Trim();
        
        string sqlstr = @"select X_ID, X_Status,X_Name,X_Sex,X_School,X_Mayor,X_Grade,X_Address,X_TelMobile from JianLi_inf";
        Job conn = new Job();   
        DataSet ds = null;
         ds = conn.GetResult(sqlstr );
       

         datalist.DataSource = ds;
         datalist.DataBind();
      
        // Session["ff"] = DataBinder.Eval(datalist.Columns[0].ToString(),"X_ID");
        // Response.Write(Session ["ff"].ToString ());
    }

    protected void Sbtn_Click(object sender, EventArgs e)
    {
        
        string STconnection = ConfigurationSettings.AppSettings["strconnection"];
        string StrSql1 = "update  JianLi_inf set X_Status='" + reback.SelectedItem.Text + "',X_Reson='" + TextBox1.Text + "' from JianLi_inf where X_Id='" + TextBox7.Text + "'";
        SqlConnection Strconn = new SqlConnection(STconnection);
        try
        {
            Strconn.Open();
            SqlCommand StrCmd1 = new SqlCommand(StrSql1, Strconn);
          //  SqlCommand StrCmd2 = new SqlCommand("insert into JianLi_inf (X_Reson)  values('" + TextBox1.Text + "')", Strconn);
            StrCmd1.ExecuteNonQuery();
           // StrCmd2.ExecuteNonQuery();
            Response.Write("<script language='javascript'>alert('成功！');</script>");
            Strconn.Close();
            
        }
        catch (Exception e1) { Response.Write(e1 ); }
    }

    protected void datalist_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {