ASP.NET SQL Server and the SqlDataSource Control

In a new ASP.NET project named "Movies" create a SQL Server database named "Movies" with the following tables and related properties:

Enter the following data for the tables of the "Movies" database:

Create three Web Forms each with SqlDataSource and GridView controls as follows:

1. A Form that shows the Star table in a GridView (complete Parts 1 and 2 above, as well as this query and GridView control for a maximum grade of 8 out of 10 points)
2. A Form that shows the MovieTitle, YearMade, Stars, Rating and MovieType from the Movie table and the DirectorName from the Director table in a GridView (complete Parts 1 and 2 as well as these first two queries and GridView controls for a maximum grade of 9 out of 10 points)
3. A Form that shows the MovieTitle from the Movie table, the DirectorName from the Director table, and the StarName from the Star table for all movies in a GridView (complete all elements of this assignment including all three queries and GridView controls for a maximum grade of 10 points)

Movie (table) Name Data type Allow nulls Other MovieID int Primary key: Indentification specification: True Identity increment: 1; Identity seed: 24 varchar(50) int Movie Title Year Made DirectorID Stars int Foreign key into "Director" table int Rating MovieType varchar(5) varchar(10) MovieStar (table) Name Data type Allow nulls Other MovieID int Concatenated primary key with StarID; Foreign key into "Movie" table Concatenated primary key with MovieID; Foreign key into "Star" table StarID int Star (table) Name Data type Allow nulls Other StarID int Primary key: Indentification specification: True Identity increment: 1; Identity seed: 25 varchar(25) varchar(25) StarName Birthplace StarBorn StarDied int int Name Data type Other Director (table) Allow nulls Primary key: Indentification specification: True Identity increment: 1; Identity seed: 7 DirectorID int varchar(25) Director Name DirectorBorn Director Died int int MovieID Movie (data) YearMade DirectorID 1940 7 Stars 4 Movie Type Drama 24 Movie Title Grapes of Wrath Fort Apache True Grit Rating NR NR 25 7 Drama 1948 1969 4 3 26 8 G Western MovieStar (data) MovieID 24 StarID 25 24 26 27 24 25 25 25 28 25 29 26 28 26 30 26 31 StarName StarID 25 StarBorn 1905 1879 26 27 Star (data) Birthplace Grand Island, NE Palmyra, MO New York, NY Winterset, IA Santa Monica, CA Los Angeles, CA Delight, AR StarDied 1982 1967 1988 1979 Henry Fonda Jane Darwell John Carradine John Wayne Shirley Temple Kim Darby Glen Campbell 1906 1907 28 29 1928 2014 30 1947 31 1936 2017 Director (data) DirectorName DirectorID 7 DirectorBorn 1894 Director Died 1973 John Ford Henry Hathaway 8 1898 1985