Hour 4. Adding Relationships to DataSets

for RuBoard

Hour 4. Adding Relationships to DataSet s

In Hour 2, "Working with DataSets and DataTables," you saw how to use a DataSet to represent your data. You saw how DataTable s 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 DataSet s

• How to use the DataRelation to retrieve data

for RuBoard