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 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...
<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?
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]
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 RepliesMaps using only in Client side validation (Not using Asp.Net)
1) It must get the longitude and latitude from CSV file and it must be a fileupload and loads dynamically using Jquery.
2) Multiple markers showing different location.
I want to delete the previous markers when i select new marker below my code.
<html>
<head>
<script
src="http://maps.googleapis.com/maps/api/js?key=AIzaSyDY0kkJiTPVd2U7aTOAwhc9ySH6oHxOIYM&sensor=false">
</script>
<script>
var map;
var myCenter=new google.maps.LatLng(51.508742,-0.120850);
[Code] .....
i'm trying to display location dynamically using google map.
The location will be passed as a parameter as follows.
country, city, address and block number.
How can i implement that?
Reverse Geocoding (Address Lookup)
How can i retrieve map for location after save latitude , longitude in the database....
I used code for saving latitude , longitude [URL] .....
i want to include google maps API into my ASP.NET page and allows users to input the locations(few places) they are going to visit. When the user inserts the location, the google maps API will mark these locations. It means in the maps it will mark the places. some red bubble to indicated the places is marked.
for example,i list a few checkboxes beside the check boxes will have a places'name. when the checkbox is checked, Google maps will make markers on these location. How to do this?
IF after the places is marked in google maps, i want to get some information from google maps (such as the coordinates of the all the marked place). Then, use google maps to run some code behind to find the shortest path using Travelling Salesman Problem (TSP) algorithm.
After that,generate the proper sequences of the places ( which place to go first, and which place to go last). is it possible to be done?
[URL]
I saw this code it is good but,I have to insert letters inside the markers?
If the marker is yellow color we have to insert 'y' inside that yellow color markers,if it is blue 'b' have to insert.
How would I?
private DataTable GetData(string query) {
string conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MySqlCommand cmd = new MySqlCommand(query);
using (MySqlConnection con = new MySqlConnection(conString)) {
using (MySqlDataAdapter sda = new MySqlDataAdapter())
[Code] ....
In above C# code, I want to change the color of DataTable row "Upstream" based on If condition from code behind. I tried below code, but its not working:
decimal res = Convert.ToDecimal(Upstream);
if (res <= 0 && res >= 2) {
Color col = ColorTranslator.FromHtml("#0000FF");
Upstream = Color.Blue;
} else {
Color col = ColorTranslator.FromHtml("#FFFFFF");
Upstream = Color.Red;
}
I have a scenario where, when user searches for a particular program a list of possible programs should be displayed from database and show it on google map with google markers depicting those addresses. I have achieved it successful with your answer ASP.Net: Populate Google Maps V3 with Multiple Markers using Address Latitude and Longitude values stored in database
Now my question is how can we display those markers with numbers and show the address corresponding to that number in listview.
For Reference [URL] ...
Type basketball in the field QuickSearch and click the search button ...
I have per minute Lat-Lang values of user and using it i want to draw a Route on Google Maps with arrow to show direction after some distance.
I am using this tutorial for reference but unable to modify the same.
[URL]
i am getting multiple marker from database (like places visit) . But on same page i have to get a single marker(represent the current position)
my query to get sing marker is
DataTable dt = this.GetData("select top 1 * from LocationDB ORDER BY Locationid DESC");
rptMarkers.DataSource = dt;
rptMarkers.DataBind();
i get only multiple marke in the first div and in othe div its empty (to show current position).
how can i show two different map on one page.
I am using multiple maker in google maps but I have requied all marker infowindow is always open. How I can do it? my code for multiple marker is -
window.onload = function () {
var mapOptions = {
center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
[Code].....
I need now load data (title, lat,lng,description) fill from database. Is it possible?
View 1 RepliesI 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] ....
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 RepliesI 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] .....
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?
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].....
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] .....
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] ....
I have written the following code to display multiple markers in google map and i succeeded in it.Now i want to have a drop animation applied to markers and want to drop marker after a specific interval of time.I know i want to call setTimeout method ,but don't know where to call this method to achieve the result
<script type="text/javascript">
window.onload=function(){
if(markers.length>0){
var mapOptions={
center:new google.maps.LatLng(markers[0].lat,markers[0].lng),
[Code] ....