Database Editing Sample
This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a database table. It illustrates a number of useful techniques for database manipulation.
http://www.asp101.com/samples/db_edit.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Database Paged Search
This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a database table and then page through the results.
http://www.asp101.com/samples/db_paged_search.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Database Search Sample Code
Here is a quick sample of searching a DB for certain records. Its really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect \* to work. Why is it %\? I have no idea, but it is. An Access 97 version of the database is available for download.
http://www.asp101.com/samples/db_search.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Display Table on Web Page
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no recordswere returned from a query, and how to detect null and blank values in the data.
http://www.learnasp.com/learn/dbtable.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Display Table Script Writer
This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names and the name of the table. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code.
http://www.codeave.com/asp/code.asp?u_log=62
(Rating: 0.00 Votes: 0)
Rate ItReview It
Dynamic Generation of SQL Statement for Database Search
This article discusses how to dynamically generate appropriate SQL statements for database search. It covers string manipulation and searching on multiple fields.
http://www.programmersresource.com/articles/dynamicsql.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Dynamically Generated HTML Forms
This article discusses two different ways to dynamically generate data-entry forms: Use the ADO OpenSchema Method, and Query Your SQL Server System Tables. Describes advantages and disadvantages of each method.
http://www.swynk.com/friends/jones/articles/dynamic_forms.asp
(Rating: 0.00 Votes: 0)
Rate ItReview It
Get Your Data Faster with a Data Cache
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.
Price: Free
http://www.15seconds.com/Issue/000608.htm
(Rating: 0.00 Votes: 0)
Rate ItReview It
Getting Your Quotes Right In SQL For ASP
It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used\? When is a double quote used\? When are they used together\? Which takes precedence\? This article will answer these questions.
http://www.webdevelopersjournal.com/articles/quotes_sql_asp.html
(Rating: 0.00 Votes: 0)
Rate ItReview It
Insert Using SQL
This short tutorial demonstrates how to insert data into a SQL database using SQL statements.
http://www.js-examples.com/asp/insertsql.html
(Rating: 0.00 Votes: 0)
Rate ItReview It
