Murach's VB.NET Database Programming
with ADO.NET (1.x edition)

This chapter teaches you how to use data views to filter and sort the data in a data table, parameterized queries to restrict the data that's retrieved from a database, and relationships to work with multiple tables in a dataset.

Chapter 7 How to work with data views, parameterized queries, and relationships
How to use data views 196
An introduction to data views 196
How to create and work with data views 198
How to code sort and filter expressions 200
How to work with the rows in a data view 202
The design and property settings for the Invoice Display form 204
The code for the Invoice Display program 206
How to use parameterized queries 208
A Vendor Maintenance form that uses a parameterized query 208
How to create a parameterized query 210
How to work with parameters created by the Configuration Wizard 212
How to create and work with parameters using code 214
The code for the Vendor Maintenance program 216
How to use relationships 224
How to define a relationship 224
How to use a relationship with a data grid 226
How to work with relationships through code 228
An Invoice Display form that uses relationships 230
The code for the Invoice Display program 232
Perspective 234
t


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

Murach's VB.NET Database Programming with ADO.NET

Learn more about this book

Add this book to your cart