Hi all, I'm using ASP.NET (VB) and the "Repeater" to show results from database (MS ACCESS) .. I want to know how can I make it to show only the first or top 10 results in my database ... (Such as in classic asp i can use RecordsPerPage function to set this).

This is the sub where I check if there was results (show them) or if not (redirect):

Code:
Sub CheckHasRows(ByVal dbread)
	If dbread.hasrows Then
		Table.datasource = dbread
		Table.databind()
		dbread.close
	Else
		Response.Redirect("/INDEX.aspx")
	
	End If
End Sub