ASP Cookies and Sessions tutorials
In this part 3 of "Using ASP for Form Handling", you will be shows how to put the form data gathered into a database. Shows how to develop a working registration system, set up the database and make it accessible via the web.
Related Tutorials
Adding Site Registration
This tutorial will explain how to adding site registration.
Using ASP for Form Handling: Part 4 - Filling the Gaps
This article covers a number of miscellaneous topics include: handling radio buttons and check boxes, emailing attachments with CDONTS, sending HTML in an email message, and some ways of using the data stored in the registration database.
Building E-Commerce sites
This manuscript is an abridged version of a chapter from the Wrox Press book Beginning E-Commerce.This is chapter 3 which looks at building the Object Model,the careful design of these object models are the key to building good software.
Creating a Members Area in ASP
A frequent task for ASP developers is to create a members area style section of a website. This would normally involve registration, a login page, and then access to a section of the site that is only available to registered users. This tutorial will cover the steps needed to create all 3 sections.
How to display records from top 4 database systems using plain ASP?
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.
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, it's hard to separate the database stuff from the rest of the code so I made this example.
Speedup Database Access using GetRows
Learn connecting to the database via ASP to inserting, updating and selecting data from the database.
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.
Reading a Database
Learn how to display data from a Database.Displaying data from a database is one of the most common uses of ASP.
Building Components in Java
Learn to develop COM objects using Java.
Inserting Rows into a Database
This tutorial will show you how to insert a row of data into a database using ASP and an MS Access database. You can do it on one ASP file, but we'll have two files: one processor page (proc.asp), and one form page (form.asp). Then, we'll make the MS Access database that corresponds to the ASP.
How to connect to MS Access Database Using ASP
This tutorial documents code for connecting to a MS Access Database using the DSN-Less appraoch. With DNS-Less approach all you have to do in your code is define the location where your database resides.
Fun With Stored Procedures
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... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.
Simple Table Display With Where Clause (Hard Coded)
Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes our Access database of Mark "The Bird" Fidrych and displays all of his season statistics for 1976 contained in the database rather than displaying the entire db.
Querying an Access database in ASP
Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes.
Database Connection Strings
Although our ASP database tutorials all use MS Access connection strings, there are many sorts of database software out there for use with ASP. This tutorial will show you how to connect with them.
Integrating Flash with an Access Database
This article explains how to connect a Flash movie to an Access database, and use an ASP page to query the database and hand information over to the Flash movie. We are going to build a very simple Flash address book to demonstrate the technique.
Search Database
This tutorial will explains how to use the LIKE operator to perform a partial match on an Access database.
Authentication Tutorial
This is a quick and easy guide to building an authentication system in ASP. First, it explains Authentication: What it is, how you work with it, and what options are currently available to you. Then, it explains each choice in more detail to help you decide which is the best way for you to authenticate your web users.
Fastest way of Database Access : Caching Records in Memory
In this step by step tutorial I will guide you to build the fastest method to display records from the database using plain ASP. The technique we are going to use is based on a simple fact that you don't have to hit database every time you want to display records.
Generating random records from the Database
In this article we will learn how to display random records from the database. From the articles so far, you will be able to display records from the database in a variety of ways and do a lot with them.
Building an ASP File Manager
This article describes how to build a very powerful, potentially destructive application using the File System Object. It should never be implemented in a production environment without ensuring that proper security precautions have been taken to maintain the integrity of the data contained on the web server.
Professional Windows DNA
This is a sample chapter from Wrox Press book 'Professional Windows DNA.' It prvides info on building web applications with VB, COM+, MSMQ, SOAP and ASP.
Upload - to database, or not to database?
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command.
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.
Centralizing Database Access With Visual Basic ActiveX DLL's
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo.
An Article Rating System With ASP
In this tutorial I'm going to show you how to use ASP and a Microsoft Access database to create a basic content rating system. We will look at how to setup the database to accept ratings, how to add ratings to the database, how to stop users from rating once they have already done so, and finally how to accumulate the ratings for each piece of content and display them in a graphical format.
Accessing Database from ASP
In this tutorial I will guide through the creation of a simple Microsoft Access database to incorporating it in to your ASP web pages.
How to Connect to Database using a Connection String
In this tutorial we will show you how to connect to our Access database called 'examples.mdb' and retrieve all the records from the table 'cars'.
Understanding File Upload
Building an upload file mechanism on a Web server can often require using a costly DLL. Tiago Halm's article shows you how to upload a file using only Active Server Page (ASP) code and Internet Explorer.
Creating a Stack Bar Chart Using ASP
This article with the attached files demonstrates building a stack bar chart using ASP without components.
Filtering and Sorting of Records in a Database
In this article we will see on how to search the database for a group of records.
Connecting to an Access database
Learn to connect an MS Access database to you ASP pages.
Simple Web-Database System Application
This application is for the beginners who wonder how to build their own web database system on their own computers. I will use Microsoft FrontPage98 and Microsoft Access in the demonstration. The reader should be familiar with the RDBMS concept and know how to use Microsoft Access tool to build a local database system. They should also have the Northwind.mdb file, which is included in Microsoft Office 97.
Using Triggers to Track Database Action
This article examines how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.
Running Stored Queries 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.
Building a Yahoo!™ Style Navigation Bar
This sample will demonstrate how to quickly build a simple Yahoo! style navigation bar that displays the paths a user has taken to get to a given directory, and also displays a table of links to the sub-directories of the current directory.
DSN vs DSN less Database Connections
In this article we will learn the two ways of connecting to database: * via DSN ( Data Source Name ) * without DSN
Paging Records using GetRows
This article 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.
How to connect to an Access database with a DSN
DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table 'cars'. Everything is commented so you won't have trouble.
 
Categories