ASP 101 - Samples

The Place ASP Developers Go!

Please visit our partners

Windows Technology

15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com

internet.commerce

Partners & Affiliates

ASP 101 is an
internet.com site

IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

ASP 101 News Flash

Script Output:

Page 2 of 3

id	last_name	first_name	sales
11	Miller	Greg	5640
12	Steel	Tammy	3570
13	Dodsworth	Nancy	2750
14	Nelson	Beth	4345
15	Hopkins	Peter	6710
16	Graham	Chris	4050
17	Thompson	Vincent	4820
18	Ostrander	Ian	3965
19	Quinn	Howard	5865
20	Smith	Fred	6370

[<< Prev] 1 2 3 [Next >>]

Ever wonder how the search engines pull off that cool trick of only showing you the first ten results that your query pulls back from their gigantic database? Well, rest assured that you're not alone. It's been a popular request here at ASP 101, and as far as we can tell, everywhere else as well.

We did some research and there are a couple of ways to accomplish this particular trick. Since we're doing this for the web, one thing we decided was that we didn't want to leave any DB objects hanging around. This decision might hurt performance if you're going to be doing a lot of paging back and forth, but for us, it seemed to be worth the performace hit to not have the memory usage from unused DB objects lingering around in users' session objects.

If you're wondering, the reason we set the page size so small is because our sample DB is tiny and we figured a single page paging sample wouldn't illustrate the concept too well! The other thing to notice is that, besides the include at the top, this was all done in script. No context switching at all. I don't know if I like it or not, but I never felt the need to drop out to HTML and heck it's something else for you to notice!

The final thing I'd like you to notice is something everyone seems to compliain about! Take a look at our HTML source on this one. By my standards, the table's flawless! Everyone always complains that either their ASP code looks ugly or the reslting HTML output does. We really can't allow either one since our code is on public display. I'm showing you that you can get both to be presentable with a little work and some careful placement of vbCrLf's and vbTab's!

Once again, this is the same DB as our original Database sample. If for some reason you want a copy of the DB you can download it here.

Take a look through the code. There are some comments, but you'll find the level of sarcasm is lower than usual. Code, comments, and that's all folks!

Alternate Version Using an Array

One of our users has contributed a version of the script that copies the data to an array before implementing the paging.

Hi,

I reworked your database paging script to build an array and then close the connection. This keeps your paging model and reduces the time the SQL connection is open.

To be honest I'm not sure it'll be any faster (especially with larger data sets) but I figured I'd go ahead and post it for those of you who are interested. If anyone wants to speed test them I'll be happy to post the results... I just don't really have the time at the moment.

Anyway... you can download the code from here (1.5 KB).

The Network for Technology Professionals

About Internet.com

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

Solutions

Whitepapers and eBooks

IBM eBook: Getting Started with Adobe Flex
Development Teams Rejoice: IBM Rational Team Concert 3.0 is almost here!
IBM Resources: Get up to speed with IBM WebSphere cloud and virtualization technologies
Let Your Sites Shine: Web Content Can Now Come Forward
PDF: Bridge the Gap Between Development and Operations for Portal and Web Security
PHP for Windows Showcase
PDF: Economics of Computing - The Internal Combustion Mainframe
Resource: PHP for Windows Showcase

Whitepaper: Five Ways to Fast ROI with Business Rule Management Systems
IBM Cloud Computing Development Center
PDF: IBM Lotus Notes and Lotus Domino Software
Helpful Cloud Computing Resources
PDF: Dispelling the Vapor Around Cloud Computing
Research Brief: How Forward-Thinking Marketing Organizations Deliver Competitive Differentiators
Whitepaper: Accelerate ROI for BPM with Rapid Deployment
MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts

LIVE IBM Event: Managing Application Development in the Cloud--Thursday December 16 at 11am EDT
IBM Webcast: Accelerate Software Delivery with Social Software
IBM Cloud Computing for Developers Virtual Events
Spend Less Time Rewriting Your Sites to Work Across Browsers

Webcast: Information & Analytics: The Secret Weapon of Top-Performing Companies
Software License Operations - Cleaning Up the Backoffice
All About Cloud Computing
MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits

IBM Rational Doors Mini Skills Kit
Download: IBM DB2 Express-C
Evaluate: IBM DB2 for Linux, UNIX, and Windows
Download: The Microsoft Web Platform Installer

New: Internet Explorer 9 Beta -- Download Now!
IBM System x and BladeCenter Virtualization Kit
MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos

Intel AppUp Developer Program: New Name, New SDK, New Identifier, and More! Join Now!
Build a More Competitive Business with Technology � Product & Service Innovation

Internet.com Hot List: Get the Inside Scoop on IT and Developer Products
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES