title: Integrating database with google static map markers (overlays)
body: <p>I cant find the way to create overlays on the static google map through database. I can acheive the a single marker(location) easily. below is the code:</p>
  
  <p>int mapID = Convert.ToInt16(hdnMapID.Value);
          SqlDataReader dr =  Maps.GetMapPointsByMapIDUserID(mapID, userID);</p>
  
  <pre><code>   string latitude = "53.615143";
     string longitude = "-1.711380";
      string center = "" + latitude + "," + longitude + "";
      string zoom = "20";
      string size = "512x512";
      string maptype = "roadmap";
  
      while (dr.Read())
      {
  
  
              map2.ImageUrl = "http://maps.google.com/maps/api/staticmap?center=" + center + "&amp;zoom=" + zoom + " &amp;size=" + size + "&amp;maptype=" + maptype + "&amp;markers=color:blue|label:S|" + dr["lat"] + ", " + dr["lng"] + "&amp;sensor=true";
          }
  
  
  
          cnt++;
      }
      dr.Dispose();
  </code></pre>
  
  <p>In the above url, its easy to pass marker value (color:blue|label:S|"+ dr["lat"] + "," + dr["lng"] +) for a single location, but in my project I have got multiple locations and I cant find a way to create different urls for multiple locations for instance if there are two locations there will be 2 markers in the above url, how can I create programatically google static url depending on the numbers of markers(overlays) present in the map.</p>
  
  <p>Any tutorial or help will be highly appreciated</p>