ChildViews and Relations (ADO.NET)

.NET Framework 4

If a relationship exists between tables in a DataSet¹, you can create a DataView² containing rows from the related child table by using the CreateChildView³ method of the DataRowView⁴ for the rows in the parent table. For example, the following code displays Categories and their related Products in alphabetical order sorted by CategoryName and ProductName.

DataTable catTable = catDS.Tables["Categories"];
DataTable prodTable = catDS.Tables["Products"];

// Create a relation between the Categories and Products tables.
DataRelation relation = catDS.Relations.Add("CatProdRel", 
  catTable.Columns["CategoryID"],
                                                            prodTable.Columns["CategoryID"]);

// Create DataViews for the Categories and Products tables.
DataView catView = new DataView(catTable, "", "CategoryName", 
  DataViewRowState.CurrentRows);
DataView prodView;

// Iterate through the Categories table.
foreach (DataRowView catDRV in catView)
{
  Console.WriteLine(catDRV["CategoryName"]);

  // Create a DataView of the child product records.
  prodView = catDRV.CreateChildView(relation);
  prodView.Sort = "ProductName";

  foreach (DataRowView prodDRV in prodView)
    Console.WriteLine("\t" + prodDRV["ProductName"]);
}

Reference

DataSet¹

DataView²

DataRowView⁴

Other Resources

DataViews (ADO.NET)⁵

ADO.NET Managed Providers and DataSet Developer Center⁶

Links Table

¹http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx

²http://msdn.microsoft.com/en-us/library/system.data.dataview.aspx

³http://msdn.microsoft.com/en-us/library/system.data.datarowview.createchildview.aspx

⁴http://msdn.microsoft.com/en-us/library/system.data.datarowview.aspx

⁵http://msdn.microsoft.com/en-us/library/fdcwwhez.aspx

⁶http://go.microsoft.com/fwlink/?LinkId=217917

Community Content Add

FAQ