Name

GetParentRows

Synopsis

DataRow[] parentRows = DataRow.GetParentRows(DataRelation dr);

DataRow[] parentRows = DataRow.GetParentRows(String relationName);

DataRow[] parentRows = DataRow.GetParentRows(DataRelation,

    DataRowVersion drv);

DataRow[] parentRows = DataRow.GetParentRows(String relationName,

    DataRowVersion drv);

Gets an array of DataRow objects that are the parent rows of the current row, based on a DataRelation.

Parameters

parentRows

Returns an array of DataRow objects.

dr

The DataRelation to use when retrieving the parent row.

relationName

The name of the DataRelation to use when retrieving the parent row.

drv

One of the DataRowVersion enumeration values described in Table 25-5 in the next section.

Example

The following example uses the GetParentRow( ) method to retrieve the Cocktails in which each Ingredient is used:

// iterate through all of the Ingredient rows

foreach(DataRow rowIngredient in ds.Tables["Ingredient"].Rows)

{

    // iterate through the Cocktail rows for the specified Ingredient

    foreach(DataRow rowCocktail in rowIngredient.GetParentRows(

        "Cocktail_Ingredient"))

    {

        // ... code to process the Cocktail row

    }

}

Note

Although the GetParentRows( ) returns the parent rows for a child row using many-to-many relationships, there is little RDBMS support for many-to-many relationships.