EP ep = new EP();//实例化一个对象 protected void Page_Load(object sender, EventArgs e) { string SqlStr = "select * from tb_UserLogin where UserName='******'"; SqlDataReader Sdr = ep.ExceRead(SqlStr); Sdr.Read(); if (Sdr.HasRows) { //从数据表中读取字段为“RetakePassword”的数据信息显示到文本框中 this.txtQues.Text = Sdr["RetakePassword"].ToString(); } else { Response.Write("<script language=javascript>alert('此用户不存在!');location='javascript:history.go(-1)'</script>"); } Sdr.Close(); //关闭阅读器 }
EP ep = new EP();//实例化对象 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.LblUserName.Text = Session["UserName"].ToString();//将用户名显示在Label控件当中 string SqlStr = "select * from tb_UserLogin where UserId='" + Session["ID"].ToString() + "'"; SqlDataReader Sdr = ep.ExceRead(SqlStr); while (Sdr.Read()) { this.txtPwd.Text = Sdr["UserPwd"].ToString(); } Sdr.Close(); //关闭阅读器 } }