Permalink
Fetching contributors…
Cannot retrieve contributors at this time
30 lines (26 sloc) 876 Bytes
using System;
using System.Data;
namespace NavigationCS
{
class Program
{
static void Main()
{
DataSet customerOrders = new DataSet();
// <Snippet1>
DataRelation customerOrdersRelation =
customerOrders.Relations.Add("CustOrders",
customerOrders.Tables["Customers"].Columns["CustomerID"],
customerOrders.Tables["Orders"].Columns["CustomerID"]);
foreach (DataRow custRow in customerOrders.Tables["Customers"].Rows)
{
Console.WriteLine(custRow["CustomerID"].ToString());
foreach (DataRow orderRow in custRow.GetChildRows(customerOrdersRelation))
{
Console.WriteLine(orderRow["OrderID"].ToString());
}
}
// </Snippet1>
}
}
}