PROG37721 Continents, Countries, and Towns

Instructions:

1. Make a web application in Visual Studio and name it as A3FirstnameLastname.

2. Create a web application that adds and displays the information about continents, countries and their towns.

• You need to create a SQL Server database as a MDF file.
• Think and design the tables and columns.
• Overall, you need to store the following data in your database:
  • Continent name
  • Country name
  • Country's flag
  • Country's national language
  • Town's name
  • Town's population

3. The application should have four webforms

• Home | Add Continent | Add Country | Add Town

Home WebForm:

1. This webform has:

• ListBox: to display list of continents.
• DropDownList: to display list of countries.
• Image: to display the selected countrys flag.
• Label: to display the nations language.
• GridView: to display the information of towns of the selected country.

2. On the initial page load, a ListBox is populated with continents.

3. On selecting a continent, its corresponding countries are loaded in a DropDownList.

4. On selecting a country:

• Its towns information is loaded in a GridView.
• Its flag is displayed somewhere on the form in an Image control.
• Its national language is displayed in a Label.

5. If a new country is selected in the DropDownList, update the controls to display the countys information accordingly.

6. If a new continent is selected in the ListBox, update the countries DropDownList accordingly.

• And clear the flag, language and towns information.

7. There should not be any buttons on this webform.

8. Use AJAX to fetch the data and update the controls on this webform.

Add Continent WebForm:

1. This webform has:

• TextBox: to type the continents name.
• Button: to add the continents name to the database.
• RequiredValidationControl: to add the validation.

2. This webform adds the name of the continent to the database table.

3. Add a validation control so that the text field cannot be left blank.

Add Country WebForm:

1. This webform has:

• DropDownList: to display list of continents.
• Two TextBoxes: to type the country name and language.
• FileUpload: to select the nations flag image.
• Button: to add the above information to the database.
• Validation Controls: to handle any validations that may occur.

2. On the initial page load, the continent DropDownList is filled with continent names, along with the first item as "Select a continent".

3. Then the user can type the name of the country and its language in the textboxes.

4. The user has to select an image of the countrys flag to upload.

• Only image files should be allowed (for instance, JPG or PNG etc.).

5. No field could be left blank or unselected.

• Add the necessary validation controls.

Add Town WebForm:

1. This webform has:

• Two DropDownLists: to display list of continents and countries.
• Two TextBoxes: to type the name of the town and population of that town.
• Button: to add the above information to the database.
• Validation Controls: to handle any validations that may occur.

2. On the initial page load, the continent DropDownList is filled with continent names, along with the first item as "Select a continent".

• The countrys DropDownList has an item Select a country and is disabled.

3. On selecting a continent, the county DropDownList is filled with countries located in that continent.

4. Then the user can type the name of the town and its population in the textboxes.

5. No field could be left blank or unselected.

• The population field should only accept numbers.
• Add the necessary validation controls.

Instructions:

1. Use a master page to design the layout of the application.

• Your application should have a header that displays the website title as Assignment 3. You can also add a background image to the header.
• A navigation bar, either under the header, or in a sidebar having these links:
  • Home | Add Continent | Add Country | Add Town
• A main content section thatll change its content from page to page.
• A footer that displays your name and student ID.

2. Give proper names to all the ASP.NET server controls.

3. Create all your webforms using the master page.

4. There should be no compile-time errors or run-time exceptions in your application.