Subscribe
Tutorial search

How to display records from top 4 database systems using plain ASP? - ASP tutorial


Sometimes, we would have chance to convert our existing database or create a new database. Some decisions IT professionals need to make are scary, and choosing database software is one of them. This overview aims to describe how to set database connections with some common database software (Oracle, MySQL, MS Access,MS SQL Server).
Category: ASP > Database - Difficulty:


More cool ASP tutorials:



Storing Images to Database and Retrieving to GridView
Storing Images to Database and Retrieving to GridView
Storing Images to Database and Retrieving to GridView
Difficulty:
Send email via ASP 3.0 and CDONTS
Send email via ASP 3.0 and CDONTS
This script shows how to send an email via the CDONTS objects available to ASP 3.0. It will take a selection of form input, create the required e-mail objects, send the e-mail to the specified recipient and then redirect the user to a confirmation page, thanking them for their input.
Difficulty:
The Global.asa file
The Global.asa file
The Global.asa file
Difficulty:
Two Table Join
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.
Difficulty:
Executing Transact-SQL DELETE statement
Executing Transact-SQL DELETE statement
In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.
Difficulty: