how to code for paging using server side java script with classic asp

2 New Member

Expand|Select|Wrap|Line Numbers

 
<% @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>

Jan 22 '14 #1

Subscribe Reply

1431

Similar topics

3182

.NET Web Forms (Postbacks) VS. Clent Side Java Script.

by: Jim Mitchell | last post by:

OK, have I come full circle.... ? 1) .NET with VS Studio seemed to be the answer to all my prayers. A) No more worries about coding for Netscape vs. IE. B) Quick Deployment C) All code in...

.NET Framework

1567

referencing .NET framework namespaces in client side java script

by: Rea Peleg | last post by:

Hello I'd like to use .NET framework namespaces in client side java script. For example i'd like to import System.Activator, in order to call Activator.CreateInstance() method inside a client side...

.NET Framework

1599

how client-side presentation code interact with server-side processing code?

by: jrefactors | last post by:

how client-side presentation code interact with server-side filter/sort processing code? I have a html table that has sorting and filter capabilities. The sorting and filter features are done...

Javascript

1937

aspx web form controls and client side java script

by: Rea Peleg | last post by:

Hi all Is it possible to handle web controls events on client side??? I wrote a simple favascript function inside the <header> area of an aspx web form. This function is called on...

ASP.NET

2365

HOWTO Post to a URL from Server Side ASP script.

by: ATS | last post by:

HOWTO Post to a URL from Server Side ASP script. Please help, I'm trying to make a simple ASP page post to a URL on a seperate web site, and then get the returned HTML into a string which on...

ASP / Active Server Pages

1311

Can I use C# Code in SQL Server Integration Services -Script Component Manager

by: johnlim20088 | last post by:

Anyone can help me? Can I use C# Code in SQL Server Integration Services -Script Component Manager

Microsoft SQL Server

13098

Client Side Vs Server Side Java Script

by: Ankur | last post by:

Hi Folks, I am new for this group. I want to clarify one thing what's a basic difference between Client Side Java Script and Server Side Java Script. how we can differentiate it. Why we called...

Javascript

2364

upload image using asp and java script without refreshing the page

by: pdesai007 | last post by:

hello, i tried to upload an image in to server with asp and java script ( using AJAX) but it gave an error. so please give me any solution that help me to upload an image to server with java...

Javascript

987

Change the order of display from a,b to b,a in server side java script code

by: ubohra | last post by:

Hii all I am getting stuck into some development issue!! We are using some application which provides support to our clients,the user comes and take some courses for them. The problem is...

Javascript

7125

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7208

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7379

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4915

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4593

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3095

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3085

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

657

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

292

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General