modpwd.aspx.cs

来自「用C#事先的简单相册,带有FLASH功能,使用了AJAX」· CS 代码 · 共 52 行

using System;
using System.Data;
using System.Data.OleDb;
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;

public partial class modPwd : System.Web.UI.Page
{
	//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        // 创建数据连接
        DataAccess db = new DataAccess();

        // 创建 SQL 命令对象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 设置存储过程参数
            oleComm.CommandText = "UpdatePwd";
            oleComm.CommandType = CommandType.StoredProcedure;
            oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);
            oleComm.Parameters.Add("@Password", OleDbType.VarChar, 40);

            oleComm.Parameters["@UserID"].Value = Session["UserID"].ToString();
            oleComm.Parameters["@Password"].Value = txtNewPwd.Text;


            // 执行修改密码存储过程
            oleComm.ExecuteNonQuery();
        }
        catch { }
        finally
        {
            // 关闭数据连接
            db.Close();
        }
    }
}