newpsw.ascx.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 ascx_NewPas : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Mess.Text = "";
        Label2.Text = "";
    }
    protected void btSubmit_Click(object sender, EventArgs e)
    {
        //string connstr = "server=localhost;Database=library1;User ID=sa;Password=''";
        //SqlConnection conn = new SqlConnection(connstr);  
        DataControl.ConnectionControl conn = new DataControl.ConnectionControl();
        conn.DataConnetion();
        SqlCommand cmd1 = conn.DataCmd("update [UserInfo] set Password='" + this.NewPas.Text.Trim() + "'where UserID='" + Session["UserID"].ToString().Trim() + "'");
        SqlCommand cmd2 = conn.DataCmd("select Password from UserInfo where UserID='" + Session["UserID"].ToString().Trim() + "'");
        SqlDataReader dr1 = cmd2.ExecuteReader(); //看旧密码是否正确
        if (dr1.Read())
        {
            dr1.Close();//一个sqlConnection只能有一个sqlDateReader,要关掉这个
            try
            {
                cmd1.ExecuteNonQuery();           //修改密码
                Mess.Text = "密码修改成功！";
                Label2.Text = "修改信息在下次登陆时生效！";
            }
            catch (Exception e2)
            {
                Response.Write(e2.Message.ToString());
                Mess.Text = "密码修改不成功！";
            }
            finally
            {
                conn.Close();
            }
        }
        else
        {
            Message.Text = "旧密码错误！";
        }
    }
    protected void btCancle_Click(object sender, EventArgs e)
    {
        OldPas.Text = "";
        NewPas.Text = "";
        QrNewPas.Text = "";
    }
}