CST272 Project No. 9

GridView No. 2

Click the following "Movies" link to download the "Movies" SQL Server database and related image files; then create the Project 9 application as follows:

• Add the "Movies" SQL Server database as an "Existing Item" into the "App_Data" folder of the website
   
• 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 Project 8)
   
• A SqlDataSource linked to the all fields in "Stars" table (use the "Advanced" option to include the INSERT, UPDATE and DELETE commands)
   
• A GridView with the following elements:
   
  • Set its DataSource property to the preceding SqlDataSource
  • Format it using the AutoFormat command
  • Enable paging, sorting and editing, but not deleting (remember to add the UPDATE command to the SqlDataSource—above)
  • Set the PageSize property to small enough a value so that there are at least two pages to demonstrate paging
  • Use an ItemStyle property to center the values for the "StarBorn" and "StarDied" fields

Complete all instructions above for a maximum grade of 8 out of 10 points

For an additional ½ point each, do either number (1) the ImageField or number (2) the HyperlinkField below (or do both for 1 full point):

1. An ImageField that displays thumbnail pictures of each star (the pictures for all the stars are in the "images" folder of the "Movies" website)
2. A HyperlinkField that link's to each star's "IMDb" web page (http://www.imdb.com/)

For an additional 1 point convert the following BoundField columns to TemplateField columns each with the specified validation control(s) for the EditItemTemplate (complete only the three RequiredFieldValidator controls for an just additional ½ point instead of 1 full point; also complete the two RangeValidator controls for full credit on this element of the assignment):

• StarName—a RequiredFieldValidator
• Birthplace—add a RequiredFieldValidator
• StarBorn—add a RequiredFieldValidator and a RangeValidator that confirms the input is between 1850 and 2023 with its Type set to Integer
• StarDied—add a RangeValidator that confirms the input is between 1850 and 2023 with its Type set to Integer

Complete all elements above for a maximum grade of 10 out of 10 points

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.