/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

MS Access: Tables, Views and Procedures

Hits: 21
*****
0.0

ASP and DBF database file connection

Hits: 21
*****
0.0

Professional C# 2nd Edition : Data Access with .NET.

Hits: 21
*****
0.0

Accessing Database from ASP

Hits: 21
*****
5.0
Ever wondered how to create a
Create a connection to DBF
Complete Online Chapter
This tutorial shows you
table, view or procedure
files using JetOLEDB
"Data Access with
step-by-step how to
with MS Access? This article
provider (DSN-less,
.NET" from Wrox Press
incorporate MS Access
shows us how to create all
ODBC-less connection), basic
book "Professional C#
databases into your web site
three and work with them
work with DBF files (select,
2nd Edition". Topics
using ASP.
from an ASP script.
insert, update), other ISAM
covered include
 
 
formats + FOXPRO option,
"Connecting to the
 
 
real sample code, create a
database",
 
 
new DBF file.
"Executing
 
 
 
Commands", "Stored
 
 
 
Procedures", "The
 
 
 
ADO.NET object model"
 
 
 
and "Using XML and XML
 
 
 
Schemas".
 


Date: Aug, 27 2003


Date: Jun, 18 2003


Date: May, 06 2002


Date: Mar, 15 2000
Learn how to delete records
This is a nice simple
SQL, Structured Query
You can use transactions in
with an SQL instead of a
tutorial on how to
Language, is the most
ASP as a kind of insurance
Recordset. Here are two
manipluate a MS Access
powerful tool to connect to
policy for your database
examples. One will use a
database using ASP. It will
a database regardless of the
activities, making them
query string and the other
teach you how to add, remove
form of the database.
safer and providing better
gets the info from a form.
and modify data from an
However, building a perfect
error recovery. Transactions
Both examples include an
Access database as well as
SQL statement can be very
are most useful when doing
example of a DSN-LESS
connecting and disconnecting
frustrating. Especially
multiple actions on multiple
connection.
to the database in ASP.
debugging -- the error
tables. The example below
 
 
message simply didn't tell
shows just how easy it is to
 
 
you where the error is. This
use transactions from ASP,
 
 
tutorial provides a nice
inserting a record into a
 
 
summary of SQL statements.
table and doing a
 
 
 
"rollback" if
 
 
 
there's a problem.


Date: Aug, 05 2002


Date: Mar, 12 2000


Date: Feb, 15 2000


Date: Jan, 08 2007
{ Copyright } ©2006 NuclearScripts.com