Want to hire a development team?
Search Filter
Search Filter
Sort Listings By
Show Only
By Customer Review
Licence Type

New Scripts | ASP | Tutorials & Tips | Database-related

Results 1-20 of 128
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!
(13 ratings)
Reviews1
PriceFree
Views2309
Delete Duplicates from a Database (MYSQL, MSSQL)
An easy way to delete duplicate data from a database such as MYSQL or MSSQL.
(0 ratings)
Reviews0
PriceFree
Views1691
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.
(0 ratings)
Reviews0
PriceFree
Views1000
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 just how easy it is to use transactions from ASP, inserting a record into a table and doing a "rollback" if there's a problem.
(0 ratings)
Reviews0
PriceFree
Views1404
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 tutorial we will show you how to connect to Access database and retrieve all the records from the table.
(6 ratings)
Reviews0
PriceFree
Views1982
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 database is compromised the passwords cannot be decoded. The only downside is that users cannot retrieve lost passwords, they must reset them.
(3 ratings)
Reviews0
PriceFree
Views1595
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 passwords if you already have users' database ready.
(0 ratings)
Reviews0
PriceFree
Views1535
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
(30 ratings)
Reviews0
PriceFree
Views2779
Counting Records in SQL Script
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
(0 ratings)
Reviews0
PriceFree
Views1397
An Useful Method : RecordSet.Filter
Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.
(0 ratings)
Reviews0
PriceFree
Views1378
Dynamically Dependent Dropdown
Learn how to create dynamically dependent dropdown lists with. There's an online demo and source code provided.
(6 ratings)
Reviews0
PriceFree
Views4050
http://www.dotnetindex.com/articles/2176-Filling-Data-into-Select-List.asp
In this short ASP source code, we will pull some data from a database and fill it into a select list. We will create a custom and dynamic output.
(0 ratings)
Reviews0
PriceFree
Views2291
Simple Database Class
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.
(6 ratings)
Reviews0
PriceFree
Views2475
Faster Singleton Queries with ADO
It is very common operation to request one field of information via a database query. This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
(0 ratings)
Reviews0
PriceFree
Views1391
Bullschmidt ASP Web Database Sample
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.
(9 ratings)
Reviews0
PriceFree
Views2896
Using GetRows To Get All Records From Table
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.
(6 ratings)
Reviews0
PriceFree
Views2864
Using SUM Function in An SQL Statement
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
(6 ratings)
Reviews0
PriceFree
Views2390
Suggestion Box
Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.
(9 ratings)
Reviews0
PriceFree
Views3445
Compacting an Access database from ASP code
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.
(6 ratings)
Reviews0
PriceFree
Views2549
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 first value of resultset.
(9 ratings)
Reviews0
PriceFree
Views2793
Results 1-20 of 128