ASP Database Grid Implemented as a Windows Scripting Host Component

Category:
ASP, HTML and XML
Type:
Controls
Difficulty:
Intermediate
Author:
Alastair Vance

Version Compatibility: ASP, Visual Basic Script

More information:
Introduction

The ASP Grid Component is a Windows Script Component that can be executed from an ASP page.

Features:

  • Generates a HTML paged result set (grid) based on any valid SQL statement to any valid ODBC database.
  • Searches a specific field for a user defined string and returns the results in a paged format.
  • Return fields can be specified.
  • Supports both AND and OR searches.
  • Grid formatting options are available, such as colour and font size.
IMPORTANT NOTE: You must read the included readme file carefully to get this component to work properly. There is an included sample .asp file that uses it, but even this requires you to set up a DSN with a database that contains certain tables and fields. For your convenience, FreeVBCode.com had added such a database, but you still must add a DSN called TestDSN pointing to it in order for the page to work.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

Download aspgrid.zip