/**

popular collection of scripts for all

*/
/** Search */

{ 

Database-related

 }

Display Table Script Writer

Hits: 853
*****
3.0

DSN-less MS Access connection

Hits: 847
*****
0.0

Adding Records to the Database

Hits: 846
*****
0.0

Database Paged Search

Hits: 832
*****
0.0
This is a Web-based script
In order to connect to an
This is a complete tutorial
This is a sample code that
writer that generates an ASP
Acees database with ASP
on adding records to the
combines a Database Paging
code for displaying an
through ODBC using a DSN
database via ASP for
and a Database Search script
Access or SQL Server
file, you'll need to have
beginners. Both Connection
into one. It shows you how
database using
full access to the server to
and Recordset Objects
to perform a wilcard search
user-submitted variable
create the DSN file,
discussed. Also get an
on a database table and then
names and the name of the
something that can be
insight on 'insert' SQL
page through the results.
table. Copy the output code
difficult if your site is
statement.
 
into an asp document on your
hosted somewhere. This
 
 
web server and your db is
lesson will teach you an
 
 
ready to be displayed on the
alternative connecton
 
 
web. The DSN connection
method, a DSN-less
 
 
requires that you register
connection. As tests has
 
 
the DSN for the db prior to
shown, an DSN-less
 
 
executing the code.
connection to Access gives
 
 
 
you better performance. You
 
 
 
can have up to 20-30
 
 
 
simultaneous users on the db
 
 
 
without problems.
 
 


Date: May, 21 2001


Date: Mar, 12 2000


Date: Mar, 25 2000


Date: Apr, 25 2001
Adding a record from a
This is an example code
ODBC is great and all but for
Displaying specific subsets
database table is a simple
showing how to conduct
speed and reliability you
of data from a database is
task. Fill out the form
searches on a database to
should switch to OLE DB to
easy to accomplish in .asp.
below and click submit. The
display hyperlinked
power your database driven
The following example
sql statement will be
summaries that can be
apps. This tutorial will
utilizes an Access database
generated for you.
clicked on to display detail
show you how to do it two
of Mark "The Bird"
 
data.
ways: in the global.asa and
Fidrych and displays all of
 
 
in any ASP page.
his season statistics for
 
 
 
1976 contained in the
 
 
 
database rather than
 
 
 
displaying the entire db.


Date: Apr, 15 2002


Date: May, 21 2001


Date: Feb, 13 2000


Date: Jan, 20 2000
{ Copyright } ©2019 NuclearScripts.com