How we can display only 5 rows in a Repeater control.

check this blog
http://www.aspnettutorials.com/tutorials/controls/pageddatasource-vb.aspx[^]
--NDK

As your Question First you will have to Bind Repeater with PageSize 5

Dim dt As DataTable = BL.BindRepeater()
    Dim objPds As New PagedDataSource()
    Repeater.DataSource = dt.DefaultView
    Repeater.AllowPaging = True
    objPds.PageSize = 5
    Repeater.DataSource = objPds
    Repeater.DataBind()

And when you Link More Show then Display 5 Record

1) First you use Stored Procedure this:

Select RowsDisplay.* from (Select
      ROW_NUMBER() over (order by A.projectID desc) as RowNumber, A.*
    from
(select *
 from TableName(Plz Write TableName Here)
where UserName =XYZ;
) as A

) as RowsDisplay
where
RowsDisplay.RowNumber> 5

2)User Bind Repeater On click

Dim dt As DataTable = BL.MoreShow()
Dim objPds As New PagedDataSource()
objPds.DataSource = dt.DefaultView
objPds.AllowPaging = True<pre lang="vb">

objPds.PageSize = 5
Repeater.DataSource = objPds
Repeater.DataBind

I have Used and work fine. if any problem come then write code here.