Paging with SpGridViewPager in SpGridView

 

Ascx

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SgvPagerSampleUserControl.ascx.cs" Inherits="SgvPagerSample.SgvPagerSample.SgvPagerSampleUserControl" %> <SharePoint:SPGridView ID="sgvPagersample" runat="server" AutoGenerateColumns="false" DataSourceID="objSample" AllowPaging="True" PageSize="3"> <Columns> <asp:BoundField HeaderText="Employee ID" DataField="Title" /> <asp:BoundField HeaderText="Employee Name" DataField="EmpName" /> <asp:BoundField HeaderText="Employee Age" DataField="EmpAge" /> </Columns> </SharePoint:SPGridView>     <asp:ObjectDataSource ID="objSample" runat="server" SelectMethod="BindGridView"></asp:ObjectDataSource>     <center>     <SharePoint:SPGridViewPager id="sgvPager" runat="Server" GridViewId="sgvPagersample"></SharePoint:SPGridViewPager>     </center>

Ascx.cs

using System; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using Microsoft.SharePoint; using Microsoft.SharePoint.WebControls; using System.Security; using System.Data; namespace SgvPagerSample.SgvPagerSample {     public partial class SgvPagerSampleUserControl : UserControl     {         protected void Page_Load(object sender, EventArgs e)         {             objSample.TypeName = this.GetType().AssemblyQualifiedName;         }         public DataTable BindGridView()         {             SPWeb currentWeb = SPContext.Current.Web;             SPList lstEmployee = currentWeb.Lists["Employee Details Search"];             SPQuery sQuery = new SPQuery();             sQuery.Query = "<OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy>";             SPListItemCollection myColl = lstEmployee.GetItems(sQuery);             return myColl.GetDataTable();         }     } }