This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.
Version: n/a Platform(s): n/a Updated: Mon Dec 18 2000
This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
Version: n/a Platform(s): ASP 2.0 Updated: Sat Dec 16 2000
This 4-page tutorial shows all the basics of using Active Server Pages and VBScript to work with databases. It covers Connecting to the Database, Working With Recordsets, and more.
Version: n/a Platform(s): n/a Updated: Thu Nov 30 2000
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).
Version: n/a Platform(s): n/a Updated: Mon Oct 30 2000
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records
were returned from a query, and how to detect null and blank values in the data.
Version: n/a Platform(s): n/a Updated: Mon Oct 2 2000
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.
Version: n/a Platform(s): n/a Updated: Wed Oct 4 2000
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.
Version: n/a Platform(s): n/a Updated: Wed Aug 30 2000
This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.
Version: n/a Platform(s): n/a Updated: Wed Aug 30 2000
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.
Version: n/a Platform(s): n/a Updated: Mon Aug 28 2000
This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.
Version: n/a Platform(s): n/a Updated: Sun Aug 27 2000
This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.
Version: n/a Platform(s): n/a Updated: Sun Aug 13 2000
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.
Version: n/a Platform(s): n/a Updated: Sat Aug 12 2000
Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.
Version: n/a Platform(s): n/a Updated: Sun Aug 6 2000
This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.
Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.
In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.
