DataRow.GetChildRows Method

asp.net.ph

System.Data Namespace DataRow Class

Returns the child rows of a DataRow.

1. Returns the child rows of a DataRow using a specified DataRelation object.

[ VB ] Overloads Public Function GetChildRows ( DataRelation ) As DataRow ( )

[ C# ] public DataRow [ ] GetChildRows ( DataRelation );

[ C++ ] public: DataRow* GetChildRows ( DataRelation* ) [ ];

[ JScript ] public function GetChildRows ( DataRelation ) : DataRow [ ];

2. Returns the child rows of a DataRow using a specified DataRelation name.

[ VB ] Overloads Public Function GetChildRows ( String ) As DataRow ( )

[ C# ] public DataRow [ ] GetChildRows ( string );

[ C++ ] public: DataRow* GetChildRows ( String* ) [ ];

[ JScript ] public function GetChildRows ( String ) : DataRow [ ];

3. Returns a version of the child rows of a DataRow using a specified DataRelation object.

[ VB ] Overloads Public Function GetChildRows ( DataRelation, DataRowVersion ) As DataRow ( )

[ C# ] public DataRow [ ] GetChildRows ( DataRelation, DataRowVersion );

[ C++ ] public: DataRow* GetChildRows ( DataRelation*, DataRowVersion ) [ ];

[ JScript ] public function GetChildRows ( DataRelation, DataRowVersion ) : DataRow [ ];

4. Returns a version of the child rows of a DataRow using a specified DataRelation name.

[ VB ] Overloads Public Function GetChildRows ( String, DataRowVersion ) As DataRow ( )

[ C# ] public DataRow [ ] GetChildRows ( string, DataRowVersion );

[ C++ ] public: DataRow* GetChildRows ( String*, DataRowVersion ) [ ];

[ JScript ] public function GetChildRows ( String, DataRowVersion ) : DataRow [ ];

The following example uses the GetChildRows to return the child DataRow objects from the Products table, for every parent DataRow from the Categories table.

NOTE: This example uses one of the overloaded versions of GetChildRows. For other examples that may be available, see the individual overload topics.

// iterate over parent rows ( Categories )

foreach ( DataRow category in ds.Tables [ 0 ].Rows; ) {
   html += "<br><div class='header' style='color:maroon'><h5>" + 
      category [ "CategoryName" ] + "</h5></div>";

   // begin table headers markup
   html += "<table class='child' width=75% align='center' cellspacing=1>";
   html += "<tr><th>Product Name</th>";
   ...
   // iterate over child rows ( Products )

   foreach ( DataRow product in category.GetChildRows ( "categoryId" ) ) {
      html += "<tr><td>" + product [ "ProductName" ] + "</td>";
      html += "<td>" + product [ "QuantityPerUnit" ] + "</td>";
      html += "<td align='right'>" + String.Format ( "{0:f2}", product [ "UnitPrice" ] ) + "</td>";
      html += "<td align='right'>" + product [ "UnitsInStock" ] + "</td></tr>";
   }
   html += "</table>";
}

' iterate over parent rows ( Categories )
Dim category As DataRow
For Each category In ds.Tables ( 0 ).Rows
   html += "<br><div class='header' style='color:maroon'><h5>" + 
      category ( "CategoryName" ) + "</h5></div>"
   
   ' begin table headers markup
   html += "<table class='child' width=75% align='center' cellspacing=1>"
   html += "<tr><th>Product Name</th>"
   ...
   ' iterate over child rows ( Products )
   Dim product As DataRow
   For Each product In category.GetChildRows ( "categoryId" )
      html += "<tr><td>" + product ( "ProductName" ) + "</td>"
      html += "<td>" + product ( "QuantityPerUnit" ) + "</td>"
      html += "<td align='right'>" + [ string ].Format ( "{0:f2}", product ( "UnitPrice" ) ) + "</td>"
      html += "<td align='right'>" + product ( "UnitsInStock" ) + "</td></tr>"
   Next product
   html += "</table>"
Next category

C#

VB

DataRow Members ChildRelations DataRelation GetParentRows Relations

Suggested Reading

© 2000-2010 Rey Nuñez All rights reserved.

If you have any question, comment or suggestion
about this site, please send us a note

You can help support asp.net.ph