Murach's Visual Basic 2008
How to use ADO.NET to write your own data access code

Chapters 14 and 15 show you how to use data sources to develop database applications. When you do that, Visual Studio generates the ADO.NET objects you need. Now, this chapter shows you how to create and work with ADO.NET objects through code. That lets you separate the data access code from the presentation code by placing the ADO.NET code in database classes, which are often reusable from one application to another.
Chapter 16 How to use ADO.NET to write your own data access code
How to work with connections and commands 506
How to create and work with connections 506
How to create and work with commands 508
How to create and work with parameters 510
How to use parameters in SQL statements 510
How to create parameters 512
How to work with parameters 514
How to execute commands 516
How to create and work with a data reader 516
How to execute queries that return a single value 518
How to execute action queries 518
A Customer Maintenance application that uses commands 520
The user interface 520
The class diagram for the business and database classes 522
The code for the CustomerDB class 524
The code for the StateDB class 530
The code for the MMABooksDB class 530
The code for the Customer Maintenance form 532
The code for the Add/Modify Customer form 536


© Copyright 1998-2010 Mike Murach & Associates, Inc.  All rights reserved.

Murach's VB 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.