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

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial