<asp:ObjectDataSource ID="obsFriends" runat="server" 
	SelectCountMethod="CountFriends"
	SelectMethod="ViewFriends" TypeName="friends" EnablePaging="true">
</asp:ObjectDataSource>
 

 
using System;
using System.Data;
using System.Configuration;
using System.ComponentModel;
using System.Data.SqlClient;
 
[DataObject()]
public class friends
{
    [DataObjectMethod(DataObjectMethodType.Select)]
    public static DataTable ViewFriends(Int32 maximumRows, Int32 startRowIndex)
    {
        using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString))
        {
            using (SqlCommand command = new SqlCommand("ViewFriends", connection))
            {
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@maximumRows", maximumRows);
                command.Parameters.AddWithValue("@startRowIndex", startRowIndex);
                using (SqlDataAdapter adapter = new SqlDataAdapter(command))
                {
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    return dt;
                }
            }
        }
    }
 
    [DataObjectMethod(DataObjectMethodType.Select)]
    public static Int32 CountFriends()
    {
        using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Default"].ConnectionString))
        {
            using (SqlCommand command = new SqlCommand("CountFriends", connection))
            {
                command.CommandType = CommandType.StoredProcedure;
                connection.Open();
                return Convert.ToInt32(command.ExecuteScalar());
            }
        }
    }
}
 

 
CREATE TABLE [dbo].[friends](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[firstname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[lastname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_friends] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
 

 
INSERT INTO friends(firstname, lastname) VALUES ('Julie', 'Truter')
INSERT INTO friends(firstname, lastname) VALUES ('Eugene', 'Stander')
INSERT INTO friends(firstname, lastname) VALUES ('Pam', 'Nizar')
INSERT INTO friends(firstname, lastname) VALUES ('Alexander', 'Mehlhorn')
INSERT INTO friends(firstname, lastname) VALUES ('Roland', 'Cooper')
INSERT INTO friends(firstname, lastname) VALUES ('Loren', 'Stevens')
INSERT INTO friends(firstname, lastname) VALUES ('Edward', 'Anderson')
INSERT INTO friends(firstname, lastname) VALUES ('Wayne', 'Kleynhans')
 

 
CREATE PROCEDURE [dbo].[ViewFriends]
	@maximumRows AS INT, 
	@startRowIndex AS INT
AS
BEGIN
	WITH entries AS 
	( 
		SELECT ROW_NUMBER() OVER (ORDER BY id ASC) AS ROW, id, firstname, lastname
		FROM friends
	)
 
	SELECT firstname, lastname
	FROM entries 
	WHERE ROW BETWEEN 
		@startRowIndex+1 AND (@startRowIndex + @maximumRows)
END
 

 
CREATE PROCEDURE CountFriends
AS
BEGIN
	SELECT COUNT(*) FROM friends
END
 

 
<asp:DataPager runat="server" ID="dpFriends" PagedControlID="lvFriends" PageSize="3">
	<Fields>
		<asp:NumericPagerField ButtonType="Link" />
	</Fields>
</asp:DataPager>
 

 
<asp:ListView ID="lvFriends" DataSourceID="obsFriends" runat="server" ItemPlaceholderID="phFriends">
	<LayoutTemplate>
		<table>
			<tr style="background-color: Black; color: White">
				<td>
					Firstname
				</td>
				<td>
					Lastname
				</td>
			</tr>
			<asp:PlaceHolder ID="phFriends" runat="server"></asp:PlaceHolder>
		</table>
	</LayoutTemplate>
	<ItemTemplate>
		<tr>
			<td>
				<%# Eval("firstname") %>
			</td>
			<td>
				<%# Eval("lastname") %>
			</td>
		</tr>
	</ItemTemplate>
</asp:ListView>