changepassword.aspx.cs

人事管理系统

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 EmployeeInfo_ChangePassword : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        { }
    }
    
    protected void btnChange_Click(object sender, EventArgs e)
    {

        SqlConnection conn = db.mysqll();
        conn.Open();
        string strsql = "select * from 员工表 where 员工编号='" + Session["EmployeeID"].ToString() + "'and 员工密码='" + this.txtOldPwd.Text.Trim() + "' ";
        SqlDataReader rd;
        SqlCommand cmd = new SqlCommand(strsql ,conn);
      rd = cmd.ExecuteReader();
        
      
        if (rd.Read())
        {
            rd.Close();
            string sqlud = "update 员工表 set 员工密码='" + this.txtNewPwd.Text.Trim() + "' where 员工编号='" + Session["EmployeeID"].ToString() + "'";


            cmd.CommandText = sqlud;
            cmd.ExecuteNonQuery();
            conn.Close();
           
        }
    }
}