Murach's C# 2005
How to use data sources with databases (part 2)

This chapter builds on what was presented in chapter 18 to give you a full set of skills for handling database data in your C# 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 19 How to use data sources with databases (part 2)
How to use the DataSet Designer 578
Basic skills for using the DataSet Designer 578
How to add a query 580
How to edit a query 582
How to use the Query Builder 584
How to set the advanced SQL generation options 586
How to get data from multiple tables 588
How to get the value of an identity column 590
How to work with the ToolStrip control 592
How to use the Items Collection Editor 592
How to code an event handler for a ToolStrip item 594
How to use code to work with a binding source or a dataset 596
How to work with a binding source 596
How a typed dataset is defined 598
How to work with a typed dataset 600
More skills for working with a DataGridView control 602
How to use a DataGridView control to create a Master/Detail form 602
How to work with the values in a DataGridView control 604
How to delete a row from a DataGridView control 604
The Customer Invoice Maintenance application 606
The user interface 606
The dataset schema 608
Some of the Select statements 610
The code for the Customer Invoice Maintenance form 612
The code for the Select Customer form 618
The code for the View Line Items form 618
The code for the Customer Maintenance form 618
The code for the Add New Invoice form 622


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

Murach's C#

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.