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

This chapter teaches you how to create a dataset schema using the XML Designer, the collection editors, or code, instead of generating it from a data adapter.

Chapter 9 How to work with dataset schemas
How dataset schemas work 272
Properties that specify the schema of a dataset 272
How to create a dataset schema 272
How to use the XML Designer 274
An introduction to the XML Designer 274
How to create tables and columns 276
How to create a unique constraint 278
How to create a relation 280
How the referential integrity rules affect database operations 282
How to create an instance of a custom typed dataset 284
A Vendor Display form that uses a custom typed dataset 286
The code for the Vendor Display program 288
How to use the collection editors 290
How to create an instance of an untyped dataset component 290
How to use the Tables Collection Editor 290
How to use the Columns Collection Editor 292
How to use the Constraints Collection Editor 294
How to use the Relations Collection Editor 296
A Vendor Display program that uses an untyped dataset component 298
How to define the schema for a dataset through code 300
How to create tables through code 300
How to create columns through code 302
How to create unique constraints through code 304
How to create foreign key constraints through code 306
How to create data relations through code 308
A Vendor Display program that uses an untyped dataset created through code 310
Perspective 314
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