When you fetch the data from database, you may get hundreds or even thousands of rows. Showing all of those rows in a single page is not a good idea. You should definitely split that records into multipal pages. That is called pagination. Normally, developers use the sever side language such as VB.NET, C#, PHP to generate it. However, different developer use different styles of pagination with different languages. T-SQL can also be used to draw paging control. This is the SQL Server User-Defined Function to generate it.