Display Multiple Pushpins of City locations on Bing Map load.

Question

Please how do I display multiple City/State  or City/Country pushpins from a datasource (ie: xml, SQL) when Bing Maps loads?
The production datasource only has Cities and not latitudes and longitudes.

(Using Visual Studio 2010 and Silverlight)

Thank you for any assistance.

Answer 1

How do you want to display them? As pushpins or polygons. If you want to display them as pushpins then I would recommend geocoding your data ahead of time (city/state) information so that you have coordinates. If you want polygons then you will need to find a data source that has the boundary information. The sample data that comes with the AJAX Map Data Connector has this: http://ajaxmapdataconnector.codeplex.com/

---

http://rbrundritt.wordpress.com

Answer 2

check my blog for this question http://www.hybridplanet.co.in/2012/02/how-to-add-multiple-pushpins-in-bing.html

Answer 3

This post looks extremely familiar: http://rbrundritt.wordpress.com/2011/10/13/multiple-pushpins-and-infoboxes-in-bing-maps-v7/  Also, it doesn't answer the users question about SQL.

---

http://rbrundritt.wordpress.com

Answer 4

Hi,

Here is interesting approach to populate javascript array from SQL.

I am going to try this later. In my case, all coordinates (lat and long) are in MS Access DB. 

http://forums.asp.net/t/1352821.aspx/1

the Link

After you can use AJAX Bing Map control to display pushpins from array. Definitely you will need to populate latitude and longitude before displaying any pushpins. 

I hope this help.

S.T.