ASP → Tips and Tutorials → Database-related

Compact MS Access Database using ASP

Tutorial and ASP code to compact MS Access Database just 1 file.

• Platforms
  • Windows
• Licenses
  • Freeware

Selecting random record from database

This ASP source code describes a short way to select a record from database. First we need to calculate how many records we have in our table. Using randomize function, we generate a random number between 0 to count of records in database. Last...

• Platforms
  • Windows
• Licenses
  • Freeware

Import text file to MS Access

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!

• Platforms
  • Windows
• Licenses
  • Freeware

Delete Duplicates from a Database (MYSQL, MSSQL)

An easy way to delete duplicate data from a database such as MYSQL or MSSQL.

• Platforms
  • Windows
• Licenses
  • Freeware

Retrieving Column Names with values

This tutorials based on a bit of knowledge on SQL. Sample code displays us how to get and show name of columns with values.

• Platforms
  • Windows
• Licenses
  • Freeware

Make database access safer with transactions

You can use transactions in ASP as a kind of insurance policy for your database activities, making them safer and providing better error recovery. Transactions are most useful when doing multiple actions on multiple tables. The example below shows ju...

• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • Freeware

How to connect to database using a connection string

The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this t...

• Platforms
  • Linux
• Licenses
  • Freeware

Encrypt Passwords Before Storing In a Database

This code demonstrates how to use an MD5 hash to encrypt user passwords when storing them in a database. There are constantly news items about companies where user information is compromised. By storing passwords using an MD5 hash, even if your dat...

• Platforms
  • Windows
• Licenses
  • Freeware

How to Encrypt Passwords in the Database

If you are developing a password-protected web site, you have to make a decision about how to store user password information securely. This article will show you how to encrypt user passwords with md5 algorithm and how to start using encrypted passw...

• Platforms
  • Windows
• Licenses
  • Freeware

ASP Tutorials - Connecting and Using MS Access Databases

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

• Platforms
  • Windows
• Licenses
  • Commercial License,
  • Free for non-commercial use

Page:

• 1
• 2
• 3
• ...
• 15
• Next