| public static execReader ( string sql ) : SqlDataReader | ||
| sql | string | |
| 리턴 | SqlDataReader | |
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>");//回答错误
}
}
}
