Lessons

Resources

Full Course Outline
Video ZIP File (32 MB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to ASP 302
Get notifications when this page is updated

Intro

In this lesson, you will learn how to display a specific record from a database, work with SQL statements, and edit or delete records using both classic ASP 3.0 code and some JavaScript. We will use a Microsoft Access 2003 database on a Windows 2000 server, and I will demonstrate the steps using FrontPage 2003, although you can use any web editor. This is lesson ASP302.

Transcript

Welcome to ASP302, brought to you by ASP LearningZone.com. I am your instructor, Richard Rost.

In today's class, we are going to learn how to display a specific record from our database. We are going to learn about SQL statements. We are going to learn how to edit a record, and we are going to learn how to delete a record in a method using some JavaScript as well.

This class follows ASP301. I strongly recommend you take that before taking this class, and of course, all of my beginner and intermediate classes as well. If you are serious about database development, I strongly recommend you take my Microsoft Access 101 class as well.

In this class, I will be using standard ASP 3.0 with a Windows 2000 server. I will also be using FrontPage 2003 as my web editor, although you can use any editor that you would like. I am also connecting to a Microsoft Access 2003 database file that we uploaded to the server in the last class, ASP301. If you took ASP301, you will also know that you can connect to any database type that you would like. I showed you how to do that in the last class.

If you have any questions about the material covered in today's class, you can post them in the student forums for ASP302. You can find a link to them on the website at asplearningzone.com, or you should see the student forums appear next to the video player if you are online.

Quiz

No quiz available.

Summary

Today's video from ASP Learning Zone focuses on how to display, edit, and delete specific records in a database using ASP 3.0. I guide you through the use of SQL statements to manage records, including how you can utilize JavaScript to support the delete operation.

To follow along with this lesson, you should have already completed ASP301 and ideally all of my beginner and intermediate courses to ensure you have a solid understanding of the basics. It is also very helpful to take my Microsoft Access 101 course if you are getting serious about database development, since many of the skills transfer directly to this material.

In this session, I am working with standard ASP 3.0 on a Windows 2000 server. For editing purposes, I will be working in FrontPage 2003, but you are free to use any web editor you are comfortable with. The database connection is to a Microsoft Access 2003 file that we uploaded in ASP301, but as you learned in that class, you are not limited to Access. You can connect to any database type using the same principles.

If you have any questions about the topics covered in ASP302, I encourage you to participate in the student forums dedicated to this course. There is a link available at asplearningzone.com, and if you are watching the video online, the forums should appear right alongside the video player.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

This is an introduction and overview for an ASP video class.