How to Access Corresponding Parent Table’s Row from the Child

9 Dec 20194 minutes to read

Get the table’s current element. Then cast this element to GridNestedTable. You can now access the parent table for the current element. This is a recursive process.

Example

C#

Element el = this.gridGroupingControl1.TableControl.Table.CurrentElement;
if(el != null)
{
    if(el is GridRecord)
    {
        Console.WriteLine("no parent row...");
    }
	//Checks for a child table.
    else if(el is GridNestedTable)
    {
        GridNestedTable gridNestedTable = el as GridNestedTable;
        GridNestedTable gnt1 = gridNestedTable;
        while(gnt1 != null && gnt1.ChildTable != null)
        {
             gridNestedTable = gnt1;
			//Gets the handle for parent table.
             gnt1 = gridNestedTable.ChildTable.ParentTable.CurrentElement as GridNestedTable;
        }
		//Retrieves the corresponding parent table's record.
        DataRowView dataRowView = gridNestedTable.ParentRecord.GetData() as DataRowView;
		//Shows column 2.
        Console.WriteLine(dataRowView[1].ToString()); 
    }
}

VB.NET

Dim el As Element = Me.GridGroupingControl1.TableControl.Table.CurrentElement
If Not (el Is Nothing) Then
    If TypeOf el Is GridRecord Then
        Console.WriteLine("no parent row...")
    Else
	'Checks for a child table.
        If TypeOf el Is GridNestedTable Then
		Dim gridNestedTable As GridNestedTable = el
            Dim gnt1 As GridNestedTable
            If TypeOf gridNestedTable Is GridNestedTable Then
                gnt1 = gridNestedTable
            Else
                gnt1 = Nothing
            End If
            While Not (gnt1 Is Nothing) AndAlso Not (gnt1.ChildTable Is Nothing)
                gridNestedTable = gnt1
                If TypeOf gridNestedTable.ChildTable.ParentTable.CurrentElement Is GridNestedTable Then
				'Gets the handle for parent table.
                    gnt1 = gridNestedTable.ChildTable.ParentTable.CurrentElement
                Else
                    gnt1 = Nothing
                End If
            End While
			'Retrieves the corresponding parent table's record.
            Dim dataRowView As DataRowView = gridNestedTable.ParentRecord.GetData()
			'Shows column 2.
            Console.WriteLine(dataRowView(1).ToString())
        End If
    End If
End If