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
Speedup Database Access using GetRows
2614
Speedup Database Access using GetRows
http://www.stardeveloper.com/asp_getrows_1.asp
In the tutorials so far we have learned from connecting to the database via ASP to inerting, updating and selecting data from the database.
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point : ASP > Tips and Tutorials > Database-related Oct 10, 2006
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point : ASP > Tips and Tutorials > Database-related Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Speedup Database Access using GetRows: |
|||
Other links at ASP > Tips and Tutorials > Database-related
You can test the demo for dynamically dependent dropdown lists here:
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
Category:
This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.
Category:
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
Let's see what's going on a fresh example
Let's see what's going on a fresh example
Category:
In this article we will learn how to use ASP pages to page through recordsets.
Category:
The following ASP code will allow you to Count and Display the amount of visitors that are currently on or viewing your website.
Category:
Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
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: 20048
Categories: 1275
Registered Users: 789
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234592
Pagerank Statistics
PHP News