从数据库读出坐标，标记到谷歌地图中！
从数据库读出坐标，标记到谷歌地图中！前台
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default4.aspx.cs" Inherits="Default4" %><!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"> <title>无标题页</title></head><mce:script src="http://ditu.google.cn/maps?file=api&v=2&key=abcdefg&sensor=true_or_false" mce_src="http://ditu.google.cn/maps?file=api&v=2&key=abcdefg&sensor=true_or_false" type="text/javascript"></mce:script> <body> <form id="form1" runat="server"> <div id="map" style="width: 700px; height: 450px" align="center"></div> <mce:script type="text/javascript"><!-- var map = new GMap2(document.getElementById("map")); //添加一个控制条 map.addControl(new GSmallMapControl()); //配置中心点经纬度（青海）和缩放系数，并显示 map.setCenter(new GLatLng(35.66,96.74),6); <% GetRootIDArray(); %>; for (i = 0; i < mycars.length; i++) { map.addOverlay(createMarker(new GLatLng(mycars, mycars),i+1)); } //上面这两句是可以设置点，createMarker后面的1可以设置成超连接或者显示东西 //根据数据库里的数据循环输出上面这两句话就可以了，输出所有点function createMarker(point, number) {var marker = new GMarker(point);GEvent.addListener(marker, "click", function() { marker.openInfoWindowHtml("xining<b>" + number + "</b>");});return marker;}//这个函数是输出点击那个点之后出来，输出的内容。// --></mce:script> </form></body></html>
后台
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Web.UI.HtmlControls;public partial class Default4 : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void GetRootIDArray() { SqlConnection conn = MyDB.GetConn(); SqlCommand cmd = new SqlCommand("select jingdu, weidu from jiamengshang", conn); SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(ds); System.Text.StringBuilder text = new System.Text.StringBuilder(); if (ds.Tables.Count > 0) { Response.Write("var mycars=new Array();"); for (int i = 0; i < ds.Tables.Rows.Count; i++) { text.AppendFormat("mycars[{0}]=newArray('{1}','{2}');", i.ToString(), ds.Tables.Rows["jingdu"].ToString(), ds.Tables.Rows["weidu"].ToString()); } text.Remove(text.Length - 1, 1); Response.Write(text); } }}
页:
[1]