<asp:DataList ID="DataList1" runat="server" RepeatColumns = "2"  RepeatLayout = "Table"  Width = "500px">

   <ItemTemplate>

            <br />

            <table cellpadding = "5px" cellspacing = "0" class="dlTable">

            <tr>

                <td>

                    <asp:Image ID="Image1" runat="server" ImageUrl = '<%# Eval("FilePath")%>'

                    Width = "200px" Height = "200px"/>

                </td>

            </tr>

            </table>

            <br />

        </ItemTemplate>

 </asp:DataList>

CREATE PROCEDURE [dbo].[spx_Pager]

      @PageNo int = 1,

      @ItemsPerPage int = 2,

      @TotalRows int out

AS

BEGIN

  SET NOCOUNT ON

  DECLARE

    @StartIdx int,

    @SQL nvarchar(max), 

    @SQL_Conditions nvarchar(max), 

    @EndIdx int

      IF @PageNo < 1 SET @PageNo = 1

      IF @ItemsPerPage < 1 SET @ItemsPerPage = 10

      SET @StartIdx = (@PageNo -1) * @ItemsPerPage + 1

      SET @EndIdx = (@StartIdx + @ItemsPerPage) - 1

      SET @SQL = 'SELECT FilePath

                FROM (

                SELECT  ROW_NUMBER() OVER(ORDER BY ID) AS Row, *

                      FROM  tblFiles ) AS tbl WHERE  Row >= '

                                    + CONVERT(varchar(9), @StartIdx) + ' AND

                       Row <=  ' + CONVERT(varchar(9), @EndIdx)

      EXEC sp_executesql @SQL

      SET @SQL = 'SELECT @TotalRows=COUNT(*) FROM tblFiles'

      EXEC sp_executesql

        @query = @SQL,

        @params = N'@TotalRows INT OUTPUT',

        @TotalRows = @TotalRows OUTPUT

END

private int CurrentPage = 1;

private int ItemsPerPage = 2;

Private CurrentPage As Integer = 1

Private ItemsPerPage As Integer = 2

<asp:Panel ID="pnlPager" runat="server" Height="20px" Width="153px">

    <asp:LinkButton ID="lnkPrev" runat="server" CommandName = "Previous"

        Text = "<< Previous" OnClick = "Pager_Click"></asp:LinkButton>

    &nbsp;

    <asp:LinkButton ID="lnkNext" runat="server" CommandName = "Next"

        Text = "Next >>"  OnClick = "Pager_Click"></asp:LinkButton>

</asp:Panel>

protected void Pager_Click(object sender, EventArgs e)

{

    LinkButton lnkPager = (LinkButton)sender;

    int PageNo = 1;

    switch (lnkPager.CommandName)

    {

        case "Previous":

            PageNo = this.CurrentPage - 1;

            break;

        case "Next":

            PageNo = this.CurrentPage + 1;

            break;

    }

    int TotalRows = this.BindList(PageNo);

    int PageCount = this.CalculateTotalPages(TotalRows);

    ViewState["CurrentPage"] = PageNo;

    if (PageNo == 1)

    {

        lnkPrev.Enabled = false;

    }

    else

    {

        lnkPrev.Enabled = true;

    }

    if (PageNo == PageCount)

    {

        lnkNext.Enabled = false;

    }

    else

    {

        lnkNext.Enabled = true;

    }

}

Protected Sub Pager_Click(ByVal sender As Object, ByVal e As EventArgs)

        Dim lnkPager As LinkButton = DirectCast(sender, LinkButton)

        Dim PageNo As Integer = 1

        Select Case lnkPager.CommandName

            Case "Previous"

                PageNo = Me.CurrentPage - 1

                Exit Select

            Case "Next"

                PageNo = Me.CurrentPage + 1

                Exit Select

        End Select

        Dim TotalRows As Integer = Me.BindList(PageNo)

        Dim PageCount As Integer = Me.CalculateTotalPages(TotalRows)

        ViewState("CurrentPage") = PageNo

        If PageNo = 1 Then

            lnkPrev.Enabled = False

        Else

            lnkPrev.Enabled = True

        End If

        If PageNo = PageCount Then

            lnkNext.Enabled = False

        Else

            lnkNext.Enabled = True

        End If

End Sub

private int BindList(int PageNo)

