$6.$ Population Database C#

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:

$\backslash$begin$\{$tabular$\}\{$l$|$l$\}$

$\backslash$hline Column Name & Data Type $\backslash \backslash$

$\backslash$hline City & nvarchar$(50)$ Primary key $\backslash \backslash$

$\backslash$hline Population & float $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

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.