Code:
<% @Language="JavaScript" %>
<html>
<head><title> User Register Details</title>
<script language="JavaScript" type="text/JavaScript">
function load()
{
var co =document.getElementById('coname');
var so=document.getElementById('sorder');
var cur=document.getElementById('curpage');
var dir=document.getElementById('direction');
var wsql=document.getElementById('whsql');
co.value="";
so.value="Asc";
cur.value=1;
dir.value="";
wsql.value=""
}
function next()
{
var co =document.getElementById('coname');
var so=document.getElementById('sorder');
var cur=document.getElementById('curpage');
var dir=document.getElementById('direction');
var wsql=document.getElementById('whsql');
co.value="FirstName";
so.value="Asc";
cur.value=1;
dir.value="Next";
wsql.value=""
}
</script>
</head>
<body>
<div>
<form action="demo.asp" onload="javascript:load();" method ="Post" >
<input type="hidden" id= "coname" name="colname" value= " " Size="20" maxlength="10" runat="server" />
<input type="hidden" id= "sorder" name="sorder" value= " " Size="20" maxlength="10" runat="server" />
<input type="hidden" id= "curpage" name="curpage" value= " " Size="20" maxlength="10" runat="server" />
<input type="hidden" id= "direction" name="direction" value= " " Size="20" maxlength="10" runat="server" />
<input type="hidden" id= "whsql" name="whsql" value= " " Size="20" maxlength="10" runat="server" />
<input type="image" id="First" name="First" src="First1.gif" runat="server" />
<input type="image" id="Previous" name="Previous" src="previous1.gif" runat="server" />
<input type="image" id="next" name="next" src="next1.gif" onclick="javascript:next();" runat="server" />
<input type="image" id="Last" name="Last" src="Last1.gif" runat="server" />
<%
var Connection = new ActiveXObject("ADODB.Connection");
var Recordset = new ActiveXObject("ADODB.Recordset");
var Ls_SQL;
var NumPerPage = 4;
var strConn ="DSN=a;UID=sa;PWD=SageCRM72;Database=RegisterDB";
Connection.Open(strConn);
Ls_SQL = "SELECT FirstName,LastName,UserName,Password,EmailId,PhoneNo,Address1,Address2,Country,State,City FROM Register order by FirstName asc"
Recordset.Open(Ls_SQL,Connection);
%>
<table width=100% align=center border=1>
<tr>
<td align=center><a href="demo.asp">FirstName</a></td>
<td align=center><a href="demo.asp">LastName</a></td>
<td align=center><a href="demo.asp">UserName</a></td>
<td align=center><a href="demo.asp">Password</a></td>
<td align=center><a href="demo.asp">EmailId</a></td>
<td align=center><a href="demo.asp">PhoneNo</a></td>
<td align=center><a href="demo.asp">Address1</a></td>
<td align=center><a href="demo.asp">Address2</a></td>
<td align=center><a href="demo.asp">Country</a></td>
<td align=center><a href="demo.asp">State</a></td>
<td align=center><a href="demo.asp">City</a></td>
</tr>
<tr>
<%while(!Recordset.EOF)
{
%>
<td>
<%
Response.Write(Recordset.Fields("FirstName"));
%>
</td>
<td>
<%
Response.Write(Recordset.Fields("LastName")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("UserName")); %>
</td>
<td>
<%
Response.Write(Recordset.Fields("Password")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("EmailId")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("PhoneNo")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("Address1")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("Address2")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("Country")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("State")); %>
</td>
<td>
<%Response.Write(Recordset.Fields("City")); %>
</td></tr>
<%
Recordset.MoveNext ;
}
%>
<%
Recordset.Close();
Connection.Close();
%>
</table>
</form>
</div>
</body>
</html>