Top Rated Scripts | ASP | Tutorials & Tips | Database-related
Named Recordsets
posted byhotscriptsinDatabase-related
This article by James Shaw demonstrates how to dynamically add properties to an object (expando properties) - by implementing a function to create named recordsets.
Reviews0
PriceFree
Views1252
Introduction & Data Access
posted byCRJonesinDatabase-related
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.
Reviews0
PriceFree
Views1310
Display Image From Database
posted byssmithinDatabase-related
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 to retrieve images from a database table and use them in an HTML page.
Reviews0
PriceFree
Views4241
Centralizing Database Access With Visual Basic DLL's
posted bycwilsoninDatabase-related
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.
Reviews0
PriceFree
Views1729
Connections And Server Database Permissions
posted bywebmasterinDatabase-related
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 people just learning ASP as well as people with some experience.
Reviews0
PriceFree
Views2264
Access Reports on the Web
posted byInfoinDatabase-related
This article shows how to publish and distribute Microsoft Access reports on the web using ASP.
Reviews0
PriceFree
Views3572
Integrating User Search with ASP and SQL Server Full-Text Search
posted bybobinDatabase-related
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. Full source code available for download.
Reviews0
PriceFree
Views2087
Null Is Null
posted byDaveinDatabase-related
A discussion of how to use null values effectively in your database tables. Includes a discussion of the logic behind nulls and some practical programming techniques.
Reviews0
PriceFree
Views1474
Add New Data Access Routines to Your Arsenal
posted byramainDatabase-related
This article presents three modular routines to access and fetch data easier with ASP. Topics include: Fetching a Recordset, An alternative to the GetConnectedRecordSet function that opens a connection, fetches a recordset, and immediately closes the connection, and Utilities for Creating Valid SQL Statements.
Reviews0
PriceFree
Views1434
Name Search & Hyperlinks to Detail
posted byinfoinDatabase-related
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.
Reviews0
PriceFree
Views1965
What's in an ADO Connection String?
posted byjohninDatabase-related
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 instead of cutting and pasting them.
Reviews0
PriceFree
Views1879
Turn foreign keys into list boxes
posted byhotscriptsinDatabase-related
The author writes "CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.
Reviews0
PriceFree
Views2050
Using SQL-DMO To Backup and Verify a Database
posted bycwilsoninDatabase-related
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 Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.
Reviews0
PriceFree
Views1624
Creating Custom Hierarchical Recordsets
posted bymitchellinDatabase-related
This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid understanding of both data shaping and custom Recordsets.
Reviews0
PriceFree
Views1591
Database Editing Sample
posted byjohninDatabase-related
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 database table. It illustrates a number of useful techniques for database manipulation.
Reviews0
PriceFree
Views3576
AddCriteria Simplifies SQL Queries
posted byedinDatabase-related
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 article explains how to use this function.
Reviews0
PriceFree
Views1327
Interrogating a Stored Procedure with ADO
posted bydavidinDatabase-related
This article describes how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. It shows how to create the code in an automated fashion for use in VBScript connecting to MS SQL Server 7.
Reviews0
PriceFree
Views1256
SQLServerTools Object
posted bywebmasterinDatabase-related
This example shows how to get a list of all current tables in the database, get a list of dependent stored procedures for each table and do it all in a stored procedure.
Reviews0
PriceFree
Views1385
Using Disconnected Recordsets
posted byseriousconsultinDatabase-related
This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets.
Reviews0
PriceFree
Views1639
Using Multiple Recordsets
posted byhencahinDatabase-related
This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.
Reviews0
PriceFree
Views2319