Multiple level select boxes
The author writes
Complete Online Chapter
Active Server Pages allow us
tackled with hierarchical
"Recently I was asked
"Data Access with
an easy means of querying
data! This sample
to develop a web based
.NET" from Wrox Press
and updating a database from
illustrates the concept
report that would collect
book "Professional C#
a webpage. This article
using a hierarchy consisting
data from a database, format
2nd Edition". Topics
describes the basics of
of geographical region,
it in an HTML page and then
covered include
using this technique in a
country, and state data. The
print a certain number of
"Connecting to the
nutshell. The examples given
code expects a system DSN by
rows on each page with a
database",
here utilize a Microsoft
name "Hierarchy"
column header on each page.
"Executing
Access database, but the
and accesses the database
This solution solves the
Commands", "Stored
principles elucidated apply
using the user id
problem." Source code
Procedures", "The
equally well to ASP
"sa" with a blank
available for download.
ADO.NET object model"
integration with other
password. The database is
and "Using XML and XML
databaes.
created in SQL Server 7.0.
Schemas".
Date: Jun, 13 2000 Date: Jul, 20 2001 Date: May, 06 2002 Date: Jan, 25 2000 |
You fill in the blanks, and
This article describes
This article wraps up the
The part one of this two-part
you are given the source
several ways to use a SQL
details of the real time
article shows how to create
code for the form, and a
calculated field and the
data grid that started in
an ASP class that allows us
page to display the
ORDER BY clause to arrange a
part one of this two-part
to work with our databases
information in the database.
recordset in random order.
article. It looks at the
through a web browser. It
Also the database is ready
It provides a simple tool
JavaScript code that
will allow us to update and
to download with all fields
for verifying that the
contacts our database server
delete records dynamically
in your form.
results are uniformly
and allows us to update data
using JavaScript and
random. Also shows a
in a database without
XMLHTTP, without ever having
technique for bubbling
actually refreshing the page.
to refresh the page.
records with certain
attributes to the top of an
otherwise randomized list.
Date: Apr, 15 2002 Date: Sep, 13 2001 Date: Feb, 14 2002 Date: Feb, 06 2002 |