Export Summary as Caption in Windows Forms GridGrouping (GridGroupingControl)

28 Apr 20212 minutes to read

This feature enables you to export the summary as caption while exporting GridGroupingControl to Excel.

PROPERTY DESCRIPTION TYPE DATA TYPE REFERENCE LINKS
ExportCaptionSummary This property exports summary as caption. GridGroupingControl Boolean NA

Exporting Summary as Caption

You can export summary as caption using ExportCaptionSummary property. The following code illustrates this:

converter.ExportCaptionSummary = true;

Export-Summary-as-Caption_images1

Searching for text in multiple columns

This feature can be used to perform searches either in specified columns or in all the grid columns. Only the rows containing search text will be filtered and displayed.

Searches can be performed in two modes:

1.Search for text in all columns.

2.Search for text in particular columns.

METHOD PROTOTYPES DESCRIPTION
Search() this.gridGroupingControl1.TableDescriptor.Search("SearchText", List[GridColumnDescriptor]); It is called for performing search operation in the columns.
this.gridGroupingControl1.TableDescriptor.Search("SearchText");

Searching for text in all columns

Here, text is provided as a parameter in the Search method in TableDescriptor. It searches for the text in all the columns and displays the rows that contain the word.

The following code sample illustrates how to perform the search operation:

this.gridGroupingControl1.TableDescriptor.Search("Duke");
 Me.gridGroupingControl1.TableDescriptor.Search("Duke");

Searching for text in particular columns

We can perform this operation by passing columns that need to be searched into the Search() method. In this case, we need to create a list that will hold columns that need to be searched for that particular text. The search text and the list of columns that will be searched are passed as parameters for performing the operation. The following code illustrates this:

List<GridColumnDescriptor> list= new List<GridColumnDescriptor>();
list.Add(this.gridGroupingControl1.TableDescriptor.Columns[1]);
list.Add(this.gridGroupingControl1.TableDescriptor.Columns[3]);
this.gridGroupingControl1.TableDescriptor.Search("Duke", list);
Dim list As New List(Of GridColumnDescriptor)()
list.Add(Me.gridGroupingControl1.TableDescriptor.Columns(1))
list.Add(Me.gridGroupingControl1.TableDescriptor.Columns(3))
Me.gridGroupingControl1.TableDescriptor.Search("Duke", list)