This paging code is easy to use, with only four steps:
(1) construct SQL query statements, set database connection strings, and set the number of records displayed on each page
(2) insert the pagination control code <B> navigator_init.inc </B> File
(3) insert the paging navigation code <B> navigator. inc </B>
(4) display records on this page cyclically
<1> ASP files to be paged
Sample. asp
<%
'Obtain the complete path of the current ASP page, an important skill
TheScript = Request. ServerVariables ("SCRIPT_NAME ")
'(1) construct an SQL statement
Myconnstr = "driver = {SQL Server}; server = yourserver; uid = sa; pwd =; database = yourdatabase"
ThePageSize = 20' number of records displayed per page
USQL = "select * from yourtablename"
'(2) insert paging control code
%>
<! -- # Include file = "../inc/control/navigator_init.inc" -->
<Html>
<Head>
<Title> test </title>
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<Link rel = "stylesheet" href = "../default.css" type = "text/css">
</Head>
<! -- Your HTML code // -->
<Table width = "100%" border = "0" cellspacing = "0" cellpadding = "0">
<Tr>
<Td>
<! -- (3) insert the paging navigation code -->
<! -- # Include file = "../inc/control/navigator. inc" -->
