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

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

Results 21-40 of 128
An Easy Way Delete A Record
Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
(6 ratings)
Reviews0
PriceFree
Views2173
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 results of each coding technique show the potential for dramatic speedups of dynamic web pages.
(6 ratings)
Reviews0
PriceFree
Views3201
Executing Transact-SQL UPDATE statement
In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database
(6 ratings)
Reviews0
PriceFree
Views3295
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
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
Views1981
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
Easy way to add a record
Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you.
(3 ratings)
Reviews0
PriceFree
Views3015
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.
(3 ratings)
Reviews0
PriceFree
Views3457
Speed up Database Access using GetRows
This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.
(3 ratings)
Reviews0
PriceFree
Views3843
Compact & Repair Access Database
Compact and repair your access database online from ASP code. This is example code of how this can be done.
(3 ratings)
Reviews0
PriceFree
Views2884
Using MyODBC To Access Your MySQL Database Via ASP
MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.
(3 ratings)
Reviews0
PriceFree
Views2600
Loading Text Files Into A Database
This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.
(3 ratings)
Reviews0
PriceFree
Views2779
Fastest way of Database Access : Caching Records in Memory
A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available.
(3 ratings)
Reviews0
PriceFree
Views2215
Insert Using SQL
This short tutorial demonstrates how to insert data into a SQL database using SQL statements.
(3 ratings)
Reviews0
PriceFree
Views2172
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. Downloadable source code available.
(3 ratings)
Reviews0
PriceFree
Views2310
Analyzing Duplicate Records
This is the first of the four-part "Advanced SQL Techniques" series, which describes a quick and efficient way to delete duplicate records from a table.
(3 ratings)
Reviews0
PriceFree
Views1414
Paging: Use ADO, getrows, or a Stored Procedure?
Paging is basically querying a database and presenting a page full of the query's results. In ASP and SQL Server programming, there are three approaches to paging. This article compares the approaches and explains which one is the most efficient when dealing with very large sets of data.
(3 ratings)
Reviews0
PriceFree
Views2997
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.
(3 ratings)
Reviews0
PriceFree
Views1788
Generating random records from the Database
This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.
(3 ratings)
Reviews0
PriceFree
Views3152
Fun With Stored Procedures...
This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.
(3 ratings)
Reviews0
PriceFree
Views3212
Results 21-40 of 128