How to Access Unfiltered Records

3 Jan 20201 minute to read

This can be done using the following code snippet.

C#

foreach(Record r in this.gridGroupingControl1.Table.Records)
{
    foreach(Record fr in this.gridGroupingControl1.Table.FilteredRecords)
    {
        if(r!=fr)
        {
            Console.WriteLine(r.Info);
        }
    }
}

VB

For Each r As Record In Me.gridGroupingControl1.Table.Records
For Each fr As Record In Me.gridGroupingControl1.Table.FilteredRecords
If Not r Is fr Then
    Console.WriteLine(r.Info)
End If
Next fr
Next r