Google maps show current location and state?

Hi Team

I need some help, my google app does not show correctly my current location, it must show South Africa, Port Elizabeth. But currently these co-ordinates are far from the continent in Africa which is not good for a user to see this, please help.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.SqlClient;
using System.Configuration;
namespace eNtsaRegistrationTraining.Controllers
{
public class MapsController : Controller
{
// GET: Maps
public ActionResult GoogleMaps()
{
string markers = "[";
string conString = ConfigurationManager.ConnectionStrings["eNtsaRegistration"].ConnectionString;
SqlCommand cmd = new SqlCommand("SELECT * FROM Locations");
using (SqlConnection con = new SqlConnection(conString))
{
cmd.Connection = con;
con.Open();
using(SqlDataReader sdr = cmd.ExecuteReader())
{
while(sdr.Read())
{
markers += "{";
markers += string.Format("'title': '{0}',", sdr["Name"]);
markers += string.Format("'lat': '{0}',", sdr["Latitute"]);
markers += string.Format("'lng': '{0}',", sdr["Longitute"]);
markers += string.Format("'description': '{0}',", sdr["Description"]);
markers += "},";
}
}
con.Close();
}
markers += "];";
ViewBag.Markers = markers;
return View();
}
}
}

@{
ViewBag.Title = "GoogleMaps";
Layout = null;
}
"viewport" content="width=device-width"/>
eNtsa Office Location
"dvMap" style="width: 500px; height: 500px">

"text/javascript" src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCKm-dbDykfx2EIjKiZ0Wml8ehHep6K90M">

"text/javascript">

var markers = @Html.Raw(ViewBag.Markers);

window.onload = function () {

var mapOptions = {

center: new google.maps.LatLng(markers[0].lat, markers[0].lng),

zoom: 8,

mapTypeId: google.maps.MapTypeId.ROADMAP

};

var infoWindow = new google.maps.InfoWindow();

var map = new google.maps.Map(document.getElementById("dvMap"), mapOptions);

for (i = 0; i < markers.length; i++) {

var data = markers[i]

var myLatlng = new google.maps.LatLng(data.lat, data.lng);

var marker = new google.maps.Marker({

position: myLatlng,

map: map,

title: data.title

});

(function (marker, data) {

google.maps.event.addListener(marker, "click", function (e) {

infoWindow.setContent(data.description);

infoWindow.open(map, marker);

});

})(marker, data);

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Hi Amit

I have this link had to follow in order to make my app work, https://developers.google.com/maps/documentation/javascript/examples/place-search
Amit Mohanty6y ago
Hey Port Elizabeth: Latitude = -33.991360 and Longtude = 25.656912

Please update your database with the above value and try again.
Guest User6y ago
I am now amending my filed correctly on the table. apperantly they not accurate one of the reason. No its not

I think googleapi, has this restriction for using API key for places, now my Question is to you Lax is they using on place as var sydeny to acess the latitute and longitute. Must i have to do the same having each mapped out? But then what is the purpose of running query for the table name with my fields from the database?

https://developers.google.com/maps/documentation/javascript/examples/place-search
Guest User6y ago
Hi
Laxmidhar Sahoo6y ago
Hi
I think insted of your database use google map place service may provide better acuracy.
Follow the bellow link
https://developers.google.com/maps/documentation/javascript/places
Amit Mohanty6y ago
What are the coordinates for Port Elizabeth South Africa?

Is it Latitude= -33.991360 and Longtude=25.656912 ???