Best Tutorials website
Latest tutorials

Advertisment

ASP Speed Tricks

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: 979 | Rating star | by Source
ASP - Database Related

Uploading Images to Database Using Persist AspUpload

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: 795 | Rating star | by Daniel
ASP - Database Related

MS Access: Tables, Views and Procedures

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: 857 | Rating star | by Brad
ASP - Database Related

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

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: 867 | Rating star | by Jason
ASP - Database Related

Wielding the Power of the DataView

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: 889 | Rating star | by Jarry
ASP - Database Related

Executing Transact-SQL INSERT statement

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: 925 | Rating star | by Source
ASP - Database Related

Counting Records In A Database Table

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: 920 | Rating star | by Adam
ASP - Database Related

Executing Transact-SQL DELETE statement

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: 912 | Rating star | by Nick
ASP - Database Related

ASP and DBF database file connection

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: 969 | Rating star | by Steve
ASP - Database Related

Get the ID of the record entered

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: 958 | Rating star | by David
ASP - Database Related

Populate dropdowns from your database

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: 926 | Rating star | by Simon
ASP - Database Related

Access and SQL Server DSN-LESS connections

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: 820 | Rating star | by Sean
ASP - Database Related

Add records with sql statments

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: 886 | Rating star | by Marry
ASP - Database Related

Edit records with sql statements

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: 870 | Rating star | by Brad
ASP - Database Related

Delete records with sql statements

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: 994 | Rating star | by Troy
ASP - Database Related

Use an include file for your database connection

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: 838 | Rating star | by John
ASP - Database Related

Uploading and inserting files (binary data) to the database

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: 703 | Rating star | by Nick
ASP - Database Related

Displaying binary data from the database using plain ASP

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: 795 | Rating star | by Daniel
ASP - Database Related

SQL In Simple English - Part II

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: 888 | Rating star | by Sean
ASP - Database Related

ASP upload to database or file

ASP upload to database or file

To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of...


Views: 724 | Rating star | by Nick
ASP - Database Related