You will need to make use if HiddenField to store the GridView Page Size and Page Index.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<style type="text/css">
body
{
font-family: Arial;
font-size: 10pt;
}
table
{
border: 1px solid #ccc;
}
table th
{
background-color: #F7F7F7;
color: #333;
font-weight: bold;
}
table th, table td
{
padding: 5px;
border-color: #ccc;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?sensor=false"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
var google_markers = new Array();
var markers = [
<asp:Repeater ID="rptMarkers" runat="server">
<ItemTemplate>
{
"title": '<%# Eval("Name") %>',
"lat": '<%# Eval("Latitude") %>',
"lng": '<%# Eval("Longitude") %>',
"description": '<%# Eval("Description") %>'
}
</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: 8,
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);
google_markers[google_markers.length] = marker;
}
}
$("[Id*=GridView1] .cell").live("click", function () {
var pageSize = $("[id*=hfPageSize]").val();
var pageIndex = $("[id*=hfPageIndex]").val();
var index = ((pageIndex -1) * pageSize) - 1;
google.maps.event.trigger(google_markers[$(this).parent()[0].rowIndex + index], 'click');
});
</script>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<div id="dvMap" style="width: 500px; height: 500px">
</div>
</td>
<td valign="top" style="padding-left: 20px">
<asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
AllowPaging="true" OnPageIndexChanging="OnPageIndexChanging" PageSize="2" runat="server"
AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" ItemStyle-CssClass = "cell" />
<asp:BoundField DataField="Latitude" HeaderText="Latitude" ItemStyle-Width="30" ItemStyle-CssClass = "cell" />
<asp:BoundField DataField="Longitude" HeaderText="Longitude" ItemStyle-Width="30" ItemStyle-CssClass = "cell" />
<asp:BoundField DataField="Description" HeaderText="Description" ItemStyle-Width="150" ItemStyle-CssClass = "cell" />
</Columns>
</asp:GridView>
<asp:HiddenField ID="hfPageIndex" runat="server"/>
<asp:HiddenField ID="hfPageSize" runat="server" />
</td>
</tr>
</table>
</form>
</body>
</html>
Namespace
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = this.GetData("select * from Locations");
rptMarkers.DataSource = dt;
rptMarkers.DataBind();
GridView1.DataSource = dt;
GridView1.DataBind();
}
this.hfPageIndex.Value = "1";
this.hfPageSize.Value = GridView1.PageSize.ToString();
}
private DataTable GetData(string query)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
return dt;
}
}
}
}
protected void OnPageIndexChanging(object sender, GridViewPageEventArgs e)
{
DataTable dt = this.GetData("select * from Locations");
GridView1.PageIndex = e.NewPageIndex;
this.hfPageIndex.Value = (GridView1.PageIndex + 1).ToString();
GridView1.DataSource = dt;
GridView1.DataBind();
}
Screenshot
