Murach's Visual Basic 2005
How to use data sources with databases (part 2)

This chapter builds on what was presented in chapter 14 to give you a full set of skills for handling database data in your Visual Basic applications using the .NET data sources. So once you've finished this chapter, you'll be able to develop complex database applications on your own.

Chapter 15 How to use data sources with databases (part 2)
How to use the Dataset Designer 476
Basic skills for using the Dataset Designer 476
How to add a query 478
How to edit a query 480
How to use the Query Builder 482
How to set the advanced SQL generation options 484
How to get data from multiple tables 486
How to get the value of an identity column 488
How to work with the ToolStrip control 490
How to use the Items Collection Editor 490
How to code an event handler for a ToolStrip item 492
How to use code to work with a binding source or a dataset 494
How to work with a binding source 494
How a typed dataset is defined 496
How to work with a typed dataset 498
More skills for working with a DataGridView control 500
How to use a DataGridView control to create a Master/Detail form 500
How to add an unbound column to a DataGridView control 502
How to work with the values in a DataGridView control 504
How to delete a row from a DataGridView control 504
The Customer Invoice Maintenance application 506
The user interface 506
The dataset schema 508
Some of the Select statements 510
The code for the Customer Invoice Maintenance form 512
The code for the Select Customer form 518
The code for the Line Items form 518
The code for the Customer Maintenance form 518
The code for the Add Invoice form 522




Murach's 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.