Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NETSQL-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 6:11am
Edited 26-Sep-12 21:00pm
v3

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 515
1 OriginalGriff 498
2 Abhinav S 305
3 sanket saxena 295
4 thatraja 235
0 Sergey Alexandrovich Kryukov 8,482
1 OriginalGriff 4,830
2 Peter Leow 3,794
3 Maciej Los 3,515
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web01 | 2.8.140415.2 | Last Updated 27 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid