<script type="text/javascript"> var map; function initialize() { if (GBrowserIsCompatible()) { map = new GMap2(document.getElementById("map")); var lat = <asp:Literal ID="ltrLat" runat="server" />; var lng = <asp:Literal ID="ltrLng" runat="server" />; var center = new GLatLng(lat, lng); map.setCenter(center, 15); map.setUIToDefault(); var marker = new GMarker(center); map.addOverlay(marker); marker.openInfoWindow("Here"); } } </script>
SqlConnection conn = new SqlConnection("Data Source=.\\SQL2005;Initial catalog=fitnessapp;User Id=sa;Password=123456"); String qry = "select Latitude,Longitude from loglatMaster"; SqlCommand cmd = new SqlCommand(qry, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { DataTable dt = new DataTable(); dt.Load(dr); for (int i = 0; i < 2; i++) { Literal ltrLat = (Literal)FindControl("ltrLat"); Literal ltrLng = (Literal)FindControl("ltrLng"); ltrLat.Text = dt.Rows[i]["Latitude"].ToString(); ltrLng.Text = dt.Rows[i]["Longitude"].ToString(); } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)