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 11 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 and 10)
- A
SqlDataSource
linked to the all fields in "Stars" table
- For 8½ out of 10 points develop a "manually" constructed
ListView
control with the following elements:
- Set its
DataSource
property to the precedingSqlDataSource
- Use a
LayoutTemplate
andItemTemplate
to fully customize the output of theListView
- Also include an
AlternatingItemTemplate
and anItemSeparatorTemplate
- Create "Sort" buttons of any type (
Button
,ImageButton
orLinkButton
) for the StarID, StarName, Birthplace and StarBorn fields- Add a
DataPager
that is linked to theListView
so that it implements paging; set thePageSize
to 4 or some value small enough so that paging is possible for at least three pages
- For 9 out of 10 points complete everything above in the 8½ version and in addition implement editing for the "manually" configured
ListView
- Include the
UPDATE
command for theSqlDataSource
and an "Edit" button (of any type) in theItemTemplate
andAlternatingItemTemplate
, as well as "Update" and "Cancel" buttons in theEditItemTemplate
- For full credit (10 out of 10 points) complete everything above in the 8½ and 9 point versions and in addition implement inserting for the "manually" configured
ListView
- Include the
INSERT
command for theSqlDataSource
and a "New" button (of any type) in theItemTemplate
andAlternatingItemTemplate
, as well as "Insert" and "Cancel" buttons in theInsertItemTemplate
- Hint: Because the StarID is an "Identity Specification" field, its
TextBox
should not be included in theInsertItemTemplate
nor should it be included in the SQLSELECT
statement nor theInsertParameters
block
- As an alternative option to this assignment for 7 out of 10 points create a
ListView
of the "Stars" table using the "Auto Configure" option with a "Grid" layout
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.