62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
string UserName = Session["UserName"].ToString();
UserManage um = new UserManage();
UserInfo ui = um.GetUserInfo(UserName);
txtemail.Text = ui.Email;
txtqq.Text = ui.QQ;
txtmsn.Text = ui.MSN;
txtaqpwd.Text = ui.Safepwd;
txtwt.Text = ui.Safequestion;
}
public UserInfo GetUserInfo(string UserName)
{
return ua.GetUserInfo(UserName);
}
DataBase db = new DataBase();
public UserInfo GetUserInfo(string UserName)
{
SqlParameter[] sp={new SqlParameter("@UserName",UserName)};
SqlDataReader sdr = db.ExcuteDataReader(CommandType.StoredProcedure, "GetUserInfo", sp);
UserInfo ui = new UserInfo();
if (sdr.Read())
{
ui.UserPwd = sdr["UserPwd"].ToString();
ui.Email = sdr["Email"].ToString();
ui.MSN = sdr["MSN"].ToString();
ui.QQ = sdr["QQ"].ToString();
ui.Safequestion = sdr["Safequestion"].ToString();
ui.Safepwd = sdr["Safepwd"].ToString();
}
else
ui = null;
sdr.Close();
return ui;
}