Advanced Visual Basic 2010

1. Classes
1.1 Classes and Objects
1.2 Manual Software Testing
Tutorial 1-1: Manually testing integer input
1.3 Creating Your Own Classes
Tutorial 1-2: Creating a Student Class
Tutorial 1-3: Adding a parameterized constructor to the Student class
1.4 Enumerated Types
Tutorial 1-4: Enumerated Account type
1.5 Focus on Program Design and Problem Solving: Bank Teller Application
Tutorial 1-5 Building the Bank Teller application


2. Input Validation and User Interfaces
2.1 Input Validation
Tutorial 2-1: Using the ErrorProvider control
2.2 Exception Handling
2.3 ListBox, ComboBox, and CheckedListBox
2.4 Dates and Times
2.5 ToolStrip Control
Tutorial 2-2: Building the Coffee Shop Application
2.6 WebBrowser, SplitContainer, and TabControl
Tutorial 2-3: Completing a WebBrowser application
2.7 Focus on Problem Solving: Kayak Tour Scheduling Wizard
Tutorial 2-4: Completing the Kayak Tour Wizard application


3. Collections
3.1 ArrayLists
Tutorial 3-1: ArrayList of test scores
3.2 ArrayLists of Custom Objects
Tutorial 3-2: Building an ArrayList of Student objects
3.3 List and Dictionary Classes
Tutorial 3-3: Creating a text concordance
3.4 LINQ (Language Integrated Query)
Tutorial 3-4: Performing LINQ queries on a List


4. Using SQL Server Databases
4.1 Database Basics
4.2 SQL SELECT Statement
4.3 Using the DataGridView
Tutorial 4-1: Showing a database table in a DataGridView control
4.4 Selecting DataSet Rows
Tutorial 4-2: Filtering rows in the SalesStaff table
4.5 Data-Bound Controls
Tutorial 3-3: Displaying the Members table in a ListBox
Tutorial 3-4: Inserting rows in the Karate Payments table
Tutorial 3-5: Adding a total to the Insert_Karate_Payments application
4.6 Focus on Problem Solving: Karate School Manager Application
Tutorial 3-6: Creating the Karate School Manager startup form
Tutorial 3-7: Karate School Manager: Listing all members
Tutorial 3-8: Karate School Manager: Adding new members
Tutorial 3-9: Karate School Manager: Finding members by name
Tutorial 3-10: Karate School Manager: Listing all payments
Tutorial 3-11: Karate School Manager: Showing payments by one member


5. ADO.NET Database Objects
5.1 Creating databases
Tutorial 5-1: Creating a SQL Server Express Database
Tutorial 5-2: Adding the Appointments table to the RepairServices database
Tutorial 5-3: Adding the RepairTypes table to the RepairServices database
Tutorial 5-4: Creating relations between the RepairTypes, Appointments, and Customers tables
Tutorial 5-5: Changing the database connection from the SQL Express server to a database file
5.2 DataTables
5.3 Updating Databases Using SQL
5.4 Home Repair Services Application
Tutorial 5-6: Adding the Appointments class to the middle tier
Tutorial 5-7: Creating the main startup form
Tutorial 5-8: Adding classes to the middle tier
Tutorial 5-9: Adding controls to the New Appointment form
Tutorial 5-10: Searching for appointments
Tutorial 5-11: Modifying existing appointments
Tutorial 5-12: Selecting appointments to modify
Tutorial 5-13: Deleting an appointment
Tutorial 5-14: Displaying a joined appointment list


6. Advanced Classes
6.1 Structures
6.2 Components
Tutorial 6-1: Creating a Component and referencing it from another Application
Tutorial 6-2: Adding an Advisor class to the RegistrationLib component
Tutorial 6-3: Using the Advisor and Student classes
6.3 Unit Testing
Tutorial 6-4: Creating a Unit Test Project
Tutorial 6-5: Creating more unit tests for the IntArray class
Tutorial 6-6: Testing the Advisor.MaxCredits method
6.4 Events
Tutorial 6-7: The WeatherStation Events application
6.5 Inheritance
Tutorial 6-8: Student Inheritance application


7. LINQ to SQL
7.1 Using LINQ to Select Data
Tutorial 7-1: Displaying the Karate Members table
Tutorial 7-2: Displaying the Karate class schedule
7.2 Updating Tables
Tutorial 7-3: Using a BindingSource to update the Members table
Tutorial 7-4: Using LINQ queries to add schedule entries


8. Creating Web Applications
8.1 Programming for the Web
8.2 Creating ASP.NET Applications
Tutorial 8-1: Creating the Click application
8.3 ASP.NET Controls
Tutorial 8-2: Student Picnic application
Tutorial 8-3: Tracking server events
8.4 List-Type Controls
Tutorial 8-4: Signing up for a Kayak Tour
8.5 Designing Web Forms
Tutorial 8-5: College Advising Wizard
8.6 State Management


9. Programming Web Forms
9.1 Working in Source (XHTML) Mode
9.2 Cascading Style Sheets
9.3 Custom Error Handling
9.4 Uploading Files and Sending Email
9.5 Data Validation Controls
9.6 Working with Multiple Web Forms
9.7 Focus on Problem Solving: Vacation Rentals Application
9.8 Browser Cookies


10. Web Applications with Databases
10.1 Master-Detail Pages
10.2 Using Databases
10.3 Data Binding and ListControls
10.4 GridView Control Buttons
10.5 Using JavaScript
10.6 Using Ajax

11. Web Services and Windows Presentation Foundation
11.1 Introducing XML Web Services
11.2 NorthWind Web Service Example
11.3 Creating and Accessing Remote Services


12. Reports, MDI, Interfaces, and Polymorphism
12.1 Using Reports in Applications
12.2 Report Expert
12.3 Report Designer
12.4 Xtreme Bike Sales Example
Chapter Summary

Appendix A. Answers to Checkpoints
Appendix B. Reference
B.1 TimeSpan and Date/Time Formatting
B.2 ListView Control
B.3 SQL Server Data Types
B.4 DataList Control (ASP.NET)
B.5 Multiple Document Interface (MDI) Applications
B.6 User Interface Design Guidelines
B.7 Writing to the Application Log File
B.8 Interfaces
B.9 Abstract Classes and Polymorphism
B.10 Windows Presentation Foundation