GeekArticles
Database
SQL Server
Database
SQL ServerBuilding a Store Locator ASP.NET Application Using Google Maps API (Part 3)
<p>
Over the past two weeks showed how to build a store locator application using ASP.NET and the free <a Maps API</a> and geocoding service. <a 1</a> looked at creating the database to record the store locations. This
database contains a table named <code>Stores</code> with columns capturing each address and <a and
<a coordinates. Part 1 also showed how to use geocoding service to translate a user-entered address
into latitude and longitude coordinates, which could then be used to retrieve and display those stores within (roughly) a 15 mile area. At the end of Part 1, the results
page listed the nearby stores in a grid. In <a 2</a> we used the Google Maps API to add an interactive map
to the search results page, with each nearby store displayed on the map as a marker.
</p><p>
The map added in Part 2 certainly improves the search results page, but the way the nearby stores are displayed on the map leaves a bit to be desired. For starters,
each nearby store is displayed on the map using the same marker icon, namely a red pushpin. This makes it difficult to match up the nearby stores listed in the grid
with those displayed on the map. Hovering the mouse over a marker on the map displays the store number in a tooltip, but ideally a user could click a marker to see
more detailed information about the store, such as its address, phone number, a photo of the storefront, and so forth.
</p><p>
This third and final installment shows how to enhance the map created in Part 2. Specifically, see how to customize the marker icons displayed in the map to make
it easier to identify which marker corresponds to which nearby store location. also look at adding rich popup windows to each marker, which includes detailed
store information and can be updated further to include pictures and other HTML content. Read on to learn more!
<br /><a More ></a></p>
Sponsored Links
Read Next: SQL Server 2008 Developer Training Kit
Related Topics
Subscribe via RSS
SQL Server
- Naming Database Objects: Part II
- Trace Messages Part V: Trace Cleanup
- Naming Database Objects: Part I
- Multiple-Child Aggregation
- Creating SQL Tables for an Integrating Application Using Dexterity
- SQL Server 2005 Beta 2 Transact-SQL Enhancements
- .NET Rocks! - Brian Larson on SQL Server Reporting Services
- Computing the Trimmed Mean in SQL
- SQL Server 2000 Gains on Oracle
- Separator First Formatting (SFF)
