Most Popular Scripts | ASP | Tutorials & Tips

Here, you'll find a few example codes that allows you to save thousands of unnecessary database queries using Application variables.

This is a sample chapter from Wrox Press book 'Professional Windows DNA.' It prvides info on building web applications with VB, COM+, MSMQ, SOAP and ASP.

This tutorial, along with full source code, explains how to store such statistics as the page being viewed, the referring page, the readers IP address, browser and screen width for your site visitors.

The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).

This is a brief introduction to Active Server Pages (ASP). It discusses What are Active Server Pages, What Do I Need To Use ASP Pages, and So What Can I Do With It When I've Got It.

This tutorial will show you how to give your forms a little bit more power. By making your forms self-referencing, you can open up whole new areas of functionality with your web applications.

This sample will demonstrate how to quickly build a simple Yahoo! style navigation bar that displays the paths a user has taken to get to a given directory, and also displays a table of links to the sub-directories of the current directory. Full source code available for download.

This article explains why you shouldn't be sprinking <% %> render blocks throughout your HTML code. It's inefficient for the server and for your users!

Web pages usually print pretty lousy. Typically, background colors are not displayed (unless you change the browser settings) and depending on site the width may be set much wider than the printer can handle on the horizontal for an 8 � page. Providing a printer friendly format adds immeasurable value for your users. This example demonstrates how to strategically place a couple of simple tautologies that will display banners and other items in the typical or �default� view and allows a link back to the same page with a querystring value that will be used to suppress everything but the db output.

Building an upload file mechanism on a Web server can often require using a costly DLL. Tiago Halm's article shows you how to upload a file using only Active Server Page (ASP) code and Internet Explorer. Sample code is provided.

The browser can do a great many things, but it has a limit of 216 colors that can �safely� (without dithering or color washout) display. Fortunately, there are many ways that you can display all the color combinations in the browser safe color palette. By placing the six possible values for color (00,33,66,99,CC,FF) in an array and nesting three for next statements with values one through six a table with all the color codes will neatly be displayed in a table.

Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammerin� Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.

The checkbox object is coded along the same lines as radio buttons, however each checkbox must get its own unique name since the state of "checked" or "not checked" will be passed to ASP for each box. Remember that you can set more than one option to be checked. Complete source code provided for the example.

You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!

Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.

This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.

This is a couple of simple ASP scripts demonstrating how to rotate banners in random order. It makes use of JavaScript's Math.random() function.

This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.

ASP pages are executed on the fly by a server when they are requested by a visitor. Because they are not compiled, ASP scripts are slow and hold up the processing of an html page. This results in people leaving your site and severely reduces the enjoyment that your asp apps can provide. This short tutorial provides a few tips to increase the execution speed of your asp programs.

This 9-page tutorial shows you how to add discussion forums to your web-site. With support for an unlimited number of forums and messages and easy administration learn how you can add discussion forums to your site.