AJAX Bing Maps Control - Adding pushpins from a database

Posted on 2010-11-24
Last Modified: 2013-03-18
I would like to implement the new AJAX Bing Maps control on our site but I need it to add pushpins from the geocodes located in the database.  I have the attached Javascript code that adds a pin on the client side but I'm not sure that's the most efficient way to do it.  The control is pretty new, so documentation is fairly scant, but this can't be that hard to do.  Hoping someone else has come across this.  Our site is on the .NET 3.5 framework using VB.NET

Thanks in advance,

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
/* Define a style used for infoboxes */
 position: absolute;
 border: solid 2px black;
 background-color: White;
 z-index: 1000;
<script type="text/javascript" src=""></script>
<script type="text/javascript">
var map = null;

function GetMap() {
// Create a new map
map = new Microsoft.Maps.Map(
  credentials: "AqiytoFcEw3KsI0eSD_vhEhC7x1djyOWcJhPiTeSxuu85fhnPUc3jU-TJRkZ_Db8",
  center: new Microsoft.Maps.Location(35.227396, -80.842257),
  mapTypeId: Microsoft.Maps.MapTypeId.road,
  zoom: 10

// Define first pin
var pin = new Microsoft.Maps.Pushpin(
 new Microsoft.Maps.Location(52.6, 1.26), {
 text: '1 pushpin text here!'

// Attach event handlers
Microsoft.Maps.Events.addHandler(pin, 'mouseover', SetInfoBox);
Microsoft.Maps.Events.addHandler(pin, 'mouseout', RemoveInfoBox);

// Add this pushpin to the map

// Create an infobox for a pushpin
function SetInfoBox(e) 
// Calculate the pixel position of this pushpin relative to the map control
var pointLocation = map.tryLocationToPixel(,
// Create a new div
var infodiv = document.createElement("div"); = "infodiv";
infodiv.className = "infobox";

// Place the infobox at the correct pixel coordinates = pointLocation.x; = pointLocation.y;
infodiv.innerHTML =
  "The text of this pushpin is <strong>" + + "</strong><br/>" +
  "The pushpin is located at <strong>" + + "</strong><br/>";
// Add the infobox div as a child to the map
var mapdiv = document.getElementById('mapDiv');

// Remove the infobox for a pushpin
function RemoveInfoBox(e) {
var mapdiv = document.getElementById('mapDiv');
var infodiv = document.getElementById('infodiv');
if (infodiv != null) { mapdiv.removeChild(infodiv); }
<body onload="GetMap();">
<div id='mapDiv' style="position:relative; width:640px; height:480px;"></div>    

Open in new window

Question by:stretch73

Accepted Solution

earthware earned 500 total points
ID: 34205215
the best way I find of doing this is the following

1) create a wcf service (that returns your data as a simple collection of data transfer objects), with json enabled (see here for an example
2) handle the response from the service in your javascript and loop through the collection of points it returns, using the code you already have to individually create and load points

I find this method the best way of doing it because:

1) JSON data is especially small (even better if you enable IIS gzip compression) compared to pre-generating the required javascript code client side and delivery to the server
2) The approach feels much more like how you would normally consume data from a webservice
3) It makes it really simple to dynamically reload data (for example as the map moves) making your solution much simpler to add new features in future
4) You actually map page then ends up not really needing any server side code as its all done in client side javascript, making it easier to debug as the code is in one place
5) you can use the same approach in any server side technology (even PHP webservices


Author Comment

ID: 34205432

Thanks for the response.  I read the page from that link and while it looks like an effective solution it's a bit involved for me as I don't have any WCF experience.  We're only talking about 200 locations for our site so really what I need help with is the communication between .NET and the Javascript.  Not trying to sound ungrateful here, just don't want to reinvent out data transfer wheel while trying to implement this control.  
LVL 29

Expert Comment

by:Kumaraswamy R
ID: 34399044
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS Deployment problem 5 65
Wordpress Query 5 25
AJAX Wordpress Not Reading Variable 2 27
JQuery Search Filter 2 29
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question