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

18 Nov 20184 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