Search Filter
Search Filter
Sort Listings By
Show Only
By Customer Review
Licence Type

Database-related

Results 81-100 of 128
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 efficient when dealing with very large sets of data.
(3 ratings)
Reviews0
PriceFree
Views2771
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 precedence? This article will answer these questions.
(3 ratings)
Reviews0
PriceFree
Views1569
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 * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.
(0 ratings)
Reviews0
PriceFree
Views3678
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 to retrieve images from a database table and use them in an HTML page.
(0 ratings)
Reviews0
PriceFree
Views4046
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 Logins, Setting SQL Server 7.0/2000 Permissions, Increasing SQL Server 7.0/2000 Performance with Indexes, and Distributed SQL Server 7.0/2000 Transactions & Queries.
(3 ratings)
Reviews0
PriceFree
Views2307
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 for download.
(3 ratings)
Reviews0
PriceFree
Views3228
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.
(0 ratings)
Reviews0
PriceFree
Views1126
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.
(3 ratings)
Reviews0
PriceFree
Views2776
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.
(0 ratings)
Reviews0
PriceFree
Views1073
Search Database
This example / tutorial explains how to use the LIKE operator to perform a partial match on an Access database.
(0 ratings)
Reviews0
PriceFree
Views2310
ASP Data Access for Beginners
The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).
(0 ratings)
Reviews0
PriceFree
Views3851
Insert Using SQL
This short tutorial demonstrates how to insert data into a SQL database using SQL statements.
(3 ratings)
Reviews0
PriceFree
Views1984
Multiple Form Selection (Where In)
Allowing multiple choices of data observations enables people to customize views of your data and adds value to your applications. This example utilizes our db on the career statistics of Hammeriní Hank Greenberg. The years he played are available to select from in a dropdown menu. When multiple years are selected they are passed comma delimited. Utilizing the where in statement in our sql the comma delimited selections are appended to our sql statement to display only those years selected.
(0 ratings)
Reviews0
PriceFree
Views2786
Display Table on Web Page
This page demonstrates the capabilities how to display a table from a SQL statement. It illustrates not only how to display the table, but also how to detect that no records were returned from a query, and how to detect null and blank values in the data.
(1 ratings)
Reviews1
PriceFree
Views2490
Paging Records With GetRows
You all must have seen and done stuff with the RecordSet object, infact everything is done with the RecordSet object. Now, this acticle explains how to use GetRows to page through the records that you recieve from the SELECT. It's much faster than MoveNext, because it closes the database connection immediately whereas MoveNext loops through the records with the overhead of the database connection. Plus GetRows let's you count the records correctly!
(0 ratings)
Reviews0
PriceFree
Views3899
Limit query results with the Recordset object
Have this short program around so that you can quickly see what columns and what data are in your database. Here you will see some of the common methods and properties used to limit the results from your SQL query. Using a simple form that takes a table name and a submit button, and you can easily display increments of the table data. Full source code available.
(0 ratings)
Reviews0
PriceFree
Views1860
Creating a Simple SQL-Driven Web Site
This hands-on tutorial explains how to develop a simple SQL-driven web site in just minutes. Topics include: Our Database Design, Creating a Data Source, Inserting A Tip Into Our Database, Displaying and Deleting Tips, Searching the Database, and Displaying the Tips.
(0 ratings)
Reviews0
PriceFree
Views2877
Generating random records from the Database
This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.
(3 ratings)
Reviews0
PriceFree
Views2762
ASP-Database Transactions
This is an article on executing all or none database queries using ASP-Database transactions. Must read for ASP-Database developers. Sample Database and Code available for download.
(0 ratings)
Reviews0
PriceFree
Views2706
Speed up Database Access using GetRows
This is an article on using Recordset. It uses GetRows method to speedup database access. One of the fastest ways of displaying database records with ASP. Sample Database and Code available for download.
(3 ratings)
Reviews0
PriceFree
Views3250
Results 81-100 of 128