There are a few different
Learn how to delete records
Step-by-step tutorial on how
Many times people will make
ways to connect to an Access
with an SQL instead of a
to display uploaded binary
the mistake of naming a
database using a DSN-LESS
Recordset. Here are two
files from the database
database field with an SQL
connection. You can use the
examples. One will use a
using plain ASP pages. Every
Reserved word. This is an
Access driver, an OLEDB
query string and the other
step has been explained in
easy mistake to make. It's
provider connection, a
gets the info from a form.
detail. Downloadable source
hard to remember every
physical path or a virtual
Both examples include an
code available.
single one. Here's a concise
path. Here is an example of
example of a DSN-LESS
listing of SQL Reserved
each as well as a DSN-LESS
connection.
words to help you along.
SQL Server connection.
Date: Aug, 05 2002 Date: Aug, 05 2002 Date: Jun, 17 2002 Date: Jun, 17 2002 |
Step-by-step tutorial on how
This is the second article in
To database or not to
Complete Online Chapter
to upload files (images,
this series. This article
database? Test of consumed
"Data Access with
text, other documents, etc)
mainly deals with SQL Joins
resources (processor,
.NET" from Wrox Press
using plain ASP pages to the
and SQL sub-queries. Both of
memory) and results with
book "Professional C#
database. Every step has
these are extremely useful
file upload to database or
2nd Edition". Topics
been explained in detail.
SQL constructs and should be
file system. Test of JetOLEB
covered include
Downloadable source code
learnt by all beginners.
connection to MDB, test of
"Connecting to the
available.
MSSQL 2000 and AppendChunk
database",
method and UPDATE text SQL
"Executing
command.
Commands", "Stored
Procedures", "The
ADO.NET object model"
and "Using XML and XML
Schemas".
Date: Jun, 17 2002 Date: May, 10 2002 Date: May, 06 2002 Date: May, 06 2002 |