Web Forms :: Using Database Values To Create Static Google Maps?
Feb 25, 2011
I was looking for a solution on how to create a static google map by passing longitude and latitude value through database. What I want to do is to create a static image as PDF conversion requires static image. Thats why I want a static image so that I can convert aspx page into pdf and then email that map to the customer.
I have to create a text box where if user will enter something it should show the values from database like google shows.e.g If i press a it should display a if i have entered AJ it should show all the list which start from AJ.Same like google.
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?
I used a Google Maps Distance Finder API that comes with two textboxes, one for the source, and one for the destination. It also comes with a button, that when clicked, will find the distance between the two locations using the funciton GetDistance(). The code before the function initializes the map. I created another button and used VB.Net to run SQL code first, and then to automatically populate the two textboxes, then I had it call the function GetDistance().
The issue I ran into is that the function won't calculate the distance, and the map never changes from its default state. I believe it's because it's not running the code that initializes the map. (I could be wrong) I have tried WebBrowser1, to call the click of the button, but I had to Inherit Forms, which I can't do, and I have also tried adding the top code into the GetDistance() function. Is it possible to call the initializing code before GetDistance()?
Here is the JS function code:
<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false&libraries=places"></script> <script type="text/javascript"> var source, destination; var directionsDisplay; var directionsService = new google.maps.DirectionsService(); google.maps.event.addDomListener(window, 'load', function () {
[Code] ....
Here is the VB Code I use to call the JS Function:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Dim cn As New OleDb.OleDbConnection("Provider = Microsoft.ACE.OleDb.12.0;" & _ "Data Source=|DataDirectory|Address Database One Calculation.mdb") cn.Open() Dim cmd1 As OleDb.OleDbCommand Dim sqlconnection1 As String
[Code] .....
For reference, here is the explanation of the full API Code: [URL] ....
I need to use a map in an application that I develop. In my application I want to use pins that will show infoboxes on the map. Use the zoom in, zoom out functionality and the ability to show several maps on the same page. I won't need to use the search locations or routing directions.Which type of maps should I use? Google or Bing? As I understand, they both have good user interface, but which one is easier to develop with? If I'll use Bing then will it be more Microsoft like, I mean, it will let me use visual studio convenient programming? More or less javascript so it will be a hassle do debug it?
I want to display data from database in GeoMap. My database table is:
Station Name Danger Levels St-01 Normal(blue) St-02 Danger(red) St-06 Warning(yellow) St-10 Danger(red) St-11 Warning(yellow)
Now in GeoMap, For Particular state(of Malaysia), I need to show the different stations and danger level(using colors defined in above table) related to each stations (from above database table). Need to understand the code as per my requirement: URL...
I've a scenario in my website where there is a search page.
When the user fills the search criteria and submits the search button , a Google map will be displayed with a pin depicting the addresses listed by the returned records.
I have a problem with displaying maps in page load the map is displayed, but when I want to execute the code on a button click the map is not displayed
Function javascript function AfficherMap() { // alert("ssss"); var mapOptions = { center: new google.maps.LatLng(markers[0].lat, markers[0].lng), zoom: 10,
This is code for searching latitude and longitude . so how to save into database.
function GetLocation() { var geocoder = new google.maps.Geocoder(); var address = document.getElementById("txtAddress").value; geocoder.geocode({ 'address': address }, function (results, status) { if (status == google.maps.GeocoderStatus.OK) { var latitude = results[0].geometry.location.lat();
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:
[code]....
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.
I've implemented a google map with points and stuff that uses an address that the user inputs. When you click a point, the popup bubble appears with the name and address in.Often this name and address is a prominent location, as it's used for meetings and things, such as a university. If you google the address yourself on maps.google.co.uk then you get google's own popup bubble, which often has a photo, information, opening hours, links to directions, reviews, etc. etc.I am wondering if there's a way to use that popup dialog instead of my own, where it is available. I can't see anything in the API to do this.I'm using V2 as we support IE6 in a lot of our users, but I've been told recently I can upgrade to V3 should I need functionality from it.
just want to add the effect of map momentum by the dragging of map as in maps.google.com has. currently on my map where i stop dragging the map stops there but in maps.google.com if you drag a mouse the map will not stop there it will continue the movement in the same direction for a second or few cordinates (i dont know basically), but I want the same thing on my google map. I am using GMap2.
am working on google maps api to store the latittude and longitude into the MS Access Database..I want to add the markers to the particular locations and store it onto the database...
I am creating a business directory website which has street addresses stored in the database. I would like to calculate the distance from a given zipcode to the street address using google maps in ASP.Net.I don't even know where to begin.
In my web page displaying the list of products with address (store location) and hyper link say 'map' in gridview. Beside gridview there is one google map embedded in div. when ever user clicks on 'map' hyper link in girdview the corresponding location should show in popup in google maps. In my database i have only complete address for the each products.
I am attempting to create an ASP.NET website that incorporates Google Maps to geocode the location of bus stops that the user selects from a gridview that is bound to a SQL database. Any ideas on how to use a buttonfield to pass the address (text) for a given row to a command that will geocode that address and place a marker on the map?