Murach's ADO.NET 2.0 with VB 2005
How to work with connections, commands,
and data readers

This chapter shows you how to use connections, commands, and data readers for building 3-layer applications, the way the professionals do. At the end of this chapter, you'll be building simple 3-layer applications of your own.
Chapter 6 How to work with connections, commands, and data readers
How to create and work with connections and commands 198
How to create and work with connections 198
How to create a connection string using the SqlConnectionStringBuilder class 200
How to create a connection in a Using block 200
How to create and work with commands 202
How to work with queries that return a result set 204
How to create and work with a data reader 204
How to improve the efficiency of column lookups 206
An Invoices by Due Date application that uses a data reader 208
The user interface 208
The class design 208
The code for the Invoice class 210
The code for the InvoiceDB class 212
The code for the PayablesDB class 212
The code for the Invoices by Due Date form 214
How to work with queries that don’t return a result set 216
How to execute a query that returns a scalar value 216
How to execute an action query 216


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

Murach's ADO.NET 2.0 with VB 2005

Learn more about this book

View the table of contents

Add this book to your cart



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.