The Query Manager component of Smart Map lets you to connect to any database, design and test custom queries and then store them (sort of like stored procedures) for plotting map points, filling pop-up balloon windows and populating the sidebar.
 For examples of how to use Query Manager, visit the pages linked below. |
Here are some of the features of Query Manager:
Use the Database Connections component of Smart Map to conveniently store your connection strings. Any connection listed there will show up in a dropdown list within Query Manager when you select "Other". This list allows you to instantly connect to any of your databases.
Pass Querystring and Form Parameters into Queries
Pass custom querystring parameter values and form values into your custom queries. This gives you tremendous control over what data is dyanmically plotted on Smart Map. See Passing Querystring and Form Parameters to Queries for details and examples.
Use Map Values as Input Parameters in Queries
Certain map values can also be passed into your custom queries at runtime as input parameters. See Using Map Values as Input Parameters for details and examples.
Fill Balloons and Sidebar with Your own Data
Query Manager allows you to fill the sidebar and balloon window with data from your own database queries. See Filling Balloon Window with Custom Data and Filling the Sidebar with Custom Data for information and examples.
Stored procedures can be used to select data from a database for plotting map points. See Using Stored Proceedures for more information and examples.