/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Faster Singleton Queries with ADO

Hits: 984
*****
0.0

Uploading and inserting files (binary data) to the database

Hits: 984
*****
4.5

ASP Access Database Tutorials

Hits: 966
*****
0.0

Search db by Field

Hits: 962
*****
0.0
It is very common operation
Step-by-step tutorial on how
This is a group of 3
Providing search capabilities
to request one field of
to upload files (images,
tutorials that guide you
to a db enables users to
information via a database
text, other documents, etc)
through the process of using
query on whichever element
query. This is called a
using plain ASP pages to the
an MS Access Database in
you target them to. However
singleton query. ADO.Net has
database. Every step has
ASP. The tutorials teach you
allowing users to target
specific functions for
been explained in detail.
how to connect to a
which portion of the db they
singleton queries, but not
Downloadable source code
database, add data to the
would like to query gives
ADO (ActiveX Data Objects).
available.
database, update the
extra value. In this
This article describes how
 
database, and delete from
example, utilizing our db of
to use an ADO command object
 
the database. The 3
US States (state, statename,
to perform faster singleton
 
tutorials togather allow you
and capital) the user can
queries.
 
to build a simple Guestbook
search in any of three
 
 
for your web site.
fields (by dropdown menu
 
 
 
input) rather than the
 
 
 
application targeting one
 
 
 
specific table element.
 
 
 
Note: The db only has 50
 
 
 
observations in it, so it is
 
 
 
better to search on single
 
 
 
or double letter
 
 
 
combinations.


Date: Oct, 20 2006


Date: Jun, 17 2002


Date: Sep, 03 2001


Date: Jun, 26 2000
Filter method is very useful
This is an article on
Learn how to get a stored
There are a few different
working with large datasets.
executing all or none
image from a database and
ways to connect to an Access
You might need to put only
database queries using
display it on a page.
database using a DSN-LESS
some records from your
ASP-Database transactions.
 
connection. You can use the
database but you should
Must read for ASP-Database
 
Access driver, an OLEDB
select all data from
developers. Sample Database
 
provider connection, a
database. Fileter method is
and Code available for
 
physical path or a virtual
advantage working on
download.
 
path. Here is an example of
recordsets after querying on
 
 
each as well as a DSN-LESS
SQL command.
 
 
SQL Server connection.


Date: Aug, 09 2006


Date: Aug, 28 2000


Date: Jan, 03 2006


Date: Aug, 05 2002
{ Copyright } ©2019 NuclearScripts.com