Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. private static string _acceptingChallenges = "0";
  2. private static string _curUser;
  3. private static string _website = "[None]";
  4. private static string _dateJoined = DateTime.Now.ToString();
  5.  
  6. protected void Page_Load(object sender, EventArgs e)
  7. {
  8. if (!string.IsNullOrEmpty(Request.QueryString["user"]))
  9. {
  10. _curUser = (Request.QueryString["user"]);
  11. pnlProfilePublic.Visible = true;
  12. pnlProfilePrivate.Visible = false;
  13. PopulatePublic();
  14. }
  15. else
  16. {
  17. if (!string.IsNullOrEmpty((string) Session["Nickname"]))
  18. {
  19. _curUser = Session["Nickname"].ToString();
  20. pnlProfilePublic.Visible = false;
  21. pnlProfilePrivate.Visible = true;
  22. PopulatePrivate();
  23. }
  24. else
  25. {
  26. Response.Redirect("~/Default.aspx");
  27. }
  28. }
  29.  
  30. InitiateData();
  31. }
  32.  
  33. private void InitiateData()
  34. {
  35. if (Master == null) return;
  36.  
  37. Label lblTitle = (Label)Master.FindControl("lblTitle");
  38.  
  39. const string strSql = "SELECT * FROM vwGetProfileDetails WHERE memberNickname=@member";
  40.  
  41. var sqlComm = new SqlCommand(strSql, DataConn.Connect()) { CommandType = CommandType.Text };
  42.  
  43. sqlComm.Parameters.Add(new SqlParameter("@member", SqlDbType.VarChar, 20)).Value = _curUser;
  44.  
  45. var rdr = sqlComm.ExecuteReader();
  46. int count = 0;
  47. while (rdr.Read())
  48. {
  49. imgProfile.ImageUrl = rdr["memberAvatarLocation"].ToString();
  50. lblTitle.Text = _curUser + "'s Profile Page";
  51.  
  52. _acceptingChallenges = rdr["memberAcceptingChallenge"].ToString();
  53. _website = rdr["memberWebsite"].ToString();
  54. _dateJoined = rdr["dateAdded"].ToString();
  55.  
  56. count = count + 1;
  57. }
  58.  
  59. rdr.Close();
  60. DataConn.Disconnect();
  61. Response.Write(count);
  62. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement