Join David Gassner for an in-depth discussion in this video Using the exercise files, part of ASP.NET Essential Training.
Just a quick word about the excise files I'll be using. If you are a Premium member of the lynda.com Online Training Library or if you're watching this tutorial on a disk, you have access to the exercise files used throughout this title. In the exercise files folder, I have collected some assets for you to use during our tour of building dynamic websites with ASP.NET. They include graphic files, a database script, and starting web page files for use in the sample websites that I'll be creating. I've copied the folder to my desktop, but you can put it anywhere you want. To get started with the video series, you will need to follow the instructions in Chapter 1, where I describe how to install Visual Web Developer, and Chapter 2, where I describe how to install SQL Server and create a database that you'll need.
From that point onward, you can choose to work through the entire video series, or if you would like to jump in at a particular point, you can use the solution folders. Most of the chapters have two projects: one starting project and one that's completed. You can open these chapter folders directly from within Visual Web Developer. Just select File > Open Website from the menu, and then select the website folder that you want to explore. If you are a monthly or annual subscriber to lynda.com, you don't have access to the exercise files, but you can easily follow along the instructions and demonstrations on the screen and use any files you want as you create your own sample websites. Let's get started.
Author
Updated
2/13/2013Released
4/28/2009- Storing data with SQL Server
- Using the GridView control to present and edit dynamic data
- Creating a data entry system
- Attaching external CSS files
- Creating pages to log in and authenticate visitors
- Installing Internet Information Services (IIS) on Windows XP and Windows Vista
- Deploying an ASP.NET website on IIS
Skill Level Beginner
Duration
Views
Q: When trying to create a new database, after pasting the text into the SQL Management Suite and executing the query, the database is not created and the following message appears:
Database 'mybookstore' does not exist. Make sure that the name is entered correctly.
What is causing this error?
A: The database must be explicitly created before the script is run. Start by right-clicking on the Databases item in the left panel, then follow the prompts to create the database. Then retry the query.
Q: I am running into problems installing the latest version of ASP.NET. Has the installation procedure changed since this tutorial was recorded?
A: The installation process for the newest version of ASP.NET and its associated tools is a little different than in ASP.NET 3.5, which was used to record this course. You can download Microsoft Web Platform Installer 2.0 from:
<a href="http://www.microsoft.com/web/downloads/platform.aspx" target="blank">http://www.microsoft.com/web/downloads/platform.aspx</a>
Microsoft Web Platform Installer 2.0 includes everything you need:
ASP.NET 4?
Visual Web Developer 2010?
SQL Server Express
You must have one of the following operating systems:
Windows 7?
Windows Vista?
Windows Vista SP1?
Windows XP SP2+?
Windows Server 2003 SP1+?
Windows Server 2008?
Windows Server 2008 R2
You must have administrator privileges on your computer to run the Web Platform Installer.
Q: This course was updated on 2/13/2013. What changed?
A: Since this course was recorded, Microsoft has released both ASP.NET 4.5, the latest version of the server-side web application server, and Visual Studio Express 2012 for Web (the successor product to Visual Web Developer). Both have been adapted to work on Windows 8. There will be some visual changes and some functional changes, but most of the server-side code shown in the course is the same. This update provides a map for those working with the latest software so they can navigate their way through the course.
In particular, we added <em>What's new</em> movies for both ASP.NET 4 and 4.5, a movie explaining the significance of the update, a movie on installing SQL Server Express 2012, and one on exporting database scripts in SQL Server Management Studio 2012, as well as updates to visuals throughout the course.
Q: In the chapter on user authentication, an authentication error results when I try to use the Login component or register a new user. How do I fix this?
A: This is a known error that can occur when using the original release of Visual Studio 2012 Express for Web. Update your copy of Visual Studio for Web to at least maintenance release 1, and then try the exercise again.
Related Courses
-
Visual Studio 2010 Essential Training
with Walt Ritscher8h 8m Intermediate
-
Introduction
-
Welcome1m 42s
-
Prerequisites2m 21s
-
Using the exercise files1m 32s
-
-
1. Getting Started
-
2. Using Microsoft SQL Server 2008
-
Creating a new database8m 51s
-
Testing SQL queries3m 53s
-
3. Creating ASP.NET Pages
-
4. Programming in ASP.NET
-
Using loops6m 52s
-
Using functions9m 25s
-
Using trace statements4m 47s
-
Debugging with breakpoints5m 45s
-
Commenting code4m 38s
-
5. Creating Reusable Code
-
Creating web controls5m 53s
-
-
6. Using Cascading Style Sheets in Web Forms
-
Attaching external CSS files3m 12s
-
Defining a CSS selector6m 10s
-
7. Presenting Dynamic Data
-
8. Creating a Data Entry System
-
Redirecting page requests9m 39s
-
Creating an update page6m 20s
-
Deleting database records2m 35s
-
9. Validating User Input
-
10. Creating Reports
-
Selecting data for a report6m 52s
-
11. Managing Session State
-
Using session variables6m 37s
-
12. Securing a Site with Forms Authentication
-
13. Deploying a Web Site
-
Installing IIS on Windows XP6m 32s
-
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Using the exercise files