When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects. |
|
Create a connection to DBF files using JetOLEDB provider (DSN-less, ODBC-less connection), basic work with DBF files (select, insert, update), other ISAM formats + FOXPRO option, real sample code, create a new DBF file. |
|
Store and read SQL image/binary data using functions in this article. You can store local or remote files in an sql table along with a description and other fields. HexString (BinaryToHex) conversion function. |
|
Most variables that you deal with contain one value. Sometimes however it's useful to store more than one value. Arrays are one way to do this. |
|
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 info from a form. Both examples include an example of a DSN-LESS connection. |
|
When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects. |
|
A stored procedure is like a map to commonly requested information, which can speed things up. This is because stored procedures are cached in the server. |
|
How to build a dynamic dropdown list with ASP and database data. Then, how to use ADO and recordset filtering to produce a structured list. |
|
Learn how to get the results from a DB query: [Error / Vield Value], [TRUE / FALSE], [FOR ... NEXT], [WHILE ... WEND] |
|
Learn how to build DB queries: [SELECT], [INSERT], [UPDATE], [DELETE] |
|
|
|