{

    int TotalRows = 0;

    DataTable dt = new DataTable();

    String strConnString = System.Configuration

        .ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

    SqlConnection con = new SqlConnection(strConnString);

    SqlDataAdapter sda = new SqlDataAdapter();

    SqlCommand cmd = new SqlCommand("spx_Pager");

    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.Add("@PageNo", SqlDbType.Int).Value = PageNo;

    cmd.Parameters.Add("@ItemsPerPage", SqlDbType.Int).Value = ItemsPerPage;

    cmd.Parameters.Add("@TotalRows", SqlDbType.Int).Direction = ParameterDirection.Output;

    cmd.Connection = con;

    try

    {

        con.Open();

        sda.SelectCommand = cmd;

        sda.Fill(dt);

        DataList1.DataSource = dt;

        DataList1.DataBind();

        TotalRows = Convert.ToInt32(cmd.Parameters["@TotalRows"].Value);

    }

    catch (Exception ex)

    {

        Response.Write(ex.Message);

    }

    finally

    {

        con.Close();

        sda.Dispose();

        con.Dispose();

    }

    return TotalRows;

}

Private Function BindList(ByVal PageNo As Integer) As Integer

        Dim TotalRows As Integer = 0

        Dim dt As New DataTable()

        Dim strConnString As [String] = System.Configuration _

            .ConfigurationManager.ConnectionStrings("conString").ConnectionString

        Dim con As New SqlConnection(strConnString)

        Dim sda As New SqlDataAdapter()

        Dim cmd As New SqlCommand("spx_Pager")

        cmd.CommandType = CommandType.StoredProcedure

        cmd.Parameters.Add("@PageNo", SqlDbType.Int).Value = PageNo

        cmd.Parameters.Add("@ItemsPerPage", SqlDbType.Int).Value = ItemsPerPage

        cmd.Parameters.Add("@TotalRows", SqlDbType.Int).Direction = ParameterDirection.Output

        cmd.Connection = con

        Try

            con.Open()

            sda.SelectCommand = cmd

            sda.Fill(dt)

            DataList1.DataSource = dt

            DataList1.DataBind()

            TotalRows = Convert.ToInt32(cmd.Parameters("@TotalRows").Value)

        Catch ex As Exception

            Response.Write(ex.Message)

        Finally

            con.Close()

            sda.Dispose()

            con.Dispose()

        End Try

        Return TotalRows

End Function

private int CalculateTotalPages(int intTotalRows)

{

    int intPageCount = 1;

    double dblPageCount = (double)(Convert.ToDecimal(intTotalRows) / Convert.ToDecimal(this.ItemsPerPage));

    intPageCount = Convert.ToInt32(Math.Ceiling(dblPageCount));

    return intPageCount;

}

Private Function CalculateTotalPages(ByVal intTotalRows As Integer) As Integer

        Dim intPageCount As Integer = 1

        Dim dblPageCount As Double = CDbl((Convert.ToDecimal(intTotalRows) / Convert.ToDecimal(Me.ItemsPerPage)))

        intPageCount = Convert.ToInt32(Math.Ceiling(dblPageCount))

        Return intPageCount

End Function

private void Prepare_Pager(int TotalRows)

{

    int intPageCount = this.CalculateTotalPages(TotalRows);

    if (intPageCount > 1 && this.CurrentPage < intPageCount)

    {

        this.lnkNext.Enabled = true;

    }

    if (this.CurrentPage != 1)

    {

        this.lnkPrev.Enabled = true;

    }

    else

    {

        this.lnkPrev.Enabled = false;

    }

}

 Private Sub Prepare_Pager(ByVal TotalRows As Integer)

        Dim intPageCount As Integer = Me.CalculateTotalPages(TotalRows)

        If intPageCount > 1 AndAlso Me.CurrentPage < intPageCount Then

            Me.lnkNext.Enabled = True

        End If

        If Me.CurrentPage <> 1 Then

            Me.lnkPrev.Enabled = True

        Else

            Me.lnkPrev.Enabled = False

        End If

End Sub

protected void Page_Load(object sender, EventArgs e)

{

    if (ViewState["CurrentPage"] != null)

    {

        this.CurrentPage = Convert.ToInt32(ViewState["CurrentPage"]);

    }

    if (!IsPostBack)

    {

        int TotalRows =  this.BindList(1);

        this.Prepare_Pager(TotalRows);

    }

}

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

        If ViewState("CurrentPage") IsNot Nothing Then

            Me.CurrentPage = Convert.ToInt32(ViewState("CurrentPage"))

        End If

        If Not IsPostBack Then

            Dim TotalRows As Integer = Me.BindList(1)

            Me.Prepare_Pager(TotalRows)

        End If

End Sub