ASP.NET Using Visual Basic 2010, Part 3 of 9

Course description

In this course, you will learn how to use features of Visual Studio 2010 and Visual Basic/C# 2010 to build ASP.NET Web pages. You will gain an understanding of the architecture behind ASP.NET and how to use the various ASP.NET server controls. You will learn to create consistent web sites using Master Pages, add membership features and configure-deploy ASP.NET applications, to authenticate users and limit their access to resources, direct users using Site Navigation tools, debug .NET, and to display/edit data using ASP.NET and ADO.NET. In addition, you will learn about ASP.NET features, such as support for LINQ (Language Integrated Query), CSS tools, and will become familiar with the tracing features in Visual Studio that help you quickly troubleshoot issues. You will also learn how to work with ASP.NET Profile features, ASP.NET Web Parts, and how to take advantage of creating your own user-defined control. As you progress through the course you will learn about optimizing your sites, the ListView control, and so much more.

Each LearnNowOnline training course is made up of Modules (typically an hour in length). Within each module there are Topics (typically 15-30 minutes each) and Subtopics (typically 2-5 minutes each). There is a Post Exam for each Module that must be passed with a score of 70% or higher to successfully and fully complete the course.

Prerequisites

This course assumes that students have already been introduced to Visual Studio 2008 or 2010 and Visual Basic, and have a basic understanding of the .NET Framework. Some prior experience with Web development will also be helpful.

Meet the experts

Ken Getz

Ken Getz is a featured instructor for several of our Visual Studio courses. He is a Visual Basic and Visual C# expert and has been recognized multiple times as a Microsoft MVP. Ken is a seasoned instructor, successful consultant, and the author or co-author of several best-selling books. He is a frequent speaker at technical conferences like Tech-Ed, VSLive, and DevConnections and he has written for several of the industry's most-respected publications including Visual Studio Magazine, CoDe Magazine, and MSDN Magazine.

Don Kiely

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.

Video Runtime

262 Minutes

Time to complete

322 Minutes

Course Outline

Module 5

Intro to LINQ (48:41)

• Introduction (00:40)
• Working with Data (04:39)
• LINQ and VB/C# (00:48)
• LINQ and Language Features (02:04)
• LINQ Usages (01:01)
• LINQ Overview (00:43)
• LINQ Syntax (02:17)
• Demo: Query Expressions (02:12)
• Intellisense with LINQ (02:09)
• Extension Methods (02:32)
• Demo: Custom Extension (03:26)
• More Complex Objects (00:31)
• Object Initializers (02:14)
• Demo: Object Initializers (03:34)
• Query Extension Methods (01:53)
• Lambda Expressions (02:03)
• Demo: Lambda Expressions (01:57)
• Anonymous Types (01:45)
• Demo: Anonymous Types (03:30)
• Interesting Examples (00:55)
• Demo: List Processes (03:21)
• Demo: Process a Text File (02:29)
• LINQ and Delayed Execution (01:06)
• Summary (00:42)

LINQ to SQL (21:25)

• Introduction (00:34)
• Overview: LINQ to SQL (01:17)
• Create Data Model (00:25)
• Demo: Add LINQ to SQL Class (02:58)
• Demo: Add Stored Procedure (00:29)
• Demo: Examine Data Model (01:49)
• Demo: Query SQL Database (01:38)
• Call Stored Procedures (00:22)
• Demo: Call Stored Proc (01:45)
• Anonymous Types w/SQL (00:53)
• Demo: Anonymous Types (01:37)
• Modify SQL Data (01:47)
• Demo: Modify SQL Data (04:45)
• Summary (00:59)

LINQ to DataSets/XML (28:30)

• Introduction (00:44)
• Overview: LINQ to DataSets (00:59)
• LINQ to Typed DataSets (00:28)
• Demo: Typed DataSets (02:23)
• LINQ to Untyped DataSets (02:23)
• Demo: Untyped DataSets (03:59)
• LINQ tor XML (01:57)
• Demo: LINQ to XML (07:57)
• Transform XML (00:48)
• Demo: Transform XML (06:00)
• Summary (00:45)

Module 6

.NET Configuration (41:30)

• Introduction (01:36)
• Benefits (02:00)
• Navigate Hierarchy (01:27)
• machine.config (01:59)
• Demo: config files (01:39)
• Root web.config (01:58)
• Application web.config (02:30)
• Use location Element (02:42)
• Config File Elements (02:18)
• system.web Element (02:16)
• Demo: web.config (00:22)
• appSettings Section (01:05)
• connectionStrings Section (00:46)
• system.web Section (01:44)
• ASP.NET Configuration Tools (03:07)
• Config Security Features (03:17)
• Web Site Admin Tool (01:19)
• Demo: Web Site Admin Tool (02:38)
• Unified Error Handling (06:08)
• Summary (00:29)

Programming Configuration (23:22)

• Introduction (01:09)
• Configuration APIs (03:59)
• Demo: Configuration API (01:22)
• Connection Strings/Providers (05:24)
• Write to Config Files (02:25)
• Demo: Write to Config Files (05:44)
• Save appSettings (01:41)
• Retrieve all appSettings (01:06)
• Summary (00:28)

External Files (26:14)

• Introduction (00:36)
• Overview: Exernal FIles (00:52)
• Demo: External Config File (03:25)
• Standard Config Sections (01:23)
• Demo: Debug Setting (01:00)
• Read from Standard Section (01:28)
• Write to Standard Section (01:28)
• Is There More to Config API? (00:57)
• Encrypt Config Sections (01:37)
• Protected Config Provider (01:32)
• Demo: Protected Provider (01:44)
• Demo: Encrypted Conn String (02:23)
• Demo: Encrypt Data (02:04)
• Retrieve Connection Strings (01:28)
• Encrypt w/External FIle (01:40)
• Move Encrypted Files (01:54)
• Summary (00:33)

Module 7

SqlDataSource (46:18)

• Introduction (01:05)
• Data Binding (01:12)
• Data Source Controls (02:17)
• Data-Bound Controls (01:11)
• SqlDataSource (00:41)
• Demo: SqlDataSource (01:21)
• Configue SqlDataSource (03:41)
• Add/Configure DropDownList (02:35)
• Run/View Source (02:18)
• Use Stored Procedure (01:25)
• Add/Config DetailsView Ctrl (04:46)
• View in Browser (01:57)
• Add/Configure Filtering (06:05)
• Data Source Control Events (01:29)
• Handle Delete Error (02:48)
• Demo: Handle Delete Error (03:38)
• Demo: Dropdown Refresh (02:42)
• Demo: Item Updated Event (03:12)
• Summary (01:47)

Other DataSource Controls (26:41)

• Introduction (01:18)
• ObjectDataSource Control (02:02)
• Demo: ObjectDataSource (05:46)
• LinqDataSource Control (01:15)
• Demo: LinqDataSource (06:25)
• XmlDataSource Control (01:09)
• Demo: XmlDataSource (02:35)
• Demo: FormView Control (04:58)
• Summary (01:11)