user_getpassword.aspx.cs

基于VS05和SQL05做的一个电子商务网站

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;
using System.Configuration;

public partial class User_GetPassWord : User_Login
{
    public string answer;
    public string question;
    public string password;
    public string username;
    
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnOK_Click(object sender, EventArgs e)
    {
        question = InputText(TextBox1.Text);
        answer = InputText(TextBox2.Text);
        username = InputText(TextBox3.Text);

        SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        String sql = "SELECT * FROM Users where Question='" + question + "' and Answer='" + answer + "' and UserName='" + username + "'";
        /*SqlCommand command=new SqlCommand(sql,connection);//构建执行数据库命令
        connection.Open();*/
        //保存从数据库里面返回的一条记录
        DBConnection conn = new DBConnection();
        SqlDataReader dr = conn.ExecuteReader(sql);

        if (dr.Read())
        {
            Response.Redirect("User_NewPassWord.aspx?username=" + Server.UrlEncode(username));
            return;
        }
        else
        {
            Response.Write("<script language='JavaScript'>");
            Response.Write("alert('您输入的资料不确定！请重新输入！')");
            Response.Write("</script>");
            return;
        }
    }
    protected void btnReset_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
    }
}