$6.$ Population Database

In the Chap $13$ 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:

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.