Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Visual Studio .net asp Google Maps API

Posted on 2013-06-06
4
Medium Priority
?
2,329 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 13

Accepted Solution

by:
Jitendra Patil earned 1000 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

971 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