I have created the pages in dotnet 2.0 c#. This page displays markers of different color for many cars. It gets the data from SQL database, declared in Multiple.aspx.cs file.
Page Name : Multiple.aspx ------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----code below------ <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Multiple.aspx.cs" Inherits="AIS.Multiple" %> <%@ Import Namespace="System.Collections"%> <!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 id="Head1" runat="server"> <title>All Vehicles</title> <style type="text/css">v\:* { behavior:url(#default#VML); } body {margin:0;padding:0;height:100%;} .text { FONT-SIZE: 11px; COLOR: #000000; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif }</style> <script src="http://maps.google.com/maps?file=api&v=2&key=< %=ConfigurationManager.AppSettings["GoogleMapKey"]%>" type="text/javascript"></script> <script type="text/javascript" src="js/ELabel.js"></script> <script type="text/javascript" src="js/mapiconmaker.js"></script> <script type="text/javascript"> var map; var iconOptions = { width: "36", height: "32", primaryColor: "ff0000", cornerColor: "ffffff", strokeColor: "000000" }; var map = null; function plotPoints(map) { <% SortedList multiInfo = (SortedList)Session["multiInfo"]; if(multiInfo != null) { ArrayList mapPoints = (ArrayList)multiInfo["Points4Plot"]; SortedList mapPoint; %> var lats_ = new Array(<%=mapPoints.Count%>); var longs_ = new Array(<%=mapPoints.Count%>); var esn_ = new Array(<%=mapPoints.Count%>); var addr_ = new Array(<%=mapPoints.Count%>); var date_ = new Array(<%=mapPoints.Count%>); var speed_ = new Array(<%=mapPoints.Count%>); var temp = <%=mapPoints.Count%>; <% string posVal = ""; for(int i = 0 ; i < mapPoints.Count; i++) { mapPoint = (SortedList)mapPoints[i]; posVal = mapPoint["lat"].ToString(); Response.Write("\t\t\t\t\tlats_[" + i + "] = " + posVal + "; \n"); posVal = mapPoint["long"].ToString(); Response.Write("\t\t\t\tlongs_[" + i + "] = " + posVal + "; \n"); Response.Write("\t\t\t\t\tesn_[" + i + "] = '" + mapPoint ["esnval"].ToString() + "';\n"); Response.Write("\t\t\t\t\taddr_[" + i + "] = '" + mapPoint ["pos"].ToString() + "';\n"); Response.Write("\t\t\t\t\tdate_[" + i + "] = '" + mapPoint ["date"].ToString() + "';\n"); Response.Write("\t\t\t\t\tspeed_[" + i + "] = '" + mapPoint ["speed"].ToString() + "';\n"); } %> var lastval = temp - 1; //map.setCenter(new GLatLng(lats_[0], longs_[0]),level, G_NORMAL_MAP); map.setCenter(new GLatLng(lats_[lastval], longs_[lastval]),4, G_NORMAL_MAP); var point; var esn; var addr; var date; var spd; for(i=0;i < longs_.length;i++) { point = new GLatLng(lats_[i], longs_[i]); esn = esn_[i]; addr = addr_[i]; date = date_[i]; spd = speed_[i]; //map.addOverlay(createMarker(point, esn, addr, date, spd, i)); createMarker(point, esn, addr, date, spd, i); } var points = []; for (var i = 0; i < longs_.length; i++) points.push(new GLatLng(lats_[i], longs_[i])); <% } %> } function createMarker(point, esn, address, reccDateTime, speed, index) { alert("marker"+ speed); var htmlText = "<span class='text'><center>"; htmlText += "<b>Vehicle Id:" + esn + "</b>"; htmlText += "<br><b>Address : " + address + "</b>"; htmlText += "<br><b>Date-time : " + reccDateTime + "</ b>"; htmlText += "<br><b>Speed : " + speed + "</center></ span>"; createMarkeredLabel(point, htmlText, esn, speed); } // remember which label was associated with the open info window var lastlabel; function createMarkeredLabel(point, html, text, speedchange) { if(speedchange <= 10) { iconOptions.primaryColor = "#00FF00"; iconOptions.cornerColor = "#00FF00"; } if(speedchange > 10 && speedchange < 20) { iconOptions.primaryColor = "#20DF00" iconOptions.cornerColor = "#20DF00"; } if(speedchange >= 20 && speedchange < 30) { iconOptions.primaryColor = "#40BF00"; iconOptions.cornerColor = "#40BF00"; } if(speedchange >= 30 && speedchange < 40) { iconOptions.primaryColor ="#609F00"; iconOptions.cornerColor = "#609F00"; } if(speedchange >= 40 && speedchange < 50) { iconOptions.primaryColor ="#807F00"; iconOptions.cornerColor = "#807F00"; } if(speedchange >= 50 && speedchange < 60) { iconOptions.primaryColor = "#A05F00"; iconOptions.cornerColor = "#A05F00"; } if(speedchange >= 60 && speedchange < 70) { iconOptions.primaryColor ="#C03F00"; iconOptions.cornerColor = "#C03F00"; } if(speedchange >= 70 && speedchange < 80) { iconOptions.primaryColor = "#E01F00"; iconOptions.cornerColor = "#E01F00"; } if(speedchange >= 80) { iconOptions.primaryColor = "#FF0000"; iconOptions.cornerColor = "#FF0000"; } // Create the Label var contents = '<div style="background- color:#ccccff;border:2px solid black"><b>'+text+'</b><\/div>'; var label= new ELabel(point, contents, null, new GSize (8,-30), 75, 1); map.addOverlay(label); iconOptions.strokeColor = "#000000"; var icon = MapIconMaker.createMarkerIcon(iconOptions); //var marker = new GMarker(point); var marker = new GMarker(point, {icon: icon}); GEvent.addListener(marker, "mouseover", function() { marker.openInfoWindowHtml(html); label.setOpacity(100); lastlabel = label; }); map.addOverlay(marker); } function load() { if (GBrowserIsCompatible()) { map = new GMap2(document.getElementById("map")); map.addControl(new GLargeMapControl()); var mapTypeControl = new GMapTypeControl(); map.addControl(mapTypeControl); plotPoints(map); return false; } } </script> </head> <body bgColor="#ebf0e8" leftMargin="0" topMargin="0" marginheight="0" marginwidth="0" onload="load()" onunload="GUnload()"> <form id="form1" runat="server"> <div id="map" style="width: 1255px; height: 768px"></div> </form> </body> </html> ----------------------------------------------------------------------------------------------------------------------------------------------------------------- This file is used to get data from SQL database and pass the value to the Multiple.aspx page, which displays the markers on the map. File Name : Multiple.aspx.cs ----- code below------ using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Web.SessionState; using System.Drawing; using System.ComponentModel; using System.Data.SqlClient; namespace AIS { public partial class Multiple : System.Web.UI.Page { protected SqlConnection con; protected String esnvalue, latitude1, longitude1; protected string username, position; protected string latitude, longitude, speed; protected DateTime ReccDateTime; protected void Page_Load(object sender, EventArgs e) { username = Session["username"].ToString(); GetLocation(username); } protected void GetLocation(string UserName) { SortedList multiInfo = new SortedList(); ArrayList mapPoints = new ArrayList(); SortedList mapPoint = new SortedList(); con = new SqlConnection(ConfigurationManager.AppSettings ["GSMConnStr"]); SqlCommand cmmd = new SqlCommand("[GetLocation]", con); con.Open(); cmmd.CommandType = CommandType.StoredProcedure; cmmd.Parameters.Add("@vcUserName", SqlDbType.VarChar, 20); cmmd.Parameters["@vcUserName"].Value = username; SqlDataReader dr1 = cmmd.ExecuteReader(); while (dr1.Read()) { mapPoint = new SortedList(); mapPoint.Add("esnval", dr1.GetString(1)); mapPoint.Add("lat", dr1.GetString(3)); mapPoint.Add("long", dr1.GetString(4)); mapPoint.Add("pos", dr1.GetString(5)); mapPoint.Add("speed", dr1.GetString(6)); mapPoint.Add("date", dr1.GetDateTime(0)); mapPoints.Add(mapPoint); dr1.NextResult(); } con.Close(); multiInfo.Add("Points4Plot", mapPoints); Session["multiInfo"] = multiInfo; } } } ------------------------------------------------------------------------------------------------------------------------------------------------------------ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
