Hi nauna,
Using below two article i have created the example.
Check this example. Now please take its reference and correct your code.
HTML
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=API_Key"></script>
<script type="text/javascript">
var markers = [
<asp:Repeater ID="rptMarkers" runat="server">
<ItemTemplate>
{
"title": '<%# Eval("Name") %>',
"lat": '<%# Eval("Latitude") %>',
"lng": '<%# Eval("Longitude") %>',
"description": '<%# Eval("Pin") %>'
}
</ItemTemplate>
<SeparatorTemplate>
,
</SeparatorTemplate>
</asp:Repeater>
];
</script>
<script type="text/javascript">
window.onload = function () {
var mapOptions = {
center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
zoom: 3,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var infoWindow = new google.maps.InfoWindow();
var map = new google.maps.Map(document.getElementById("dvMap"), mapOptions);
for (i = 0; i < markers.length; i++) {
var data = markers[i]
var myLatlng = new google.maps.LatLng(data.lat, data.lng);
var marker = new google.maps.Marker({
position: myLatlng,
map: map,
title: data.title
});
(function (marker, data) {
google.maps.event.addListener(marker, "click", function (e) {
infoWindow.setContent(data.description);
infoWindow.open(map, marker);
});
})(marker, data);
}
}
</script>
<div id="dvMap" style="width: 100%; height: 500px;"></div>
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.AddRange(new System.Data.DataColumn[] {
new System.Data.DataColumn("Name", typeof(string)),
new System.Data.DataColumn("Pin",typeof(string)) });
dt.Rows.Add("Mumbai", "400093");
dt.Rows.Add("Pune", "411001");
dt.Rows.Add("Alibaug", "402201");
dt.Columns.Add("Latitude");
dt.Columns.Add("Longitude");
foreach (System.Data.DataRow dr in dt.Rows)
{
string address = dr["Pin"].ToString();
string url = "https://maps.google.co.in/maps/api/geocode/xml?address=" + address + "&key=API_Key";
System.Net.WebRequest request = System.Net.WebRequest.Create(url);
using (System.Net.WebResponse response = (System.Net.HttpWebResponse)request.GetResponse())
{
using (System.IO.StreamReader reader = new System.IO.StreamReader(response.GetResponseStream(), System.Text.Encoding.UTF8))
{
System.Data.DataSet dsResult = new System.Data.DataSet();
dsResult.ReadXml(reader);
System.Data.DataTable location = dsResult.Tables["location"];
dr["Latitude"] = location.Rows[0]["lat"];
dr["Longitude"] = location.Rows[0]["lng"];
}
}
}
rptMarkers.DataSource = dt;
rptMarkers.DataBind();
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim dt As System.Data.DataTable = New System.Data.DataTable()
dt.Columns.AddRange(New System.Data.DataColumn() { New System.Data.DataColumn("Name", GetType(String)), New System.Data.DataColumn("Pin", GetType(String))})
dt.Rows.Add("Mumbai", "400093")
dt.Rows.Add("Pune", "411001")
dt.Rows.Add("Alibaug", "402201")
dt.Columns.Add("Latitude")
dt.Columns.Add("Longitude")
For Each dr As System.Data.DataRow In dt.Rows
Dim address As String = dr("Pin").ToString()
Dim url As String = "https://maps.google.co.in/maps/api/geocode/xml?address=" & address & "&key=API_Key"
Dim request As System.Net.WebRequest = System.Net.WebRequest.Create(url)
Using response As System.Net.WebResponse = CType(request.GetResponse(), System.Net.HttpWebResponse)
Using reader As System.IO.StreamReader = New System.IO.StreamReader(response.GetResponseStream(), System.Text.Encoding.UTF8)
Dim dsResult As System.Data.DataSet = New System.Data.DataSet()
dsResult.ReadXml(reader)
Dim location As System.Data.DataTable = dsResult.Tables("location")
dr("Latitude") = location.Rows(0)("lat")
dr("Longitude") = location.Rows(0)("lng")
End Using
End Using
Next
rptMarkers.DataSource = dt
rptMarkers.DataBind()
End If
End Sub
