password.aspx.cs

库存管理系统V1.0源码 版本说明: 1.开发工具vs2005,数据库sql2005 2.数据库的连接字符串在web.config文件中

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 password : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
            //定义变量
            string word;
            word = this.TextBox2.Text;
            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            scon.Open();
            SqlCommand scmd = new SqlCommand("update tb_User set Pwd='" + word + "' where userID='1'", scon);
            scmd.ExecuteNonQuery();
            scmd.Dispose();
            scon.Close();
            Response.Write("<script language='javascript'>alert('密码修改成功！');</script>");
            Server.Transfer("manage.aspx");
       
    }
      
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this.TextBox2.Text = "";
    }
}