/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Connecting to Database using DSN/DSN less Connections

Hits: 13
*****
0.0

ASP Data Access for Beginners

Hits: 13
*****
0.0

Display Table on Web Page

Hits: 13
*****
0.0

Filtering and Sorting of Records in a Database

Hits: 13
*****
0.0
An article on connecting to
The driving force behind
This page demonstrates the
Learn how to search and sort
database via ASP using both
Active Server technologies
capabilities how to display
the records through the
DSN and DSN less
is data access. In order to
a table from a SQL
database. Step by step
connections. Explains uses
develop a truly dynamic web
statement. It illustrates
tutorial with Sample code
of each. Learn using
site developers need to
not only how to display the
and database available for
connection strings.
allow users to access data
table, but also how to
download. Online demo also
 
on demand. Luckily, with
detect that no records were
available.
 
Microsoft's Active Server
returned from a query, and
 
 
Pages, this is exceedingly
how to detect null and blank
 
 
easy to do. This article for
values in the data.
 
 
ASP beginners details how to
 
 
 
connect to a SQL Server 7.0
 
 
 
database using ActiveX Data
 
 
 
Object (ADO) and Open
 
 
 
Database Connectivity (ODBC).
 
 


Date: Dec, 03 2000


Date: Oct, 30 2000


Date: Oct, 02 2000


Date: Jul, 10 2000
The purpose of this article
This is an introductory
Complete tutorial on editing
You all must have seen and
is to show how to get
tutorial on ASP data access.
and updating records in the
done stuff with the
records from an html form
It covers Connection Object,
database. Each and every
RecordSet object, infact
and submit that form to an
Command Object, and
step explained in detail for
everything is done with the
ASP page. This ASP page will
Recordset Object.
ASP beginners. Both
RecordSet object. Now, this
then use SQL to enter the
 
Connection and Recordset
acticle explains how to use
records into the database.
 
Objects discussed.
GetRows to page through the
 
 
 
records that you recieve
 
 
 
from the SELECT. It's much
 
 
 
faster than MoveNext,
 
 
 
because it closes the
 
 
 
database connection
 
 
 
immediately whereas MoveNext
 
 
 
loops through the records
 
 
 
with the overhead of the
 
 
 
database connection. Plus
 
 
 
GetRows let's you count the
 
 
 
records correctly!


Date: Jun, 11 2000


Date: May, 18 2000


Date: Mar, 27 2000


Date: Oct, 04 2003
{ Copyright } ©2006 NuclearScripts.com