O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hour 4. Adding Relationships to DataSets

In Hour 2, “Working with DataSets and DataTables,” you saw how to use a DataSet to represent your data. You saw how DataTables are analogous to tables in a database. In the last hour, you saw how to use the four major SQL query commands to work with data in a database.

This hour extends the concepts in both Hour 2 and Hour 3 by first discussing database relationships, and then by showing how to create these relationships in a DataSet.

In this hour, you'll learn

  • What a database relationship is

  • How to use a database relationship

  • How to use the Join operator

  • How to use the DataSet Relations collection to add a relationship between two DataSets

  • How to use the DataRelation to retrieve data

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required