/**
popular collection of scripts for all
*/
/** Search */
{
Database-related
}|
The driving force behind
When faced with learning a
The author writes
This article provides sample
Active Server technologies
new technology, it's common
"CoverYourASP's
source code for a user query
is data access. In order to
to try and reproduce the
original database
parser which allows users to
develop a truly dynamic web
basic functionality you're
administration tool didn't
submit full-text search
site developers need to
used to in the old one. In
look for foreign keys, and
queries from ASP to SQL
allow users to access data
doing that with ADO.NET and
just displayed a confusing
Server 2000. Full source
on demand. Luckily, with
trying to reproduce the
list of primary key values.
code available for download.
Microsoft's Active Server
basics or the recordset
Now, it's been improved with
Pages, this is exceedingly
object, this article
automatically generated list
easy to do. This article for
discusses the new and many
boxes." This tutorial
ASP beginners details how to
uses of ADO.NET's DataView
explains how to turn those
connect to a SQL Server 7.0
object.
foreign keys into list boxes
database using ActiveX Data
automatically.
Object (ADO) and Open
Database Connectivity (ODBC).
Date: Oct, 30 2000 Date: Aug, 27 2003 Date: May, 23 2001 Date: Apr, 24 2001 |
|
It is somewhat ironic that
This article presents three
This 4-page tutorial shows
AddCriteria is a small
the most confusing part of
modular routines to access
all the basics of using
function that simplifies the
creating and executing a SQL
and fetch data easier with
Active Server Pages and
code needed to produce a SQL
statement from ASP is
ASP. Topics include:
VBScript to work with
query from a set of optional
determining where to put the
Fetching a Recordset, An
databases. It covers
criteria posted by a user.
quotes. When is a single
alternative to the
Connecting to the Database,
This article explains how to
quote used? When is a double
GetConnectedRecordSet
Working With Recordsets, and
use this function.
quote used? When are they
function that opens a
more.
used together? Which takes
connection, fetches a
precedence? This article
recordset, and immediately
will answer these questions.
closes the connection, and
Utilities for Creating Valid
SQL Statements.
Date: Feb, 27 2001 Date: May, 16 2001 Date: Nov, 30 2000 Date: Jun, 29 2001 |
{ Copyright } ©2019 NuclearScripts.com