Export Summary as Caption in Windows Forms GridGrouping

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:

C#

converter.ExportCaptionSummary = true;

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:

C#

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

VBNET

 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:

C#

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);

VBNET

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)