In this section, we would see how to plot data from database on a map and how to use drill down feature on maps.
 
For this, we would take help of an example where we will show US population distribution per state and then employment details of each county through drill down maps. Let us note down what we want to display:
 
  1. First, we will show state wise population distribution in US. In this map, each state shows its population share in percentage against total US population.

  2. If we click on any state in the US Population Map, it opens the map of that state which shows percentage of population of each county for these employment groups:
    • Business
    • Service
    • Unemployed

    This data will be displayed as tool-tip inside the map.

We will try this out with MS Access database (FusionMapsDB.mdb). We will get to know more about the database structure in the following section. Note that you can always use any other database supported by your ASP like MS SQL, Oracle, mySQL etc.
 

The code examples contained in this section are present in Download Package > Code > VB_NET > DrillDown folder. The Access database is present in Download Package > Code > VB_NET > DrillDown > App_Data.