The professional programmer's guide to creating database
applications and Web services with Microsoft Access 2002
and Microsoft Visual Basic .NET
The Microsoft .NET Framework is a new world for
developers who work with Microsoft Access and Visual Basic
for Applications. This book provides complete, practical
details on how to build or rewrite Access-based client
applications with Visual Basic .NET. The author sets the
stage with details about how .NET pertains to Access
developers, explores programming with Visual Basic .NET and
Microsoft ADO.NET, and puts it all together with details
about how to develop Web applications and services with
these tools. The author also provides illustrative examples
and extensive sample code-available in a live demonstration
on the Web so that developers can see the sample code in
action and learn how to apply it to working
applications.
Contents
1 Introduction to the .NET Framework
- What Is the .NET Framework?
- Why Should Access Developers Learn Visual Basic
.NET?
- Elements of the .NET Framework
- Selected .NET Programming Innovations
- Visual Basic .NET Data Processing Capabilities
2 Using Visual Basic .NET with Visual Studio .NET
- Getting Started with Visual Studio .NET
- Overview of Project Types and Project Folders
- Selected New and Different Visual Basic .NET
Topics
- Jump Start: A DataGrid Sample for the Northwind
Shippers Table
3 Visual Basic .NET Fundamentals
- Visual Basic .NET, Access, and System Data Types
- Sub and Function Procedures
- Branching and Looping
- Arrays
- Classes
4 Selected Visual Basic .NET Advanced Topics
- File Processing Techniques
- Event Handlers and Custom Events
- Class Inheritance
- Structured Exception Handling
5 Fundamentals of Programming
Windows Forms and Controls
- Programming Code-Behind Forms
- Working with Multiple Forms
- Programming Controls with the Northwind Database
6 Programming Windows Forms: Building on Fundamentals
- Navigation and Data Source Assignment Issues
- Using the Data Form Wizard
- Managing DataGrid Properties
7 ADO.NET: Concepts and Architecture
- ADO.NET Platform and Design Issues
- ADO.NET Architecture
- DataSet Object Model and Designer
8 ADO.NET Coding Techniques
- Programming Database Connections
- Programming Dynamic Data Access
- Programming Dynamic Data Manipulation
- Programming DataAdapter and DataSet Objects
9 ADO.NET: Datasets and Data Manipulation on Windows Forms
- Creating and Using Datasets
- Processing Parent-Child Relationships
- Browsing and Manipulating Data with a Form
10 Programming
ASP.NET Pages
- Introduction to ASP.NET
- Selected ASP.NET Programming Topics
- Programming Web Forms
11 Implementing ADO.NET on ASP.NET Pages
- Overview of Data Processing with ASP.NET
- Creating Solutions with the Data Form Wizard
- Using Graphically Created ADO.NET Objects
- Using Programmatically Created ADO.NET Objects
- Insert, Update, or Delete from a Web Page
12 Programming XML Web Services
- Underlying Technologies
- Using a Web Service
- Case Study for a Computational Web Service
- Deploying a Web Service
- A Web Service for the Northwind Database
13 Securing .NET Applications with Access Databases
- Overview of .NET Security
- Access User-Level Security and ADO.NET
- ASP.NET Application Forms Authentication
APPENDIX: XML for Visual Studio .NET Access Developers
- XML Document Design
- XML Schema Design
- Saving, Showing, and Reading XML
- Relations Between Tables in an XML Document