in C# in Visual Studios using Windows Form App(.Net Framework) Thank you ### 6. Population DatabaseIn the Chap12 folder of the Student Sample Programs, you will find a database file named `PopulationDB.mdf`. The database has a table named `City`. The `City` table has the following columns:| Column Name | Data Type ||-------------|-------------------------|| City | nvarchar(50) Primary key|| Population | float |- **City Column**: Stores the name of a city.- **Population Column**: Stores the population of that city.The database has 20 rows already entered. #### Application RequirementsCreate an application that connects to the `PopulationDB.mdf` database and allows the user to perform the following tasks:- Use data-bound controls to: - Add new rows to the database. - Change existing rows. - Delete rows.- Sort the list of cities by population in: - Ascending order. - Descending order.- Sort the list of cities by name.- Calculate: - Total population of all cities. - Average population of all cities. - Highest population. - Lowest population.

The complete answer in C# is below:

6. POPULATION DATABASE In the Chap12 folder of the Student Sample Programs, you will find a database file named PopulationDB.mdf. The database has a table named City. The City table has the following columns: Column Name City Population Data Type nvarchar (50) Primary key ▪ Get the highest population. ▪ Get the lowest population. float The City column stores the name of a city and the Population column stores the population of that city. The database has 20 rows already entered. Create an application that connects to the PopulationDB.mdf database and allows the user to perform the following: ▪ Use data-bound controls to add new rows to the database, change existing rows, and delete rows. ▪ Sort the list of cities by population, in ascending order. ▪ Sort the list of cities by population, in descending order. ▪ Sort the list of cities by name. ▪ Get the total population of all the cities. ▪ Get the average population of all the cities.

6. POPULATION DATABASE In the Chap12 folder of the Student Sample Programs, you will find a database file named PopulationDB.mdf. The database has a table named City. The City table has the following columns: Column Name City Population Data Type nvarchar (50) Primary key ▪ Get the highest population. ▪ Get the lowest population. float The City column stores the name of a city and the Population column stores the population of that city. The database has 20 rows already entered. Create an application that connects to the PopulationDB.mdf database and allows the user to perform the following: ▪ Use data-bound controls to add new rows to the database, change existing rows, and delete rows. ▪ Sort the list of cities by population, in ascending order. ▪ Sort the list of cities by population, in descending order. ▪ Sort the list of cities by name. ▪ Get the total population of all the cities. ▪ Get the average population of all the cities.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

What are the signs that Visual Studio has found a syntax error?
How can you change the shape of your Visual Studio view in the fastest way?
detailed explanation about Microsoft visual studio 2019
Microsoft Visual Studio 2019 is explained in depth.
Application programmers may produce forms that are shown on a computer screen in one of two ways.
While designing an application, how does one go about making the many forms that end up on the screen?
Before starting to code anything, an application's user interface must be designed for three reasons that are described.
Before starting to code anything, an application's user interface must be designed for three reasons that are described.
When working in Visual Studio, how do you move your view to a different form?
There are many ways to change the way a Visual Studio view looks, but which is the fastest?
What tools does Visual Studio provide to help you quickly fix syntax errors?
Explain the many options that are accessible to you in the Visual Studio program. Explain the steps involved in the creation of a simple window application.