asp paging db records - ASP / Active Server Pages

najmi

46 New Member

hai..how to do simple page paging using ms acess..anyone can help me

Nov 17 '07 #1

Subscribe Reply

1241

CroCrew

564

Recognized Expert Contributor

Hope this helps~

Expand|Select|Wrap|Line Numbers

 
<%

    Set Conn = Server.CreateObject("ADODB.Connection") 

    Conn.Open("dsn=xxx;uid=xxx;pwd=xxx;") ' The conection to your database.
 
    Set rsData = Server.CreateObject("ADODB.Recordset") 
 
    SQL = "SELECT * FROM YourTable"
 
    rsData.CursorLocation = 3

    rsData.Open SQL, Conn 

    rsData.PageSize = 10 ' Show this number of records per page.

    intPageCount = rsData.PageCount
 
    SELECT CASE Request("xAction")

        CASE "Beginning"

            intpage = 1

        CASE "Previous"

            intpage = Request("intpage") - 1

            IF intpage < 1 THEN intpage = 1

        CASE "Next"

            intpage = Request("intpage") + 1

            IF intpage > intPageCount THEN intpage = IntPageCount

        CASE "End"

            intpage = intPageCount

        CASE ELSE

            intpage = 1

    END SELECT 

%>

<html> 

    <head>

        <title>Example 02</title>

        <SCRIPT LANGUAGE="JavaScript">

            function MoveTopage(xAction)

            {

                document.xform.xAction.value=xAction;

                document.xform.submit();

            }

        </SCRIPT>

    </head>

    <body>

        <%rsData.AbsolutePage = intPage%>

        <%For intRecord = 1 To rsData.PageSize%>

            <tr><td><%response.write(rsData("FieldWithinYourTable"))%></td></tr>

            <%response.flush%>

            <%rsData.MoveNext%>

            <%If rsData.EOF Then Exit For%>

        <%Next%>

        <tr>

            <td align="center">

                <input type="button" value=" &lt;&lt; " onclick="MoveTopage('Beginning');">

                <input type="button" value=" &lt; " onclick="MoveTopage('Previous');">

                <input type="button" value=" &gt; " onclick="MoveTopage('Next');">

                <input type="button" value=" &gt;&gt; " onclick="MoveTopage('End');">

                <br>Page: <%response.write(Intpage & " of " & intpagecount)%>

            </td>

        </tr>

        <form name="xform" id="xform">

            <input type="hidden" name="xAction" value="">

        </form>

    </body>

Jan 24 '08 #2

Similar topics

3822

Paging in ASP BEST APPROACH

by: Navin | last post by:

HI, Guys There has been a lot of Ways to use paging in asp 1>Recordset approach -where whole records are pulled at client side... and then only the records which are needed are filtered.. and...

ASP / Active Server Pages

1716

ASP paging problem

by: david | last post by:

Hi I have written code in ASP for paging records from the database (SQL Server 2000). The real problem I have around 10,000 records and it tries to fetch all the records everytime (I'm saying...

ASP / Active Server Pages

1801

DataGrid paging - a question of efficiency

by: Shawn | last post by:

Hi. I already have a datagrid where I'm using paging. I have a stored procedure that fills a temp table with 200-500 rows and then sends back 10 records at the time. When I go to page 2 the SP...

ASP.NET

2211

Custom Paging in ASP.NET

by: asad | last post by:

Hello friends, i am designing a ASP.NET page where i want to use custom paging bcoz data is too heavy so pls tell me how can i use custom paging in ASP.NET Thanks

ASP.NET

2121

Gridview and effective paging

by: nyhetsgrupper | last post by:

Hi everyone, In a datagrid the entire data is read but only the page you want is displayed to the user when you enable paging. Does the Gridview control works in the same way? So if you have...

ASP.NET

4136

Paging records on SQL server using derived tables

by: rbg | last post by:

I am using derived tables to Page data on the SQL Server side. I used this link as my mentor for doing paging on the SQL Serverhttp://msdn2.microsoft.com/en-us/library/ms979197.aspx I wanted to...

Microsoft SQL Server

2789

Paging records on SQL server using derived tables : more question

by: rbg | last post by:

I did use query plans to find out more. ( Please see the thread BELOW) I have a question on this, if someone can help me with that it will be great. In my SQL query that selects data from table,...

Microsoft SQL Server

1914

2 DataGrids & Paging

by: rn5a | last post by:

In a shopping cart app, a ASPX page retrieves the order details & personal details of a user from a MS-Access database table depending upon the username of the user. The order details of a...

ASP.NET

3731

Does GridView paging feature limit number of records coming back from database?

by: Ronald S. Cook | last post by:

I was told that if calling lots of records from the database (let's say 100,000), that the GridView's paging feature would automatically "handle" everything. But the 100,000 records are still...

ASP.NET

1440

How to use SQL Server paging

by: Donald Adams | last post by:

I heard in an online video by Scott Gu, that there is an option to have the asp.net datagrid in .net 2.0 do the paging in SQL Server 2005 rather than pull all the data from the database and do it...

ASP.NET

7205

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

7093

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7011

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5596

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5023

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

4689

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

3180

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

1521

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

747

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