An article on connecting to
Multiple level select boxes
This is a quick sample code
The author writes
database via ASP using both
tackled with hierarchical
which combines a number of
"Recently I was asked
DSN and DSN less
data! This sample
database functions into one
to develop a web based
connections. Explains uses
illustrates the concept
script. Includes functions
report that would collect
of each. Learn using
using a hierarchy consisting
to add, delete, and edit
data from a database, format
connection strings.
of geographical region,
records in a database table.
it in an HTML page and then
country, and state data. The
It illustrates a number of
print a certain number of
code expects a system DSN by
useful techniques for
rows on each page with a
name "Hierarchy"
database manipulation.
column header on each page.
and accesses the database
This solution solves the
using the user id
problem." Source code
"sa" with a blank
available for download.
password. The database is
created in SQL Server 7.0.
Date: Dec, 03 2000 Date: Jun, 13 2000 Date: Jun, 12 2001 Date: Jul, 20 2001 |
This hands-on tutorial
This article covers two
Learn how to add records with
Want to add value to your
explains how to develop a
advanced ADO topics:
an SQL statement instead of
current search? Allow your
simple SQL-driven web site
creating hierarchical
a Recordset. Here are two
users to search from within
in just minutes. Topics
Recordsets (via data
examples. One will use a
search results. As databases
include: Our Database
shaping) and creating custom
query string and the other
grow the necessity for the
Design, Creating a Data
Recordsets. Specifically,
gets the info from a form.
user to continually narrow a
Source, Inserting A Tip Into
this article looks at how to
Both examples include an
search to the item that they
Our Database, Displaying and
create custom hierarchical
example of a DSN-LESS
truly want will grow also.
Deleting Tips, Searching the
Recordsets. The reader is
connection.
The following example
Database, and Displaying the
required to have a fluid
utilizes a db on U.S. State
Tips.
understanding of both data
capitals. Upon the first
shaping and custom
search two radio buttons
Recordsets.
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.
Date: Aug, 30 2000 Date: Jun, 05 2001 Date: Aug, 05 2002 Date: Aug, 12 2000 |