Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

Programming Microsoft Visual Basic .NET for Microsoft Access Databases

by: Rick Dobson

Notify me when in stock

On-line Price: TBAPaperbackpackage, 656

Retail Price: TBA

Publisher: MICROSOFT PRESS,Dec-2002

Category: VB.NET Level:

ISBN: 0735618194
ISBN13: 9780735618190

Add to Shopping Cart

About the Book


  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.

Table of Contents

--------------------------------------------------------------------------------


  Acknowledgments xi

Introduction xiii

1

Introduction to the .NET Framework 1


      What Is the .NET Framework?

2


      Why Should Access Developers Learn Visual Basic .NET?

4


              Catching the Next Generation Wave

4


              Learning Consistent Tools

5


              Exposing Access Databases Over the Web

6


              Exposing Access Databases via XML Web Services

7


      Elements of the .NET Framework

8


              Common Language Runtime

9


              Running Source Code

11


              Assemblies

13


      Selected .NET Programming Innovations

15


              Namespaces

15


              Object Orientation

16


              Exception Handling

17


      Visual Basic .NET Data Processing Capabilities

18


              Why Move to ADO.NET?

18


              ADO.NET Data Providers

19


              ADO.NET Architecture 20

2

Using Visual Basic .NET with Visual Studio .NET 25


      Getting Started with Visual Studio .NET

26


              Configuring Visual Studio .NET for Visual Basic .NET

27


              Using the Start Page

29


              Introducing Three Important IDE Windows

30


      Overview of Project Types and Project Folders

32


              Summary of Project Types

33


              Starting a Windows Application

35


              Adding a Message Box to a Windows Application

37


              Creating and Consuming a Class Library Project

39


      Selected New and Different Visual Basic .NET Topics

44


              Data Types

44


              Arrays

45


              New Keyword and Sub Procedures

46


              Opening and Closing Class References

46


              Class Inheritance

48


              Namespaces

50


      Jump Start: A DataGrid Sample for the Northwind Shippers Table

52


              Building the Jump Start Example

53


              Demonstrating the Jump Start Example

57

3

Visual Basic .NET Fundamentals

59


      Visual Basic .NET, Access, and System Data Types

60


              Visual Basic .NET Data Type Summary

60


              Visual Basic .NET Data Types vs. Access Data Types

63


              Value Type Objects vs. Reference Type Objects

65


      Sub and Function Procedures

69


              Creating Reusable Code Blocks

70


              Passing Values

70


              Using Option Strict

72


              Using Access Modifiers

73


              Optional Parameters and Parameter Arrays

74


      Branching and Looping

78


              With--End With Statements

78


              Branching Statements

78


              Looping Statements

79


              COM Interop

80


              Iterating Through Tables in a Database

82


              Iterating Through Columns in a Table

85


              Translating Access Data Types

86


      Arrays

92


              Overview of Array Design

92


              Processing a One-Dimensional Array

95


              Processing a Two-Dimensional Array

96


              Consolidating Metadata with an Array

99


      Classes

102


              Overview

103


              Creating and Using Class Properties

104


              Creating and Using Methods

116

4

Selected Visual Basic .NET Advanced Topics

129


      File Processing Techniques

130


              System.IO Objects for File Processing

130


              Listing Files in a Folder

132


              Selecting and Showing Binary Files

137


              Writing Access Database Contents to Files

142


              Reading and Managing Text Files

145


      Event Handlers and Custom Events

146


              Overview of Event Processing

146


              Form Load Event Basics

149


              Working with Windows and System Timers

150


              Raising Events from Custom Classes

157


      Class Inheritance

162


              Overview of Concepts and Keywords

163


              Setting Up for Class Inheritance Demonstrations

165


              Running the Application Project

177


      Structured Exception Handling

179


              Overview

180


              Setting Up the SEH Sample

181


              SEH Programming vs. Programming Without Error Trapping

182


              Catching Multiple Exceptions in a Try Block

185


              Using the Finally Clause

187


              Throwing Your Own Exceptions

190

5

Fundamentals of Programming Windows Forms and Controls 193


      Programming Code-Behind Forms

194


              Windows Form Designer Generated Code Region

194


              Adding Custom Code to the Module Behind a Form

196


              Manipulating a Form with Event Procedures

199


              Disabling the Close Control in the Control Box

204


      Working with Multiple Forms

209


              Modal vs. Modeless Forms

210


              Returning a Result from a Child Form

214


              Passing Values Both Ways Between Forms

220


      Programming Controls with the Northwind Database

224


              Validating a Password with a TextBox Control

224


              Browsing the Shippers Table with TextBox Controls

227


              Navigating with a ComboBox and Showing Pictures

232


              Using One Form to Designate Data for a Second

238


              Building a Switchboard Form with the LinkLabel Control

244

6

Programming Windows Forms: Building on Fundamentals

251


      Navigation and Data Source Assignment Issues

252


              Switchboard Form for Samples

252


              Navigation with Text Boxes

256


              Adding Formatting to TextBox Navigation

262


              ComboBox Navigation

266


              Dynamically Formatting a DataGrid Control

269


              Loading One of Three Data Sources into a DataGrid Control

274


      Using the Data Form Wizard

280


              Menu for the Section

280


              Data Access and Manipulation with TextBox Controls

281


              Add an Updateable Data Source to a DataGrid Control

286


              Main/sub Forms

290


              Main Table with Aggregated Sub Form

294


      Managing DataGrid Properties

296


              The ReadOnly and AllowSorting Properties

296


              The CurrentCell and CurrentRowIndex Properties

300

7

ADO.NET: Concepts and Architecture

313


      ADO.NET Platform and Design Issues

314


              Overview of ADO.NET Platform Issues

314


              Overview of ADO.NET Design Elements

