Comments by S.M.Arsalan (Top 13 by date)

at map.aspx

<script type="text/javascript" src = "https://maps.googleapis.com/maps/api/js?key=AIzaSyDr1aftH-xmixjAyUBfumW886tqSk_vo-4&sensor=true">
</script>
<script type="text/javascript">
function initialize() {
var markers = JSON.parse('<%=ConvertDataTabletoString() %>');
var markers = JSON.parse('<%=ConvertDataTabletoString1() %>');
var mapOptions = {
center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
zoom: 5,
mapTypeId: google.maps.MapTypeId.ROADMAP
// marker:true
};
var infoWindow = new google.maps.InfoWindow();
var map = new google.maps.Map(document.getElementById("map_canvas"), 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) {

// Attaching a click event to the current marker
google.maps.event.addListener(marker, "click", function (e) {
infoWindow.setContent(data.description);
infoWindow.open(map, marker);
});
})(marker, data);
}
}
</script>

protected void Page_Load(object sender, EventArgs e) {

}

public string ConvertDataTabletoString()
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection("Data Source=arsalan\\sqlexpress;Initial Catalog=FindEvent;Integrated Security=true"))
{
using (SqlCommand cmd = new SqlCommand("select title=Chief-guest,lng=longitude,lat=Latitude,Comment from Event", con))
{

con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List<dictionary<string, object="">> rows = new List<dictionary<string, object="">>();



Dictionary<string, object=""> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary<string, object="">();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return serializer.Serialize(rows);
}

please review a solution i am using

please review a solution i am using

In the upper solution i was getting the result on grid view but now i want to show it on map with markers

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;


namespace FindEvent
{
public partial class map2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//if (!this.IsPostBack)
//{
// DataTable dt = this.GetData("select * from Locations");
// rptMarkers.DataSource = dt;
// rptMarkers.DataBind();
//}
}

protected void UpdatePanel1_Load(object sender, EventArgs e)
{
//Linq is used to load the table to the code
GoogleDataClassesDataContext data = new GoogleDataClassesDataContext();

//Select all from the table
List<city> lst = (from u in data.City select u).ToList();

//add the table contents to the javascript array so that new locations will be loaded
foreach (City item in lst)
{
ScriptManager.RegisterArrayDeclaration(UpdatePanel1, "infoarray", "'" + item.C_ID.ToString() + "'");
ScriptManager.RegisterArrayDeclaration(UpdatePanel1, "lonarray", item.Longitude.ToString());
ScriptManager.RegisterArrayDeclaration(UpdatePanel1, "latarray", item.Latitude.ToString());
ScriptManager.RegisterArrayDeclaration(UpdatePanel1, "bounce", item.Bounce.ToString());
}
}

protected void Timer1_Tick(object sender, EventArgs e)
{

//update the update panel every 10 seconds
UpdatePanel1.Update();
}
}
}

Bring data to show on marker Sir

Yes Sir i have seen this all before but i need to place all details which are coming from the database tables? When every time Event is added by the Guest its marker will automatically shown on the Map?