Question: Creat this prgram in Visual Studio (C#) by using the database. The database has a table named City. The City table has the following columns:

Creat this prgram in Visual Studio (C#) by using the database. 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

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.

Get the highest population.

Get the lowest population.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!