316


              Comparison of ADO.NET and ADO Data Access

319


      ADO.NET Architecture

321


              OleDbConnection

321


              OleDbCommand

327


              OleDbDataReader

332


              OleDbDataAdapter

337


      DataSet Object Model and Designer

344


              Overview

344


              Demonstrating Code Syntax

347

8

ADO.NET Coding Techniques

355


      Programming Database Connections

356


              Reporting Connection Properties for Microsoft Access

357


              Connecting to a SQL Server Database

360


              Connecting to a Database at Your Place or Their Place

363


      Programming Dynamic Data Access

366


              Dynamic Data Access with a SQL String and a Variable

367


              Validating a String Variable Before Using It

368


              Dynamic Data Access with a SQL String and a Parameter

372


              Dynamic Data Access with an Access Query and Parameters

375


      Programming Dynamic Data Manipulation

378


              Creating an Access Database Programmatically

379


              Adding Tables to a Database Programmatically

381


              Dynamic Data Manipulation Within a Transaction

383


      Programming DataAdapter and DataSet Objects

388


              Data Manipulation Setup Code

390


              Displaying Metadata and Data from a Dataset

394


              Manipulating Rows in a Code-Based Dataset

399


              Working with Graphically Based Datasets

404


              Concurrency Violations

409

9

ADO.NET: Datasets and Data Manipulation on Windows Forms

413


      Creating and Using Datasets

414


              Three Ways to Make a Dataset

414


              Understanding Datasets from the Forms Designer

418


              Custom Initialization Code for a Dataset

420


              Schemas for Typed and Untyped Datasets

421


              Using IntelliSense for Typed Schemas

426


              Creating a Single Dataset with Two DataTable Objects

427


      Processing Parent-Child Relationships

429


              Computing Child Values with an Untyped Dataset

429


              Computing Child Values with a Typed Dataset

438


      Browsing and Manipulating Data with a Form

443


              Design and Operational Views of Form3

444


              What the Application Does

446


              The Form Load Event Procedure

447


              Browsing Through Rows

452


              Inserting a New Row

454


              Deleting the Currently Selected Row

457


              Updating a Row

458

10

Programming ASP.NET Pages

461


      Introduction to ASP.NET

462


              Platform Requirements and Browser Considerations

462


              Comparing Web Applications with Windows Applications

463


              Contrasting ASP.NET with ASP

465


      Selected ASP.NET Programming Topics

466


              Web Forms and Their Views

466


              The Web Forms Page Class

469


              Controls on a Web Forms Page

470


      Programming Web Forms

471


              Hello and Goodbye Sample

471


              Hello and Refresh Sample

476


              Logging In to a Protected Page Sample

481

11

Implementing ADO.NET on ASP.NET Pages

489


      Overview of Data Processing with ASP.NET

490


              Three-Tiered Architecture

490


              ADO.NET and ASP.NET

491


              Built-In Data Validation Tools

492


      Creating Solutions with the Data Form Wizard

493


              Building a Solution with the Wizard

493


              Editing the HTML Behind a Wizard Page

497


              Editing the Visual Basic Code Behind a Wizard Page

498


      Using Graphically Created ADO.NET Objects

499


              Design and Operation Page Views

499


              The Code Behind the Web Page

502


      Using Programmatically Created ADO.NET Objects

506


              Design and Operational Page Views

507


              The Code Behind the Web Page

508


      Insert, Update, or Delete from a Web Page

512


              Design and Operational Page Views

512


              The Code Behind the Web Page

516

12

Programming XML Web Services

525


      Underlying Technologies

526


              Quick Synopsis of XML Web Services

526


              XML

527


              UDDI

528


              WSDL

528


              SOAP

529


      Using a Web Service

529


              Building a Web Application Client for a Web Service

530


              Building a Windows Application Client for a Web Service

536


      Case Study for a Computational Web Service

539


              Building the DaysTilEOM Web Service

539


              The Code for the DaysTilEOM Web Service

541


              Testing the Web Service

543


              Building a Client Application on the Localhost

544


              Building a Client Application on Another Workstation

548


      Deploying a Web Service

549


              Overview

550


              Deploying the DaysTilEOM Web Service

550


              Invoking a Deployed Web Service

551


      A Web Service for the Northwind Database

555


              Overview of the Application

555


              The Web Service Project

556


              Testing and Demonstrating the Web Service

559


              Building a Client Application

563

13

Securing .NET Applications with Access Databases

569


      Overview of .NET Security

570


              Code Access Security

570


              Role-Based Security

572


              Cryptographic Services

574


      Access User-Level Security and ADO.NET

575


              Review of User-Level Security Design Issues

576


              Setting Up for the User-Level Security Samples

577


              Selecting from a Secure Access Database with ADO.NET

582


              Updating a Secure Access Database with ADO.NET

588


      ASP.NET Application Forms Authentication

594


              Editing the Default Web.config File

595


              Creating the Login.aspx Page

596


              Creating a Secure Web Page

599


              Demonstrating the SecurePhoneList Web Application

601

APPENDIX: XML for Visual Studio .NET Access Developers 603


      XML Document Design

603


              XML Document Features

604


              Creating an Element-Centric XML Document

605


              Creating an Attribute-Centric XML Document

606


      XML Schema Design

607


              Schema Design Issues

607


              Creating, Editing, and Using an XML Schema

608


      Saving, Showing, and Reading XML

612


              Saving XML

612


              Showing XML

614


              Reading XML

615


      Relations Between Tables in an XML Document

617


              Graphically Creating a Relation Between Two Tables

617


              Using a Graphically Created Relation

620

INDEX 623


  Related Books


  Microsoft Visual Basicr .NET Language Reference

Microsoft Visual Basicr .NET Deluxe Learning Edition