Most Popular Scripts | ASP | Tutorials & Tips | Database-related

This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorials together allow you to build a simple Guestbook for your web site.

This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements

This source code displays results dividing to pages. Code provides Next Previous page links with numeric page numbers. You may modify source code to use with MS SQL or MS Access database. For this example, we have used MS SQL Server using sample database Northwind.

This article will explain how to import the contents of a text file (.txt) to an Access Database when using MS text or OLE DB Drivers wont do! We will be using the FileSystem and TextStream objects in this article!

This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

This sample ASP Web database can give you ideas about tying everything together and can even be used as a starting point for a Web project.

Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update), other ISAM formats + FOXPRO option, real sample code, create a new DBF file.

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.

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 server.

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 first value of resultset.

Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

This database class handles Select, Insert, Update, and Delete. It also takes steps to ensure your SQL syntax is valid, and that memory leaks / errors are prevented. Tutorial comes with demo, downloadable code, and an in depth explanation.

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 explained in detail. Downloadable source code available.

This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock trading performance of EPOS as an example.

This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code available for download.

This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.

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 script.

Learn how to create dynamically dependent dropdown lists with. There's an online demo and source code provided.