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] ....
View 1 Replies
Similar Messages:
Jan 8, 2014
I have variable as
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...
View 1 Replies
May 7, 2015
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.
View 1 Replies
May 7, 2015
Its relate to series of question again. I have datalist bind sql server whcih is fetching 3 address like
Address 1
Address 2
Address 3
After data list I have textbox which is based address like "Based Address"
I have the below script which calculate distance between 2 textboxex.
I want to to calculate the distance between base textbox and address in datalist item so result will like this
Base Address Pune
Datalist address
Address 1 Bombay result distance between pune and bombay 200 Km
Address 1 Kolkota result distance between pune and kolkata 500 Km
//*********DISTANCE AND DURATION**********************//
var service = new google.maps.DistanceMatrixService();
service.getDistanceMatrix({
[Code].....
View 1 Replies
May 7, 2015
I have 2 texbox and button when i type the address on textboxes it generates 2 google map using google map api and it is working fine.
I need to know how can calculate the distance between 2 addresses?
View 1 Replies
May 7, 2015
I need now load data (title, lat,lng,description) fill from database. Is it possible?
View 1 Replies
Jul 16, 2013
I have Some Set of addresses in may database.I want to locate all these address in google maps How can i achieve that?
View 1 Replies
Dec 9, 2013
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...
View 1 Replies
Feb 28, 2013
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.
View 1 Replies
May 7, 2015
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,
[Code] .....
View 1 Replies
Jul 17, 2015
I use below code in website to show googlemaps
<head>
<meta charset="UTF-8" />
<title>Google Maps</title>
<style type="text/css">
#map-canvas {
[CODE]...
it will show googlemap from coordinate now I want save some coordinate in database and bind these coordinate from database how I can do it?
View 1 Replies
Oct 21, 2015
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">
var markers = [
<asp:Repeater ID="rptMarkers" runat="server">
[CODE]..
My DB Schema -
My DB Sample Data -
How do i display a particular marker on the map based on my search based on the koid or city field?
View 1 Replies
May 7, 2015
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();
[Code] .....
View 1 Replies
Mar 28, 2013
I find this code it get me location but i don't know how to save client location in sql database to retrieval it Later
<html>
<head>
<script src="http://maps.google.com/maps/api/js?sensor=false">
</script>
<script type="text/javascript">
if (navigator.geolocation) {
[Code] ....
View 1 Replies
May 7, 2015
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;
[Code] ....
View 1 Replies
Oct 6, 2013
I want to use google map , which show the location, address
How to do this....?
View 1 Replies
Jul 6, 2013
How to create Google Site Map in asp.net.
View 1 Replies
May 7, 2015
how to find out zip code searching from address?
View 1 Replies
Aug 18, 2015
capture Google mag image when map image is full loaded...
View 1 Replies
May 7, 2015
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>
[CODE]
View 1 Replies
May 7, 2015
How to chnage the google map color only outside of the circle
like this [URL] .....
View 1 Replies
May 7, 2015
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....
View 1 Replies
May 2, 2013
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();
[Code] ....
View 1 Replies
Nov 21, 2013
[URL]
how to change icon marker on google maps to custom shape with label ?
like [URL] website.
View 1 Replies
May 7, 2015
I am using the code below for google maps to show multiple markets and it works fine. but I am confused how to add the following...
If you click a marker and zoom it does not always stay in sync and you lose sight of the market...
View 1 Replies