Dreamweaver CS5 provides for displaying data pulled from database using asp and has a recordset navigation bar for accessing different pages of the recordset.
However, i want to use the pagination without having to refresh the page on which the navigation bar is being shown. I want to use ajax in such a way that when we click the navigation links of recordset navigation bar it displays the corresponding page from the database without refreshing the page
However, i dont want to use xml file as a database. Instead the asp page is to directly access the SQL database and send the results for display.
It is very easy to convert your queries to XML, have a look here http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html.
Please take a look at the following implementations of AJAX with ASP. These codes probably indicate that it is possible to use ASP with Ajax.
It is only that the pagination style is different in the case of DW recordset navigation bar but suggest that it is possible.
Alternative pagination styles using jquery (but not asp) is available at
In view of the above, please advise on now to use DW recordset navigation bar and ajax so as to avoid page refresh when seeking more records.