Murach's ADO.NET 2.0 with VB 2005
How to work with untyped datasets and data adapters

This chapter shows you how and when to use untyped datasets and data adapters instead of typed datasets and table adapters in your database applications.
Chapter 16 How to work with untyped datasets and data adapters
An introduction to untyped datasets 564
How to create and work with untyped datasets 564
Typed vs. untyped datasets 564
How to create and work with data adapters and command builders 566
How to create and work with data adapters 566
How to create and work with command builders 568
How to work with an untyped dataset 570
How to retrieve and work with a data row 570
How to modify or delete an existing data row 572
How to add a data row 574
How to work with data columns that allow nulls 576
How to improve the efficiency of retrieval operations 578
How to handle update errors 580
A Vendor Maintenance application 582
The code for the Vendor Maintenance form 582
The code for the Add/Modify Vendor form 586
How to bind controls to an untyped dataset 592
How to define the schema of an untyped dataset using the collection editors 592
How to bind controls at design time 594
How to bind controls at run time 596
How to define the schema for a dataset through code 598
How to create tables through code 598
How to create columns through code 600
How to create unique constraints through code 604
How to create foreign key constraints through code 606
How to create data relations through code 608


© 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.