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

Database-related

Results 101-120 of 128
Fun With Stored Procedures...
This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.
(3 ratings)
Reviews0
PriceFree
Views2949
Search Within Search Results
Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also. The following example utilizes a db on U.S. State capitals. Upon the first search two radio buttons will appear indicating a search (default) or a search within the current results. Searching within the current results will take the first search and add it to the new search and so on.
(3 ratings)
Reviews0
PriceFree
Views2190
Multiple Form Selection
Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.
(0 ratings)
Reviews0
PriceFree
Views2973
Convert to Comma-Delimited File
This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement using ASP.
(0 ratings)
Reviews0
PriceFree
Views2616
Loading Text Files Into A Database
This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.
(3 ratings)
Reviews0
PriceFree
Views2551
Filtering and Sorting of Records in a Database
Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.
(0 ratings)
Reviews0
PriceFree
Views3773
Using ASP pages to page through Recordset
In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.
(0 ratings)
Reviews0
PriceFree
Views2974
Get Your Data Faster with a Data Cache
Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.
(0 ratings)
Reviews0
PriceFree
Views1179
Search db by Field
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.
(3 ratings)
Reviews0
PriceFree
Views2857
Two Table Join
Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.
(3 ratings)
Reviews0
PriceFree
Views2459
How to create a System DSN for Access database
You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.
(0 ratings)
Reviews0
PriceFree
Views1772
Presentation Of Hierarchical Data
Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name "Hierarchy" and accesses the database using the user id "sa" with a blank password. The database is created in SQL Server 7.0.
(0 ratings)
Reviews0
PriceFree
Views2401
Adding Records to a Database using SQL
The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.
(3 ratings)
Reviews0
PriceFree
Views5425
Connecting To A Database and Retrieving Results in 9 Easy Steps
Now everybody can connect to a database. Simple database access is a huge feature of ASP and one of the most widely used by developers but when you are first learning, its hard to separate the database stuff from the rest of the code so I made this example. I even removed the includes and everything.
(0 ratings)
Reviews0
PriceFree
Views7453
ADO, SQL, and data access tutorial
This is an introductory tutorial on ASP data access. It covers Connection Object, Command Object, and Recordset Object.
(0 ratings)
Reviews0
PriceFree
Views7340
Editing and Updating Records in the Database
Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed.
(0 ratings)
Reviews0
PriceFree
Views6628
Adding Records to the Database
This is a complete tutorial on adding records to the database via ASP for beginners. Both Connection and Recordset Objects discussed. Also get an insight on 'insert' SQL statement.
(3 ratings)
Reviews0
PriceFree
Views5413
Connections, Commands and Procedures
Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.
(0 ratings)
Reviews0
PriceFree
Views2299
Accessing Database from ASP
This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.
(10 ratings)
Reviews1
PriceFree
Views18397
Simple Web-Database System Application
This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construct the Active Server Page.
(0 ratings)
Reviews0
PriceFree
Views1998
Results 101-120 of 128