Advertisment

AddCriteria Simplifies SQL Queries

AddCriteria is a small function that simplifies the code needed to produce a SQL query from a set of optional criteria posted by a user. This...

Views: 716 | | by Daniel
ASP - Database Related

Database Editing Sample

This is a quick sample code which combines a number of database functions into one script. Includes functions to add, delete, and edit records in a...

Views: 720 | | by Daniel
ASP - Database Related

Creating Custom Hierarchical Recordsets

This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this...

Views: 694 | | by Donald
ASP - Database Related

Using SQL-DMO To Backup and Verify a Database

This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL...

Views: 597 | | by Tutorial
ASP - Database Related

Turn foreign keys into list boxes

The author writes 'CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing...

Views: 714 | | by Donald
ASP - Database Related

What's in an ADO Connection String?

This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own...

Views: 0 | | by Adam
ASP - Database Related

Name Search & Hyperlinks to Detail

This is an example code showing how to conduct searches on a database to display hyperlinked summaries that can be clicked on to display detail data.

Views: 714 | | by Marry
ASP - Database Related

Display Table Script Writer

This is a Web-based script writer that generates an ASP code for displaying an Access or SQL Server database using user-submitted variable names...

Views: 707 | | by Simon
ASP - Database Related

Database Paged Search

This is a sample code that combines a Database Paging and a Database Search script into one. It shows you how to perform a wilcard search on a...

Views: 700 | | by Colin
ASP - Database Related

Integrating User Search with ASP and SQL Server Full-Text Search

This article provides sample source code for a user query parser which allows users to submit full-text search queries from ASP to SQL Server 2000....

Views: 619 | | by David
ASP - Database Related

SQL: Sum, Average, Max, Min, Count, Detail

This example shows how to perform a variety of statistics on your data using simple SQL such as Sum, Average, Max, Min, and Count. It uses stock...

Views: 626 | | by Amy
ASP - Database Related

Uploading and Inserting Images (binary data) into Database

This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code...

Views: 653 | | by Tutorial
ASP - Database Related

Displaying Images (binary data) from the Database via ASP

This is an article about displaying binary data (images) from an Access database. Online demo and sample code available for download.

Views: 612 | | by Marry
ASP - Database Related

Connections And Server Database Permissions

This is an overview of SYSTEM DSN's, DSN-LESS Connections, and any database permissions that may need to be set on the server. Helpful for...

Views: 643 | | by Colin
ASP - 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...

Views: 0 | | by Sarah
ASP - Database Related

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

Views: 632 | | by Stephen
ASP - Database Related

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

Views: 718 | | by Mark
ASP - Database Related

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

Views: 732 | | by Troy
ASP - Database Related

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

Views: 717 | | by Adam
ASP - Database Related

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

Views: 631 | | by Colin
ASP - Database Related