Advertisment

Dynamic, database backed dropdown lists

How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list.

Views: 922 | | by Sean
ASP - Database Related

ASP Speed Tricks

This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test...

Views: 911 | | by Source
ASP - Database Related

Uploading Images to Database Using Persist AspUpload

You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you...

Views: 727 | | by Daniel
ASP - Database Related

MS Access: Tables, Views and Procedures

Ever wondered how to create a table, view or procedure with MS Access? This article shows us how to create all three and work with them from an ASP...

Views: 791 | | by Brad
ASP - Database Related

How to display records from top 4 database systems using plain ASP?

Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary,...

Views: 794 | | by Jason
ASP - Database Related

Wielding the Power of the DataView

When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In...

Views: 827 | | by Jarry
ASP - Database Related

Executing Transact-SQL INSERT statement

In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

Views: 850 | | by Source
ASP - Database Related

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be...

Views: 852 | | by Adam
ASP - Database Related

Executing Transact-SQL DELETE statement

In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down...

Views: 838 | | by Nick
ASP - Database Related

ASP and DBF database file connection

Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update),...

Views: 896 | | by Steve
ASP - Database Related

Get the ID of the record entered

How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.

Views: 889 | | by David
ASP - Database Related

Populate dropdowns from your database

Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting....

Views: 860 | | by Simon
ASP - Database Related

Access and SQL Server DSN-LESS connections

There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider...

Views: 747 | | by Sean
ASP - Database Related

Add records with sql statments

Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the...

Views: 818 | | by Marry
ASP - Database Related

Edit records with sql statements

Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the...

Views: 802 | | by Brad
ASP - Database Related

Delete records with sql statements

Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from...

Views: 928 | | by Troy
ASP - Database Related

Use an include file for your database connection

Use an include file for your database connection. Here's the reason why. Before I wised up to this, I was placing the connection on every...

Views: 769 | | by John
ASP - Database Related

Uploading and inserting files (binary data) to the database

Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been...

Views: 637 | | by Nick
ASP - Database Related

Displaying binary data from the database using plain ASP

Step-by-step tutorial on how to display uploaded binary files from the database using plain ASP pages. Every step has been explained in detail....

Views: 724 | | by Daniel
ASP - Database Related

SQL In Simple English - Part II

This is the second article in this series. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL...

Views: 819 | | by Sean
ASP - Database Related