NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Using ASP pages to page through Recordsets
2620
Using ASP pages to page through Recordsets
http://www.stardeveloper.com/asp_paging_1.asp
In this article we will learn how to use ASP pages to page through recordsets.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Using ASP pages to page through Recordsets: |
|||
Other links at ASP > Tips and Tutorials > Database-related
ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.
Category:
Building an SQL string from optionally posted criteria is tricky. You need to check if the user posted a value since only then is the criteria included in the query. Numeric entries are different from character entries and multiple-selection fields require additional processing to produce a valid SQL query. Fields that might contain single quotes need special attention to prevent syntax errors.
Category:
Displaying an Access or SQL Server database is as easy as entering the variable names and the name of the table into the fields below. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code. (Note: G.I.G.O Garbage In Garbage Out applies here, be certain all table elements entered appear in your db. Table elements must be entered in the select field * will not work here.)
Category:
This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
Category:
Learn how to import the contents of a text file (.txt) when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects for this lesson!
For the purposes of this article we will be using a text file delimited using the "|" symbol. Here is the contents of the text file we will be using - info.txt.
For the purposes of this article we will be using a text file delimited using the "|" symbol. Here is the contents of the text file we will be using - info.txt.
Category:
Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19870
Categories: 1275
Registered Users: 761
Mailing List Subscribers: 2047
Unique Outgoing Hits: 230546
Pagerank Statistics
PHP News