Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.56 KB | None | 0 0
  1. int RowLength;
  2. String[] lon = null;
  3. String[] lat = null;
  4. protected void Page_Load(object sender, EventArgs e)
  5. {
  6.  
  7. using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection("Server;Port;Database=DB;Uid=U;Pwd=P"))
  8. {
  9. connection.Open();
  10. MySql.Data.MySqlClient.MySqlCommand cmd = connection.CreateCommand();
  11.  
  12.  
  13. cmd.CommandText = "SELECT longitude,latitude FROM table";
  14.  
  15. MySql.Data.MySqlClient.MySqlDataReader datr = cmd.ExecuteReader();
  16.  
  17. lon = new string[datr.FieldCount];
  18. lat = new string[datr.FieldCount];
  19.  
  20.  
  21. rep_loc = new string[datr.FieldCount];
  22. RowLength = datr.FieldCount;
  23.  
  24. while (datr.Read())
  25. {
  26. lon[counter] = datr[0].ToString();
  27. lat[counter] = datr[1].ToString();
  28. counter++;
  29. }
  30. datr.Close();
  31. connection.Close();
  32. }
  33. }
  34.  
  35. <script type="text/javascript">
  36. var lon;
  37. var lat;
  38. var homeLatlng;
  39. var mapOptions;
  40. var map;
  41. var contentString;
  42. var infowindow;
  43.  
  44. function initialize() {
  45.  
  46. //I AM STUCK OVER HERE! and Don't know how to set multiple markers with information window for each marker
  47. for(var i=0;i<='<%=RowLength%>';i++){
  48. homeLatlng = new google.maps.LatLng('<%=lat[0]%>', '<%=lon[0]%>');//initial
  49.  
  50. mapOptions = {
  51. zoom: 5,
  52. center: homeLatlng,
  53. mapTypeId: google.maps.MapTypeId.ROADMAP
  54. };
  55.  
  56.  
  57.  
  58. map = new google.maps.Map(document.getElementById("map-canvas"), mapOptions);
  59.  
  60.  
  61. marker = new google.maps.Marker({
  62. position: homeLatlng,
  63. map: map,
  64. url: "http://www.google.com",
  65. });
  66.  
  67. contentString = '<div id="content" style="color:#000000;">' +
  68. 'This is a test <br>' +
  69. '<a href="www.google.com"> google </a> <br>' +
  70. '</div>';
  71.  
  72.  
  73.  
  74. infowindow = new google.maps.InfoWindow({
  75. content: contentString
  76. });
  77.  
  78. google.maps.event.addListener(marker, 'click', function () { infowindow.open(map, marker) });
  79. }
  80. }
  81. google.maps.event.addDomListener(window, 'load', initialize);
  82.  
  83.  
  84.  
  85.  
  86. </script>
  87.  
  88. <script type="text/javascript">
  89.  
  90. var lat = <%= new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(lat)%>;
  91. var lon = <%= new System.Web.Script.Serialization.JavaScriptSerializer().Serialize(lon)%>;
  92.  
  93. function initialize() {
  94.  
  95. mapOptions = {
  96. zoom: 4,
  97. center: new google.maps.LatLng(lat[0],lon[0]),
  98. mapTypeId: google.maps.MapTypeId.ROADMAP
  99. };
  100.  
  101. infowindow = new google.maps.InfoWindow();
  102.  
  103.  
  104. map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions);
  105.  
  106.  
  107. var len = '<%=RowLength%>';
  108. for (i = 0; i <= len ; i++) {
  109.  
  110. marker = new google.maps.Marker({
  111. position: new google.maps.LatLng(lat[i], lon[i]),
  112. map: map,
  113. url: "http://www.google.com",
  114. });
  115. google.maps.event.addListener(marker, 'click', (function (marker, i) {
  116. return function () {
  117. infowindow.setContent("<div style='color:#000000';> Testing </div>");
  118. infowindow.open(map, marker);
  119. }
  120. })(marker, i));
  121.  
  122.  
  123. }
  124.  
  125. }
  126.  
  127. google.maps.event.addDomListener(window, 'load', initialize);
  128.  
  129.  
  130. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement