The first example is a plain vanilla asp page that incorporates paging. The query is issued through a stored procedure using the command object of ADO. Download files here.

The second example uses GetRows. GetRows is a method in ADO that will stuff the recordset into an array and allow you to iterate your results set. This method offers better performance. Download files here.

The third method demonstrates hit highlighting. This method uses the hit highlighting features of Indexing Services. A copy of the contents of your main text/char field must be stored in the file system. Download files here.

The fourth method uses aspx. Download files here.