ASP → Tips and Tutorials → Database-related

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 server.

• Platforms
  • Linux
• Licenses
  • Freeware

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.

• Platforms
  • Windows
• Licenses
  • Freeware

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), other ISAM formats + FOXPRO option, real sample code, create a new DBF file.

• Platforms
  • Linux
• Licenses
  • Freeware

Dynamic, database backed dropdown lists

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.

• Platforms
  • Linux
• Licenses
  • Freeware

Dynamic Form and Database Driven Marquee

Basically, I had the problem of needing a marquee to scroll important updates but everyone who needed to update it was not HTML savvy. So I made it form based. And the coolest part about it is, you can control the background color, and the text color...

• Platforms
  • Linux
• Licenses
  • Freeware

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.

• Platforms
  • Linux
• Licenses
  • Freeware

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 script.

• Platforms
  • Linux
• Licenses
  • Freeware

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 a form. Both examples include an example of a DSN-LESS connection.

• Platforms
  • Linux
• Licenses
  • Freeware

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 connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server c...

• Platforms
  • Linux
• Licenses
  • Freeware

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 info from a form. Both examples include an example of a DSN-LESS connection.

• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• Previous
• 1
• 2
• 3
• 4
• 5
• 6
• ...
• 15
• Next