修改密码.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 修改密码 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        String myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";

        SqlConnection myConn = new SqlConnection(myConnStr);

        String sql;
        if (this.TextBox7.Text != "")
        {
            sql = "update 用户表 set 密码='" + this.TextBox5.Text + "'";
            if (this.TextBox6.Text == this.TextBox7.Text)
            {
                sql += "where 密码='" + this.TextBox6.Text + "'";
                SqlCommand myComm = new SqlCommand(sql, myConn);
                myConn.Open();
                myComm.ExecuteNonQuery();
                myConn.Close();
                Response.Write("<script>alert('修改成功！')</script>");
            }

            //SqlCommand myComm = new SqlCommand(sql, myConn);
            //myConn.Open();
            //myComm.ExecuteNonQuery();
            //myConn.Close();
            //Response.Write("<script>alert('修改成功！')</script>");
            else
            {
                Response.Write("<script>alert('请仔细核查您输入的信息')</script>");
            }
        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("登录.aspx");
    }
}