87,901
社区成员
发帖
与我相关
我的任务
分享
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!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>Untitled Page</title>
<script type="text/javascript">
<%=GetRootIDArray() %>;
</script>
</head>
<body onload="initialize()" onunload="GUnload()">
<script src="http://ditu.google.cn/maps?file=api&v=2&key=abcdefg&sensor=true_or_false"
type="text/javascript"></script>
<div id="map" style="width: 700px; height: 450px" align="center"></div>
<script src="js/test.js" type="text/javascript" ></script>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</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 Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected string 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)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
text.AppendFormat("jingxiaoshang[ {0} ] = new Array('{1}','{2}');", i.ToString(), ds.Tables[0].Rows[i]["jingdu"].ToString(), ds.Tables[0].Rows[i]["weidu"].ToString());
}
}
Label1.Text = text.ToString();
return text.ToString();
}
}
var jingxiaoshang = new Array();
var map = new GMap2(document.getElementById("map"));
//添加一个控制条
map.addControl(new GSmallMapControl());
//配置中心点经纬度(青海)和缩放系数,并显示
map.setCenter(new GLatLng(35.66, 96.74), 6);
//var jingxiaoshang = new Array();
for (i = 0; i < jingxiaoshang.length; i++) {
var temp = point + i;
temp = new GLatlng(jingxiaoshang[i][0], jingxiaoshang[i][1]);
map.addOverlay(createMarker(temp, i));
}
//var point2 = new GLatLng(36.56, 101.74);
//map.addOverlay(createMarker(point2, 2));
//上面这两句是可以设置点,createMarker后面的1可以设置成超连接或者显示东西
//根据数据库里的数据循环输出上面这两句话就可以了,输出所有点
function createMarker(point, number) {
var marker = new GMarker(point);
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowHtml("xining<b>" + number + "</b>");
});
return marker;
}
//这个函数是输出点击那个点之后出来,输出的内容。
USE [binge]
GO
/****** 对象: Table [dbo].[jiamengshang] 脚本日期: 10/11/2009 23:06:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[jiamengshang](
[jiamengshangId] [int] NULL,
[bianhao] [varchar](10) NULL,
[sheng] [varchar](10) NULL,
[shi] [varchar](10) NULL,
[wangwangId] [varchar](10) NULL,
[QQId] [varchar](10) NULL,
[website] [varchar](10) NULL,
[dizhi] [varchar](10) NULL,
[jingdu] [varchar](10) NULL,
[weidu] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
insert jiamengshang (jiamengshangId,bianhao,sheng,shi,wangwangId,QQId,website,dizhi,jingdu,weidu) values ( 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36.08','101.09')
insert jiamengshang (jiamengshangId,bianhao,sheng,shi,wangwangId,QQId,website,dizhi,jingdu,weidu) values ( 2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36.18','101.19')
function showAddress(address) {
if (geocoder && !big) {
geocoder.getLatLng(
address,
function(point) {
if (!point) {
alert("不能解析: " + address);
} else {
var marker = new GMarker(point);
map.addOverlay(marker);
map.setCenter(point, 13);
}
}
);
}
}
protected string 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)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
text.AppendFormat("jingxiaoshang[ {0} ] = new Array('{1}','{2}');", i.ToString(), ds.Tables[0].Rows[i]["jingdu"].ToString(), ds.Tables[0].Rows[i]["weidu"].ToString());
}
}
Label1.Text = text.ToString();
return text.ToString();
}
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head id="Head1"><title>
Untitled Page
</title></head>
<body onload="initialize()" onunload="GUnload()">
<div id="map" style="width: 700px; height: 450px" align="center"></div>
<script src="http://ditu.google.cn/maps?file=api&v=2&key=abcdefg&sensor=true_or_false"
type="text/javascript"></script>
<script type="text/javascript"> var jingxiaoshang = new Array(); jingxiaoshang[0] = new Array('36.08','101.09');jingxiaoshang[1] = new Array('36.18','101.19'); </script>
<script type="text/javascript">
var map = new GMap2(document.getElementById("map"));
//添加一个控制条
map.addControl(new GSmallMapControl());
//配置中心点经纬度(青海)和缩放系数,并显示
map.setCenter(new GLatLng(35.66, 96.74), 6);
for (i = 0; i < jingxiaoshang.length; i++) {
map.addOverlay(createMarker(new GLatlng(jingxiaoshang[i][0], jingxiaoshang[i][1]), i + 1));
}
// var point2 = new GLatLng(36.56, 101.74);
// map.addOverlay(createMarker(point2, 2));
//上面这两句是可以设置点,createMarker后面的1可以设置成超连接或者显示东西
//根据数据库里的数据循环输出上面这两句话就可以了,输出所有点
function createMarker(point, number) {
var marker = new GMarker(point);
GEvent.addListener(marker, "click", function() {
marker.openInfoWindowHtml("xining<b>" + number + "</b>");
});
return marker;
}
//这个函数是输出点击那个点之后出来,输出的内容。
</script>
<span id="Label1">jingxiaoshang[0] = new Array('36.08','101.09');jingxiaoshang[1] = new Array('36.18','101.19');</span>
</body>
</html>