1 后台cs代码
2 using System;
3 using System.Collections.Generic;
4 using System.Linq;
5 using System.Web;
6 using System.Web.UI;
7 using System.Web.UI.WebControls;
8 using System.Data.OleDb;
9 using System.Data;
10 using System.Collections;
11
12 public partial class VideoSource : System.Web.UI.Page
13 {
14 public string[] lat = null;//存放纬度值
15 public string[] lng = null;//存放经度值
16 public int lng_len = 0;//用于获得数组长度
17 public int k = 0;//用于赋值循环
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 ArrayList lng_list = new ArrayList();
21 ArrayList lat_list = new ArrayList();
22 OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("App_Data/Database1.accdb"));
23 con.Open();
24 string sql = "select * from tb_videos";
25 try
26 {
27 OleDbDataAdapter gh = new OleDbDataAdapter(sql, con);
28 DataSet ds = new DataSet();
29 gh.Fill(ds);
30 con.Close();
31 foreach (DataRow DR in ds.Tables[0].Rows)
32 {
33 lng_list.Add(DR[2].ToString());
34 lat_list.Add(DR[3].ToString());
35 }
36 }
37 catch
38 {
39 con.Dispose();
40 }
41 lng = (string[])lng_list.ToArray(typeof(string));
42 lat = (string[])lat_list.ToArray(typeof(string));
43 lng_len = lng_list.Count;
44 }
45
46 aspx代码
47 <script type="text/javascript">
48 var jingdu = new Array();
49 var weidu = new Array();
50 <%
51 for(int k=0;k<lng_len;k++){
52 %>
53 jingdu.push("<%=lng[k]%>");
54 weidu.push("<%=lat[k]%>");
55 <%
56 }
57 %>
58 var latlng=[];
59 for(var i=0;i<jingdu.length;i++){
60 latlng.push(new google.maps.LatLng(jingdu[i],weidu[i]));
61 }
62 </script>