从数据库读出坐标，标记到谷歌地图中！

最新推荐文章于 2022-09-06 15:48:38 发布

最新推荐文章于 2022-09-06 15:48:38 发布 · 268 阅读

文章标签：

#UI #Web #JavaScript #Linq #Google #ViewUI

本文介绍如何从数据库读取坐标并在谷歌地图上进行标注的方法。通过ASP.NET和C#实现坐标数据的获取，利用JavaScript和Google Maps API在网页上动态显示地图及标注点。

从数据库读出坐标，标记到谷歌地图中！

前台

<%@ 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"></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[0].Rows.Count; i++) { text.AppendFormat("mycars[{0}] = new Array('{1}','{2}');", i.ToString(), ds.Tables[0].Rows[i]["jingdu"].ToString(), ds.Tables[0].Rows[i]["weidu"].ToString()); } text.Remove(text.Length - 1, 1); Response.Write(text); } } }