Programming Microsoft Visual Basic. NET for Microsoft Access Databases  

1 2 3

• 1. Table Of Contents

• 2. back cover

• 3. Programming Microsoft Visual Basic .NET for Microsoft Access Databases

• 4. Introduction

  Who Should Read This Book

• 5. Organization of the Book

  Organization of the Book Overview of the .NET Framework Visual Basic .NET Windows Forms ADO.NET Web Development Security XML

• 6. Installing and Using the Samples and Demo Files

  Installing and Using the Samples and Demo Files

• 7. Support Information

  Support Information

• 8. System Requirements

  System Requirements

• 9. Chapter 01 : Introduction to the .NET Framework

  Overview

• 10. What Is the .NET Framework?

  What Is the .NET Framework?

• 11. Why Should Access Developers Learn Visual Basic .NET?

  Why Should Access Developers Learn Visual Basic .NET? Catching the Next Generation Wave Learning Consistent Tools Exposing Access Databases Over the Web Exposing Access Databases via XML Web Services

• 12. Elements of the .NET Framework

  Elements of the .NET Framework Common Language Runtime Running Source Code Assemblies

• 13. Selected .NET Programming Innovations

  Selected .NET Programming Innovations Namespaces Object Orientation Exception Handling

• 14. Visual Basic .NET Data Processing Capabilities

  Visual Basic .NET Data Processing Capabilities Why Move to ADO.NET? ADO.NET Data Providers ADO.NET Architecture

• 15. Summary

  Summary

• 16. Chapter 02 : Using Visual Basic .NET with Visual Studio .NET

  Overview

• 17. Getting Started with Visual Studio .NET

  Getting Started with Visual Studio .NET Configuring Visual Studio .NET for Visual Basic .NET Using the Start Page Introducing Three Important IDE Windows

• 18. Overview of Project Types and Project Folders

  Overview of Project Types and Project Folders Summary of Project Types Starting a Windows Application Adding a Message Box to a Windows Application Creating and Consuming a Class Library Project

• 19. Selected New and Different Visual Basic .NET Topics

  Selected New and Different Visual Basic .NET Topics Data Types Arrays New Keyword and Sub Procedures Opening and Closing Class References Class Inheritance Namespaces

• 20. Jump Start: A DataGrid Sample for the Northwind Shippers Table

  Jump Start: A DataGrid Sample for the Northwind Shippers Table Building the Jump Start Example Demonstrating the Jump Start Example

• 21. Summary

  Summary

• 22. Chapter 03 : Visual Basic .NET Fundamentals

  Overview

• 23. Visual Basic .NET, Access, and System Data Types

  Visual Basic .NET Access and System Data Types Visual Basic .NET Data Type Summary Visual Basic .NET Data Types vs. Access Data Types Value Type Objects vs. Reference Type Objects

• 24. Sub and Function Procedures

  Sub and Function Procedures Creating Reusable Code Blocks Passing Values Using Option Strict Using Access Modifiers Optional Parameters and Parameter Arrays

• 25. Branching and Looping

  ADOX.DataTypeEnum ado Type = guid == typeof(bool).GUID.ToString() ? ADOX.DataTypeEnum.adBoolean :

• 26. Arrays

  Arrays Overview of Array Design Processing a One-Dimensional Array Processing a Two-Dimensional Array Consolidating Metadata with an Array

• 27. Classes

  Classes Overview Creating and Using Class Properties Creating and Using Methods

• 28. Summary

  Summary

• 29. Chapter 04 : Selected Visual Basic .NET Advanced Topics

  Overview

• 30. File Processing Techniques

  File Processing Techniques System.IO Objects for File Processing Listing Files in a Folder Selecting and Showing Binary Files Writing Access Database Contents to Files Reading and Managing Text Files

• 31. Event Handlers and Custom Events

  Event Handlers and Custom Events Overview of Event Processing Form Load Event Basics Working with Windows and System Timers Raising Events from Custom Classes

• 32. Class Inheritance

  Class Inheritance Overview of Concepts and Keywords Setting Up for Class Inheritance Demonstrations Running the Application Project

• 33. Structured Exception Handling

  Structured Exception Handling Overview Setting Up the SEH Sample SEH Programming vs. Programming Without Error Trapping Catching Multiple Exceptions in a Try Block Using the Finally Clause Throwing Your Own Exceptions

• 34. Summary

  Summary

• 35. Chapter 05 : Fundamentals of Programming Windows Forms and Controls

  Overview

• 36. Programming Code-Behind Forms

  Programming Code-Behind Forms Windows Form Designer Generated Code Region Adding Custom Code to the Module Behind a Form Manipulating a Form with Event Procedures Disabling the Close Control in the Control Box

• 37. Working with Multiple Forms

  Working with Multiple Forms Modal vs. Modeless Forms Returning a Result from a Child Form Passing Values Both Ways Between Forms

• 38. Programming Controls with the Northwind Database

  Programming Controls with the Northwind Database Validating a Password with a TextBox Control Browsing the Shippers Table with TextBox Controls Navigating with a ComboBox and Showing Pictures Using One Form to Designate Data for a Second Building a Switchboard Form with the LinkLabel Control

• 39. Summary

  Summary

• 40. Chapter 06 : Programming Windows Forms: Building on Fundamentals

  Navigation and Data Source Assignment Issues Switchboard Form for Samples Navigation with Text Boxes Adding Formatting to TextBox Navigation ComboBox Navigation Dynamically Formatting a DataGrid Control Loading One of Three Data Sources into a DataGrid Control

• 41. Using the Data Form Wizard

  Using the Data Form Wizard Menu for the Section Data Access and Manipulation with TextBox Controls Add an Updateable Data Source to a DataGrid Control Mainsub Forms Main Table with Aggregated Sub Form

• 42. Managing DataGrid Properties

  Managing DataGrid Properties The ReadOnly and AllowSorting Properties The CurrentCell and CurrentRowIndex Properties

• 43. Summary

  Summary

• 44. Chapter 07 : ADO.NET: Concepts and Architecture

  ADO.NET Platform and Design Issues Overview of ADO.NET Platform Issues Overview of ADO.NET Design Elements Comparison of ADO.NET and ADO Data Access

• 45. ADO.NET Architecture

  ADO.NET Architecture OleDbConnection OleDbCommand OleDbDataReader OleDbDataAdapter

• 46. DataSet Object Model and Designer

  DataSet Object Model and Designer Overview Demonstrating Code Syntax

• 47. Summary

  Summary

• 48. Chapter 08 : ADO.NET Coding Techniques

  Programming Database Connections Reporting Connection Properties for Microsoft Access Connecting to a SQL Server Database Connecting to a Database at Your Place or Their Place

• 49. Programming Dynamic Data Access

  Programming Dynamic Data Access Dynamic Data Access with a SQL String and a Variable Validating a String Variable Before Using It Dynamic Data Access with a SQL String and a Parameter Dynamic Data Access with an Access Query and Parameters

• 50. Programming Dynamic Data Manipulation

  Programming Dynamic Data Manipulation Creating an Access Database Programmatically Adding Tables to a Database Programmatically Dynamic Data Manipulation Within a Transaction

1 2 3