/**

popular collection of scripts for all

*/
/** Search */

Database-related

 }

Working with ASP & MS Access

Hits: 310
*****
0.0

Connecting to your SQL Database

Hits: 295
*****
0.0
This is a nice simple
This is a set of ASP
Complete Online Chapter
If you have an SQL database
tutorial on how to
examples/tutorials that
"Data Access with
set up with your web host, a
manipluate a MS Access
demonstrate exactly how to
.NET" from Wrox Press
useful tip to know is how to
database using ASP. It will
use ASP with a database.
book "Professional C#
connect to your SQL database
teach you how to add, remove
Topics include: Using ADO To
2nd Edition". Topics
via Enterprise Manager. The
and modify data from an
Add A New Record, Using ADO
covered include
advantage of knowing how to
Access database as well as
To Update An Existing
"Connecting to the
do this is that you will be
connecting and disconnecting
Record, Using An Update
database",
able to manage your SQL
to the database in ASP.
Query To Modify An Existing
"Executing
Server database via
 
Record, Using Delete
Commands", "Stored
Enterprise Manager over
 
Statement to Delete Records,
Procedures", "The
TCP/IP, yourself.
 
Using A Select Statement
ADO.NET object model"
 
 
(With A Loop), and ACCESS
and "Using XML and XML
 
 
DATABASES ( DSN vs DSN-LESS).
Schemas".
 


Date: Mar, 12 2000


Date: Feb, 14 2000


Date: May, 06 2002


Date: Mar, 08 2002
This example shows how to get
It is possible to store
This article discusses two
This article will show you
a list of all current tables
images in a database using a
different ways to
two different methods that
in the database, get a list
number of third party tools
dynamically generate
you can use to connect to a
of dependent stored
or a custom built component.
data-entry forms: Use the
Microsoft SQL Server 2000
procedures for each table
Once you have the images
ADO OpenSchema Method, and
database: System DSN's and
and do it all in a stored
stored in your database,
Query Your SQL Server System
the OLEDB connection string.
procedure.
however, displaying them
Tables. Describes advantages
It will also explain the
 
requires the use of a simple
and disadvantages of each
positives and negatives of
 
ASP page. This tutorial
method.
each method, along with some
 
explains how to retrieve
 
examples to get you started.
 
images from a database table
 
 
 
and use them in an HTML page.
 
 


Date: Jul, 19 2001


Date: Jan, 11 2001


Date: Dec, 18 2000


Date: Jan, 16 2002
{ Copyright } ©2019 NuclearScripts.com