Murach's ADO.NET 2.0 with VB 2005
How to use the Dataset Designer

This chapter shows you how to use the Visual Studio Dataset Designer to work with queries and schema beyond what you learned in chapter 3. Then, the sample application shows you both the power and the limitations of working with data sources and datasets.
Chapter 5 How to use the Dataset Designer
How to work with an existing dataset schema 144
Basic skills for using the Dataset Designer 144
How to add a query that uses a SQL statement 146
How to add a query that returns a single value 150
How to add a query that uses an existing stored procedure 152
How to add a query that creates a new stored procedure 154
How to edit a query 154
How to set the advanced SQL generation options 156
How to use the Query Builder 158
Basic skills for using the Query Builder 158
How to get data from multiple tables 160
How to create a new dataset schema 162
How to create a dataset 162
How to create a data table and table adapter using the Server Explorer 164
How to create a data table and table adapter using the TableAdapter Configuration Wizard 166
How to use code to work with a typed dataset 168
How a typed dataset is defined 168
How to work with a typed dataset 170
The Invoice Entry application 172
The user interface 172
The dataset schemat 174
Some of the Select statements 176
The code for the Add Invoice form 178
The code for the Select Vendor form 190


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