Viewing blogs posted in April, 2005

Thursday, April 07, 2005

ADO.NET Strongly Typed Relationships

1. Right-click your Project in the Solution Explorer and select Add > Add New Item...
2. Select "Data Set" from the Templates list, and type the name for your item (CustomersDataSet.cs).
3. In the Server Explorer, navigate to the Northwind database tables. Drag across the Customers and Orders tables.
4. Select the Customers table and select Schema > Add > New Relation... from the File Menu.
5. This is where your relationship is defined. Change the name to CustomersOrders, and change the Child element to Orders. Clicking OK will then create the relationship for you.

DataSet1.Tables["Customers"].Rows[0]

DataSet1.Customers[0]

CustomersDataSet.CustomerDataRow customer
    = myDataSet.Customers.FindCustomerByID(1);
if (customer != null)
{
  // Print out order numbers
  foreach (DataRow orderRow in
    customer.GetChildRows("CustomerOrders"))
  {
    Console.WriteLine(orderRow["OrderID"]);
  }
}

CustomersDataSet.CustomerDataRow customer
    = myDataSet.Customers.FindCustomerByID(1);
if (customer != null)
{
  // Print out order numbers
  foreach (CustomersDataSet.OrderRow orderRow
    in customer.GetOrdersRows())
  {
    Console.WriteLine(orderRow.OrderID);
  }
}