Advertisment
This article describes practical methods of optimizing the performance of ASP pages which retrieve and display tabular data from a database. Test...
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...
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...
Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary,...
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...
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.
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...
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down...
Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update),...
How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple.
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....
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...
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...
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...
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...
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...
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...
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....
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...
To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of...