Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET SQL-Server
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...
<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

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 26-Sep-12 7:11am
Edited 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)

  Print Answers RSS
0 Zoltán Zörgő 265
1 /\jmot 205
2 CHill60 145
3 Peter Leow 145
4 CPallini 135
0 Sergey Alexandrovich Kryukov 9,363
1 OriginalGriff 6,881
2 Peter Leow 4,577
3 Zoltán Zörgő 4,184
4 CHill60 2,892


Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 27 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100