Tapping into Data with the VB .NET DataBuilder Classes

Tapping into a single database table with Visual Basic .NET can be easy when you know the secret. Learn the secret of the CommandBuilder class.

provided by: 
Originally published at Internet.com


This article is brought to you by Apress, publishers of Database Programming with Visual Basic .NET. -----------------------------------

When I started writing my book, Database Programming with Visual Basic .NET, I knew exactly what I wanted to do: create an ADO.NET reference book that was easy to read and could be read from cover to cover. I think I've managed to do that, but I've also added extra material to the book, such as how to use Message Queuing and Active Directory.

However, because of the many changes to ADO.NET between Beta 1 and Beta 2, I lost the race against time on a few topics. One such topic is the CommandBuilder class, which I'll describe here.

How to Work with the CommandBuilder Class



The CommandBuilder class automatically generates the following properties of the DataAdapter class: * InsertCommand * UpdateCommand * DeleteCommand

Before moving on, I would like to add that there is no CommandBuilder class; instead, you use the SqlCommandBuilder, OleDbCommandBuilder, or OdbcCommandBuilder class, depending on the data adapter you use (SqlDataAdapter, OleDbDataAdapter, or OdbcDataAdapter). The examples shown in this document use the SqlCommandBuilder class and related data classes.

When to Use the CommandBuilder Class

...

Read article at Internet.com site
Related Articles
- The Case for Components
In Paul Kimmel's latest column from CodeGuru.com, he tackles the hype about classes and components. In doing so, he even presents you with information on the splitter control within Visual Basic .NET.
- Learning PHP: Storing Basic Information
- JavaScript Security
- New JScript .NET Data Types
- Understanding New JScript .NET Statements
- Implementing Custom Attributes in .NET
- Auto repositioning/resizing of child controls (using C++ templates)
- Arrays in PHP
- User Code: Multiplexing Output Streams
- ADO is AOK (a simple ADO tutorial)
Regional Articles
- Tapping into Data with the VB .NET DataBuilder Classes Alabama
- Tapping into Data with the VB .NET DataBuilder Classes Alaska
- Tapping into Data with the VB .NET DataBuilder Classes Arizona
- Tapping into Data with the VB .NET DataBuilder Classes Arkansas
- Tapping into Data with the VB .NET DataBuilder Classes California
- Tapping into Data with the VB .NET DataBuilder Classes Colorado
- Tapping into Data with the VB .NET DataBuilder Classes Connecticut
- Tapping into Data with the VB .NET DataBuilder Classes DC
- Tapping into Data with the VB .NET DataBuilder Classes Delaware
- Tapping into Data with the VB .NET DataBuilder Classes Florida
- Tapping into Data with the VB .NET DataBuilder Classes Georgia
- Tapping into Data with the VB .NET DataBuilder Classes Hawaii
- Tapping into Data with the VB .NET DataBuilder Classes Idaho
- Tapping into Data with the VB .NET DataBuilder Classes Illinois
- Tapping into Data with the VB .NET DataBuilder Classes Indiana
- Tapping into Data with the VB .NET DataBuilder Classes Iowa
- Tapping into Data with the VB .NET DataBuilder Classes Kansas
- Tapping into Data with the VB .NET DataBuilder Classes Kentucky
- Tapping into Data with the VB .NET DataBuilder Classes Louisiana
- Tapping into Data with the VB .NET DataBuilder Classes Maine
- Tapping into Data with the VB .NET DataBuilder Classes Maryland
- Tapping into Data with the VB .NET DataBuilder Classes Massachusetts
- Tapping into Data with the VB .NET DataBuilder Classes Michigan
- Tapping into Data with the VB .NET DataBuilder Classes Minnesota
- Tapping into Data with the VB .NET DataBuilder Classes Mississippi
- Tapping into Data with the VB .NET DataBuilder Classes Missouri
- Tapping into Data with the VB .NET DataBuilder Classes Montana
- Tapping into Data with the VB .NET DataBuilder Classes Nebraska
- Tapping into Data with the VB .NET DataBuilder Classes Nevada
- Tapping into Data with the VB .NET DataBuilder Classes New Hampshire
- Tapping into Data with the VB .NET DataBuilder Classes New Jersey
- Tapping into Data with the VB .NET DataBuilder Classes New Mexico
- Tapping into Data with the VB .NET DataBuilder Classes New York
- Tapping into Data with the VB .NET DataBuilder Classes North Carolina
- Tapping into Data with the VB .NET DataBuilder Classes North Dakota
- Tapping into Data with the VB .NET DataBuilder Classes Ohio
- Tapping into Data with the VB .NET DataBuilder Classes Oklahoma
- Tapping into Data with the VB .NET DataBuilder Classes Oregon
- Tapping into Data with the VB .NET DataBuilder Classes Pennsylvania
- Tapping into Data with the VB .NET DataBuilder Classes Rhode Island
- Tapping into Data with the VB .NET DataBuilder Classes South Carolina
- Tapping into Data with the VB .NET DataBuilder Classes South Dakota
- Tapping into Data with the VB .NET DataBuilder Classes Tennessee
- Tapping into Data with the VB .NET DataBuilder Classes Texas
- Tapping into Data with the VB .NET DataBuilder Classes Utah
- Tapping into Data with the VB .NET DataBuilder Classes Vermont
- Tapping into Data with the VB .NET DataBuilder Classes Virginia
- Tapping into Data with the VB .NET DataBuilder Classes Washington
- Tapping into Data with the VB .NET DataBuilder Classes West Virginia
- Tapping into Data with the VB .NET DataBuilder Classes Wisconsin
- Tapping into Data with the VB .NET DataBuilder Classes Wyoming
Related Articles

Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin

Topics:
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML