Murach's ADO.NET 3.5, LINQ,
and the Entity Framework with VB 2008

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 146
Basic skills for using the Dataset Designer 146
How to add a query that uses a SQL statement 148
How to add a query that returns a single value 152
How to add a query that uses an existing stored procedure 154
How to add a query that creates a new stored procedure 156
How to edit a query 156
How to set the advanced SQL generation options 158
How to use the Query Builder 160
Basic skills for using the Query Builder 160
How to get data from multiple tables 162
How to create a new dataset schema 164
How to create a dataset 164
How to create a data table and table adapter
using the Server Explorer
166
How to create a data table and table adapter
using the TableAdapter Configuration Wizard
168
How to use code to work with a typed dataset 170
How a typed dataset is defined 170
How to work with a typed dataset 172
The Invoice Entry application 174
The user interface 174
The dataset schema 176
Some of the Select statements 178
The code for the Add Invoice form 180
The code for the Select Vendor form 192

Murach's ADO.NET 3.5 with VB 2008

Learn more about this book

View the table of contents


More about the eBook



Our 100% 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 prompt refund...no questions asked.