ADO.NET 3.5 Cookbook, 2nd Edition

3.8. Working with Parent-Child Relations in a Strongly Typed DataSet

Problem

You have retrieved data into related tables in a strongly typed DataSet and you need to navigate the hierarchy and retrieve data values.

Solution

The solution shows how to work with related data tables in a strongly typed DataSet.

Follow these steps:

1. Create a new C# Windows Console application, and name it AccessValuesStronglyTypedDataSet.

2. The solution needs the strongly typed DataSet class file AdventureWorks.cs created in the second half of Recipe 2.16. Copy this file to the project folder—the folder that contains the file AccessValuesStronglyTypedDataSet.csproj.

3. Add the strongly typed DataSet class to the project. Right-click on the project in Solution Explorer. Select Add → Existing Item to open the Add Existing Item dialog. Select the AdventureWorks.cs file and click Add. You can now use the strongly typed DataSet AdventureWorks in your project.

   The C# code in Program.cs in the project DataRelationStronglyTypedDataSet is shown in Example 3-11.

Example 3-11. File: Program.cs for DataRelationStronglyTypedDataSet solution

using System;
using System.Data;
using System.Data.SqlClient;

namespace Data RelationStronglyTypedDataSet { class Program { static void Main(string[] args) { string sqlConnectString = "Data Source=(local);" + "Integrated security=SSPI;Initial Catalog=AdventureWorks;"; string sqlSelect = "SELECT * FROM Sales.SalesOrderHeader;" + "SELECT * FROM Sales.SalesOrderDetail;"; AdventureWorks awds = new ...