Categories
ASPTips and Tutorials → Database-related

Centralizing Database Access With Visual Basic DLL''s

By centralizing database code within ActiveX DLL''s, you can simplify your development efforts, and decrease the learning curve for new developers. This article explains how to create a Visual Basic ActiveX DLL that controls database functionality.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 efficien...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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 precedenc...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Database Search Sample Code

Here is a quick sample of searching a DB for certain records. It''s really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect *...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Display Image From Database

It is possible to store images in a database using a number of third party tools or a custom built component. Once you have the images stored in your database, however, displaying them requires the use of a simple ASP page. This tutorial explains how...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Incorporating SQL Server 7.0/2000 Databases into your ASP Pages

This is a comprehensive tutorial on how to incorporate SQL server 7.0/2000 databases into your ASP pages. Topics include: Installation steps, Creating SQL Server 7.0/2000 Databases, Creating SQL Server 7.0/2000 Tables, Creating SQL Server 7.0/2000 Lo...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Running Stored Procedures in Access Database

Explains everything in detail you''ll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available f...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Introduction && Data Access

In this first article of the ASPHoleTools series, you will be shown the basics for data access. Covers how to create the basic include file for database access, and testing that data access was installed properly on your machine.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Named Recordsets

This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com