CST272 Final Project

"Friend Info Page"


  1. Create a Web page "FriendInfo.aspx" with the following elements:
  1. When the web page loads, the "Email" property contained in the query string passed from the "MemberHome.aspx" web page is stored in a private instance variable "Email" of type string
     
  2. A "Click here to return to your Face Pamphlett Member Homepage" asp:Button control that when clicked submits the private instance variable "Email" in a query string to the "MemberHome.aspx" Web page
     
  3. An asp:SqlDataSource control that returns your friend's EMail and FirstName (the FirstName is used to generate the URL to display the image) fields from the Members table as well as the "FirstName" concatenated to the "LastName" field (with a space between) as alias MemberName for the record that matches the "EMail" property stored in the query string passed from the the hyperlink field in the "MemberHome.aspx" Web page

FriendInfo1.png

  1. Implement an asp:SqlDataSource control that returns the Post and PostDate fields from the Posts table for those records that match the "EMail" property stored in the query string passed from the click event of the "Submit" Button in the "Login.aspx" Web page; these records should be returned in descending order by the "PostDate" field

FriendInfo2.png

  1. An asp:SqlDataSource control that returns the MyEmail and FriendEMail fields from the Friends table as well as the FirstName field from the Members tables as well as the FirstName concatenated to the LastName field (with a space between) as alias MemberName, for those records in which the "MyEmail" field matches the "EMail" property stored in the query string passed from the the hyperlink field in the "MemberHome.aspx" Web page

FriendInfo3.png