ASP 101 - Active Server Pages 101 - Web03
The Place ASP Developers Go!

Windows Technology Windows Technology
15 Seconds
ASP 101
ASP Wire
VB Forums
VB Wire
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an site
ASP 101 is an site
Internet News
Small Business
Personal Technology

Corporate Info
Tech Jobs
E-mail Offers

ASP 101 News Flash ASP 101 News Flash

Script Output:
1214152 Thursday 24 3/24/2011 4:14:27 PM
1214153 Thursday 24 3/24/2011 5:51:20 PM
1214154 Thursday 24 3/24/2011 5:51:35 PM

ASP HTML Download            FAQ

This sample is part of a pair which illustrate the usage of two of the more efficient database display routines. This set of code utilizes the GetRows method. The other one is covered in our GetString Sample.

Both of these routines get their efficiency primarily from getting you disconnected from the database as quickly as possible. This one does it by creating a copy of the data in a 2D array. Once you have the array you can close all your ADO objects and manipulate and display the data at your leisure.

Similar efficiencies can be gained in traditional code by disconnecting your recordsets as early as possible, but very few people ever actually do this. These recordset methods facilitate getting you out of your objects and getting them released ASAP. That being said, the components are also simply more efficient then doing the same thing in VBScript, so they'll even beat a disconnected recordset, but I figured I'd mention it for those situations when GetRows or GetString is just too cumbersome to use. For the rest of the time use one of these... they're just as easy (if not easier) and they'll save your server a lot of unneccesary work.

As always... don't let the length of the code discourage you... it's mostly comments!


Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback
The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers