GeekArticles
Database
SQL Server
Database
SQL ServerBuilding a Store Locator ASP.NET Application Using Google Maps API (Part 2)
<p>
Last article, <a a Store Locator ASP.NET Application Using Google Maps API (Part 1)</a>, was the
first in a multi-part article series exploring how to add store locator-type functionality to your ASP.NET website using the free <a
Maps API</a>. Part 1 started with an examination of the database used to power the store locator, which contains a single table named <code>Stores</code> with columns capturing
the store number, its address and its <a and <a coordinates.
Next, we looked at using Google Maps <a service to translate a user-entered address, such as
<b>San Diego, CA</b> or <b>92101</b> into its latitude and longitude coordinates. Knowing the coordinates of the address entered by the user, we then looked at writing a SQL
query to return those stores within (roughly) 15 miles of the user-entered address. These nearby stores were then displayed in a grid, listing the store number, the
distance from the address entered to each store, and the address.
</p><p>
While a list of nearby stores and their distances certainly qualifies as a store locator, most store locators also include a map showing the area searched, with markers
denoting the store locations. This article looks at how to use the Google Maps API, a sprinkle of JavaScript, and a pinch of server-side code to add such functionality to
our store locator. Read on to learn more!
<br /><a More ></a></p>
Sponsored Links
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)
