How to give longitude and latitude from our database to google map function

[AM ASIF]

<script type="text/javascript">
 
 
function initialize() 
{
 
    alert(asd);
var myLatlng = new google.maps.LatLng(26.211954,50.607727);
 
var myOptions = {
zoom: 4,
center: myLatlng,
 
mapTypeId: google.maps.MapTypeId.ROADMAP
}
var map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
 
var marker = new google.maps.Marker({
position: myLatlng,
map: map,
title:"Windsor Tower Hotel "
});
var infowindow = new google.maps.InfoWindow({  
  content: Jnantoures
}); 
infowindow.open(map, marker);  
}
</script>

This is a google map function created by javascript here longitude and latitude directly give the function .But i want the longitude and latitude is given from our database to this function. How to do it? my project is asp.net( useing vb),database is sql server pls rply

[Frinavale]

There's a lot of ways to do this.

But I think the best way would be to write the database value into the script using the ASP Response.Write() method.

First you need to define a variable (or variables) that is either Protected or Public in your Page's Code-Behind. Then you need to fill this variable (or variables) with data retrieved from your database.

After you've done that, switch over to your ASP.NET Design-Code, go to the place where your JavaScript is defined call the Response.Write(variableName) method to write the value of the variable(s) into the page.

Recall that anything between <% %> is server-side code that is called in order to render something at a particular place in your web page.

So, if you have two Public variable called latitudeServerSideVariable and longitudeServerSideVariable in your Page's Code-Behind that you fill with data from your database (say on your Page Load event)...You would then put the following in your JavaScript method to write their values into the script:

function initialize() 
{
 var lat = <%Response.Write(latitudeServerSideVariable);%>
 var long = <%Response.Write(longitudeServerSideVariable);%>
  ....
}

Another, shorthand way to call the Response.Write method is to use <%=. So another way to accomplish the same thing as my above posted code would be to have:

function initialize() 
{
 var lat = <%=latitudeServerSideVariable%>
 var long = <%=longitudeServerSideVariable"%>
  ....
}

-Frinny

[AM ASIF]

how to fill this variable (or variables) with data retrieved from our database.

[Frinavale]

Please read the quick article about how to use a database in your program

-Frinny