locked
Pull Google Maps date from SQL database RRS feed

  • Question

  • User-1042649384 posted

     On a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file.  I did this just to get a feel for working with the API.  It works fine.  However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.

     I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread  has the lat/long information needed for markers.  What is the easiest way for me to get that data from the SQL database?  Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?

    Thank you for ideas and any links to article/tutorials.

     

    Thursday, May 27, 2010 1:31 PM

Answers

  • User-635215137 posted

    you can have a look this post:

    http://www.datawebcoder.com/codeByLanguage/1104/Asp_net_google_map_example_show_addresses_fetched_from_database_.aspx



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 24, 2010 1:24 PM

All replies

  • User527588884 posted

    pull it out as a list and format it in to a xml file your app is familiar with

    Thursday, May 27, 2010 5:14 PM
  • User-1042649384 posted

    could you provide me with a few more details please that will get me started?  I've never done this particular process.  Or some phrases I can google to help me find the info?


    Thursday, May 27, 2010 5:23 PM
  • User-319574463 posted

    Are you trying get information by scraping Google Maps or store the information?

    Sunday, June 27, 2010 9:43 AM
  • User-635215137 posted

    you can have a look this post:

    http://www.datawebcoder.com/codeByLanguage/1104/Asp_net_google_map_example_show_addresses_fetched_from_database_.aspx



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 24, 2010 1:24 PM