Social Networking :: Google Maps Distance Calculator From Database
Mar 26, 2016
I used a Google Maps Distance Finder API that comes with two textboxes, one for the source, and one for the destination. It also comes with a button, that when clicked, will find the distance between the two locations using the funciton GetDistance(). The code before the function initializes the map. I created another button and used VB.Net to run SQL code first, and then to automatically populate the two textboxes, then I had it call the function GetDistance().
The issue I ran into is that the function won't calculate the distance, and the map never changes from its default state. I believe it's because it's not running the code that initializes the map. (I could be wrong) I have tried WebBrowser1, to call the click of the button, but I had to Inherit Forms, which I can't do, and I have also tried adding the top code into the GetDistance() function. Is it possible to call the initializing code before GetDistance()?
Here is the JS function code:
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false&libraries=places"></script>
<script type="text/javascript">
var source, destination;
var directionsDisplay;
var directionsService = new google.maps.DirectionsService();
google.maps.event.addDomListener(window, 'load', function () {
[Code] ....
Here is the VB Code I use to call the JS Function:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim cn As New OleDb.OleDbConnection("Provider = Microsoft.ACE.OleDb.12.0;" & _
"Data Source=|DataDirectory|Address Database One Calculation.mdb")
cn.Open()
Dim cmd1 As OleDb.OleDbCommand
Dim sqlconnection1 As String
[Code] .....
For reference, here is the explanation of the full API Code: [URL] ....
var from_Lati = 19.132324234 // from latitude var from_longi = 19.11233334 // from longitude
and I have TO latitude and Longitude in Array as
var To_Lati = [18.132323,18.90941,18.31232423] // to latitude in array var To_Longi = [18.2132123,18.242423,18.43243] // to longitude in array
I have gone through many reference on internet but can't find the solution for calculating the distance with respect to array.. Now I want to find the distance between them using JavaScript...
I want to create a google maps that it can Calculate Distance, Travel Duration, draw (plot) Route between two locations and display Directions. Now I want to hide Directions Panel.
I want to display data from database in GeoMap. My database table is:
Station Name Danger Levels St-01 Normal(blue) St-02 Danger(red) St-06 Warning(yellow) St-10 Danger(red) St-11 Warning(yellow)
Now in GeoMap, For Particular state(of Malaysia), I need to show the different stations and danger level(using colors defined in above table) related to each stations (from above database table). Need to understand the code as per my requirement: URL...
I've a scenario in my website where there is a search page.
When the user fills the search criteria and submits the search button , a Google map will be displayed with a pin depicting the addresses listed by the returned records.
I have a problem with displaying maps in page load the map is displayed, but when I want to execute the code on a button click the map is not displayed
Function javascript function AfficherMap() { // alert("ssss"); var mapOptions = { center: new google.maps.LatLng(markers[0].lat, markers[0].lng), zoom: 10,
This is code for searching latitude and longitude . so how to save into database.
function GetLocation() { var geocoder = new google.maps.Geocoder(); var address = document.getElementById("txtAddress").value; geocoder.geocode({ 'address': address }, function (results, status) { if (status == google.maps.GeocoderStatus.OK) { var latitude = results[0].geometry.location.lat();
Following the series of question, this is the code as of now has been developed and working fine. Now need to make some more tweek with this
1. Instead of distance from source to destination in KM can we have it in Miles
2. I need to show the distance between source and destinace only if destination falls under 25 mile radius from source else need to show the label message that no record found.
Here is the code
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="sqlmap.aspx.cs" Inherits="sqlmap" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">
[Code] ....
C# file ----- using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient;
I am looking for multi marker google map from sql server database, I have following code with me which is working perfectly fine but instead of fetching data from sql server it is fetching from xml. How can bind it from sql server to show multi marker.
xml data
<markers> <marker address="630 LAS GALLINAS, San Rafael CA"/> <marker address="2ND ST, Novato CA"/> <marker address="2402 SIR FRANCIS DRAKE BLVD, fairfax CA"/>
<marker address="255 CANAL ST, San Rafael CA"/> </markers>
i have to display google map with movable pushins(marker).if we will drag these on anoother location and click the submit button than new lattitude nad longitude will be save in the database and updat also....
I have wriiten the following code to avoid zoomout of the markers and to place the makers center to the map.
var bounds=new google.maps.LatLngBounds();map.fitBounds(bounds);map.setCenter(bounds.getCenter());
The above code is working correctly.But when i wrote setInterval function to drop the markers after a specific interval of time , the above piece of code is not working and the map is not getting displayed.This the code i have written
window.onload = function () { var mapOptions = { center: new google.maps.LatLng(markers[0].lat, markers[0].lng), mapTypeId: google.maps.MapTypeId.ROADMAP }; var infoWindow = new google.maps.InfoWindow();