Solved

Visual Studio .net asp Google Maps API

Posted on 2013-06-06
4
2,127 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
ID: 39228157
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
ID: 39228318
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
ID: 39234545
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
ID: 39239423
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While working on Silverlight and WCF application, I faced one issue where fault exception occurred at WCF operation contract is not getting propagated to Silverlight client. So after searching net I came to know that it was behavior by default for s…
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 …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

911 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

16 Experts available now in Live!

Get 1:1 Help Now