P/S : Please help, i want to connect with my database but didn't work. Anyone can help me. TQ
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
<script language="javascript" type="text/javascript">
//select coordinates from Mysql DB
var map;
var geocoder;
var marker;
function InitializeMap() {
var latlng = new google.maps.LatLng("", "");
var myOptions =
{
zoom: 17,
center: latlng,
mapTypeId: google.maps.MapTypeId.ROADMAP,
disableDefaultUI: true
};
map = new google.maps.Map(document.getElementById("map"), myOptions);
marker = new google.maps.Marker({ position: new google.maps.LatLng("", ""), map: map });
}
window.onload = InitializeMap;
</script>
</head>
<body style="height: 500px">
<table>
<tr>
</tr>
<tr>
<td colspan="2">
<div id="map" style="height: 529px; width: 100%; margin-top: 0px;">
</div>
</td>
</tr>
</table>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;
public partial class Creating_a_Simple_Map : System.Web.UI.Page
{
public static string latitude;
public static string longitude;
MySqlDataReader dr;
protected void Page_Load(object sender, EventArgs e)
{
using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection("Server=localhost;Database=db;Uid=****;Pwd=****"))
{
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT latitude,longitude FROM signal";
dr = cmd.ExecuteReader();
while (dr.Read())
{
latitude = dr[0].ToString();
longitude = dr[1].ToString();
}
connection.Close();
}
Response.Write("<script type='text/javascript' src='http://maps.googleapis.com/maps/api/js?sensor=false'></script>");
Response.Write("<script language='javascript' type='text/javascript'>"
+ "var map;"
+ "var marker;"
+ "function InitializeMap() {"
+ "var latlng = new google.maps.LatLng(" + latitude + "," + longitude + ");"
+ "var myOptions ="
+ "{ zoom: 17, center: latlng,mapTypeId: google.maps.MapTypeId.ROADMAP,disableDefaultUI: true};"
+ "map = new google.maps.Map(document.getElementById('map'), myOptions);"
+ "marker = new google.maps.Marker({ position: new google.maps.LatLng(" + latitude + ", " + longitude + "), map: map }); }"
+ "window.onload = InitializeMap;"
+ "</script>");
}
}
Submit an article or tip