Click here to Skip to main content
15,851,701 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have to plot the point or marker on google map from sql server table. below code can plot a point from database but it only point the last one stored latitude & longitude value in database..
Latitude Longitude is my column name in database...i use literal tag for storing value from database..
this is my aspx page...
XML
<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>


this is cs page load events of above aspx page through which it take value from database..
please improve the code which show all marker on map from database

C#
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();
               
            }
        }
    }
Posted
Updated 26-Sep-12 22:00pm
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900