Description

This middleware has three parts. The clCityList class has a method GetAll() that creates a list that stores the data incoming from the mySQL database server. The second part is the MySqlDataReader SQL query that runs to retrieve specific data from the city table.We added population into the clCityList.cs and were able to add it as a column to the web based GUI. Third, the DLL file gets built.

Then it will be linked to the ASPX file which will display the information from the DLL.

The asp element with the “Population” Datafield needed to be added.
This aspx outputted the following into the browser:

We also ran it with a modified query showing the top 10 cities with <= 150,000 population.

Output for <= 150000 population ordered by population DESC