- 1,251 categories
- 40,829 scripts
- 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.
- 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...
- 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...
- 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 *...
- 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...
- 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...
- 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...
- 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.
- 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.
- This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
Page: