Solved

Visual Studio .net asp Google Maps API

Posted on 2013-06-06
4
2,106 Views
Last Modified: 2013-08-21
I need help with the Google Maps API and extracting Geocodes.

In Visual Studio. net (asp.net) when a user presses a button I want to be able to:

Pull addresses from a SQL table that have null Longitude or Latitude ('Lat' and 'Lng' fields), pass the address information (Address, City, State, Zip) to the Google API, retrieve the Longitude and Latitude, then update the orginal SQL table fields 'Lat' and 'Lng'.  

Thank you in advance for your help.
0
Comment
Question by:toddpotter
4 Comments
 
LVL 12

Accepted Solution

by:
Jitendra Patil earned 500 total points
Comment Utility
hi toddpotter

try this link below it contains the working demo of your need.
get latitude and longitude from address google map api

hope this helps
0
 
LVL 16

Expert Comment

by:Rose Babu
Comment Utility
as patil786 suggested, you can use Google maps API.

in that, use GoogleMaps Geocoding API to get LatLng details for a given address

have a look on the below link for the service URL and the examples

https://developers.google.com/maps/documentation/geocoding/

call the service URL with the updated address and then parse the response to get the LatLng values.
0
 

Author Comment

by:toddpotter
Comment Utility
I see the examples, but I am not well experienced on the asp.net side of Visual Studio (I am a beginner); I need more help.  Could you provide me with more in depth info and what code goes in which section.  

For example - I currently have the following:

A form "admin/GeoCode.aspx" which has a button "Geocode Data"

On the "admin/GeoCode.aspx.vb" page I assume I would fill the datatable with addresses and cycle through the table.

I have a class called "GeoCoding.vb" where I would assume that I need to pass the address data from the "admin/GeoCode.aspx.vb" page to the API and return the longitude and latitude back to the datatable (I need help on the code here to pull out the geocode information and return it to the admin/GeoCode.aspx.vb page to update the datatable).

Also, which references do I need?  How do I import for jquery, java, json etc?


Thanks
0
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now