CST272 Project No. 12

DataList or Repeater

Click the following "Movies" link to download the SQL Server "Movies" database and related image files (add these elements as "Existing Items" to the new project); create Project 12 as follows:

• At the top of the page a banner image (having something to do with movies or movie stars which you already may have used for Projects 8, 9, 10 and 11)
   
• Two SqlDataSource controls, one linked to those records in the "Stars" table with StarDied field not equal to null (deceased) (WHERE StarDied IS NOT NULL) and the other with the StarDied field equal to null (still living) (WHERE StarDied IS NULL)
   
• Then implement one of the following:
   
  • For partial credit (8 out of 10 points) include two DataList controls, each linked to one of the two SqlDataSource controls, and with the following features:
     
    • RepeatColumns, RepeatDirection and Gridline properties set, as well as Height and Width properties
    • A HeaderTemplate that contains a Label with appropriate Text and other formatting
    • An ItemTemplate with an Eval function for each of the fields in the table (do not include the StarDied field for the DataList with "Stars" who are not deceased)
    • Use the AutoFormat command to select a predefined formatting
    • Any other formatting to create pleasing and professional DataList controls
       
  • For partial credit (9 out of 10 points) include two Repeater controls, each linked to one of the two SqlDataSource controls, and with the following features:
     
    • An ItemTemplate with:
       
      • An individual table for each star in the format displayed in the image below; the entire table is repeated for every record (in the example below, one complete table is shown each for a star who is deceased and one who is living)
      • Use an Eval function for each of the fields in the table (do not include the StarDied field for the Repeater with "Stars" who are not deceased)
      • Do not implement the first cell that displays the the StarName field as a hyperlink
      • Follow the example in the images below but do not place an img in the second column of each table using the rowspan attribute so that it spans all rows of the table
      • All other fields are in separate left-side cells of the table with labels preceding the field data
         
    • HeaderTemplate and FooterTemplate elements to complete the layout of the Repeater control
    • Any formatting to create pleasing and professional Repeater controls, e.g. tables, bulleted lists, etc.
       
  • For full credit (10 out of 10 points) include two Repeater controls, each linked to one of the two SqlDataSource controls, and with the following features:
     
    • An ItemTemplate with:
       
      • An individual table for each star in the format displayed in the image below; the entire table is repeated for every record (in the example below, one complete table is shown each for a star who is deceased and one who is living)
      • Use an Eval function for each of the fields in the table (do not include the StarDied field for the Repeater with "Stars" who are not deceased)
      • The first cell displays the the StarName field which is a hyperlink using an anchor (<a>) tag that includes a link to the star's "Imdb.com" web page
      • Use the rowspan attribute for the <td> cell as well as horizontal and vertical alignment style properties for the <img> tag that contains the star image (use the same images for the stars that you downloaded from the "Movies" link above)
      • All other fields are in separate left-side cells of the table with labels preceding the field data

      

    • HeaderTemplate and FooterTemplate elements to complete the layout of the Repeater control
    • Any formatting to create pleasing and professional Repeater controls, e.g. tables, bulleted lists, etc.
       

The completed project, a ZIP file that contains the folder with all files for the website, is due to Prof. Struck as an attachment to a Brightspace dropbox by 11:59 p.m. on the date specified in the course outline.