Pushpins from database

Last post 3/17/2010 2:25:46 AM by timparis. 4 replies. << Back to Web.Maps.VE v3.0 General
9/9/2009 6:49:33 PM
jdjespersen

Pushpins from database

Hi :-)

I have a table in my SQL Server that holds map coordinates that I would like to map using the new 3.0 control.

How do I do this? Creating XML files on disk is not an option.

Sincerely
Jeppe Jespersen
Denmark

9/23/2009 9:59:37 PM
Chris Pietschmann

Re:Pushpins from database

You can use the Dynamic Map Search example within the Sample Website as a perfect example. However, for your case you will replace the code that retrieves the points from an XML file with code that accesses a SQL database. It's really the same thing once you access the necessary location data to add it to the Map for display.
12/30/2009 11:42:30 AM
boehli

Re:Pushpins from database

The dynamic search sample is throwing an exeption on "Gridview1.databind();"

System.Xml.XPath.XPathException was unhandled by user code
  Message="'schooldistricts/schooldistrict[@latitude >= 42,9343069211716 and @latitude <= 43,185152509373 and @longitude >= -88,3953094482422 and @longitude <= -87,9146575927735]' ist ein ungültiger Token."
  Source="System.Xml"

cheers Olli
 
3/5/2010 10:32:45 PM
boehli

Re:Pushpins from database

Hi Chris,

seems to be the right example, but throwing a unsolved error to me:

System.Xml.XPath.XPathException was unhandled by user code
  Message="'schooldistricts/schooldistrict[@latitude >= 42,9202292273379 and @latitude <= 43,1711322847448 and @longitude >= -88,1412506103516 and @longitude <= -87,6605987548828]' ist ein ungültiger Token."
  Source="System.Xml"

would be nice to hear an response from you to verify i am not buying a dead product.

Thanx in advance

Olli
3/17/2010 2:25:46 AM
timparis

Re:Pushpins from database

I'm interest in buying this product too, but the lack of posts from the author in the last 3 months has me wondering if this is a dead product.