public void ShowUserInfo() { lblUserName.Text = Session["userName"].ToString(); //将Session["userName"]里的内容传给lblUserName.Text string sql = "select * from Users where userName='******'"; //定义SQL语句根据用户名查询所有信息 SqlDataReader reader = DBHelper.execReader(sql); //调用DBHelper.execReader,将结果保存在变量reader reader.Read(); //将reader里的内容显示 txtTrueName.Text = reader["trueName"].ToString(); lstSex.SelectedValue = reader["sex"].ToString(); lstQuestion.SelectedValue = reader["question"].ToString(); txtAnswer.Text = reader["answer"].ToString(); txtEmail.Text = reader["email"].ToString(); reader.Close();//关闭变量 }
public void ShowUserInfo() { string strName = Session["userName"].ToString(); //将Session ["userName"]里的值传给变量strName lblUserName.Text = strName; //将变量strName里的值传给 lblUserName.Text string sql = "select * from users where username='******'"; //定义SQL语句,根据用户名查询所有信息 SqlDataReader myreader = DBHelper.execReader(sql); //调用DBHelper.execReader里的方法,将结果传给myreader myreader.Read(); //将myreader里的内容在页面上显示 lblTrueName.Text = myreader["truename"].ToString(); //页面显示真实姓名 lblSex.Text = myreader["sex"].ToString(); //页面显示性别 lblEmail.Text = myreader["email"].ToString(); //页面显示EMail myreader.Close(); //将变量关闭,释放 }
protected void txtUserName_TextChanged(object sender, EventArgs e) { string sql = "select question,PWD,answer from Users where userName='******'"; //定义查询语句根据用户名查询问题,答案,密码 SqlDataReader reader = DBHelper.execReader(sql); //调用 DBHelper.execReader方法,将结果保存在变量reader里 if (!reader.Read()) { lblQuestion.Text = ""; Button1.Enabled = false; Response.Write("<script>alert('查找的用户名不存在!')</script>"); return; } else { lblQuestion.Text = reader["question"].ToString(); Button1.Enabled = true; } }
protected void Button1_Click(object sender, EventArgs e) { string sql = "select question,PWD,answer from Users where userName='******'"; //定义查询语句根据用户名查询问题,答案,密码 SqlDataReader reader = DBHelper.execReader(sql); //调用 DBHelper.execReader方法,将结果保存在变量reader里 if (reader.Read()) { if (txtAnswer.Text.Trim() == reader["answer"].ToString()) //如果用户的答案和reader里的答案一致 { Response.Write("<script>alert(' 你的密码是:" + reader["PWD"].ToString() + " ')</script>"); //输出你的密码是 // Response.Redirect("Login.aspx"); } else { Response.Write("<script>alert('回答问题错误!')</script>");//回答错误 } } }