We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How can I merge column Headers ?

Platform: WinForms |
Control: GridDataBoundGrid(Classic) |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

We can use CoveredRanges property to merge two or more columns.

C#

this.gridDataBoundGrid1.Model.CoveredRanges.Add(GridRangeInfo.Cells(0,3,0,4));

Private void gridDataBoundGrid1_CellClick(object sender, GridCellClickEventArgs e)

{

if (e.RowIndex == 0 && e.ColIndex > 0)

{

GridRangeInfo range;

bool check = this.gridDataBoundGrid1.Model.CoveredRanges.Find(e.RowIndex, e.ColIndex, out range);

if (check)

this.gridDataBoundGrid1.Model.Selections.Add(GridRangeInfo.Cols(range.Left, range.Right));

}

}

// On Mouse down, select both the column which is merged.

Private void gridDataBoundGrid1_MouseDown(object sender, MouseEventArgs e)

{

int row, col;

this.gridDataBoundGrid1.PointToRowCol(new Point(e.X, e.Y), out row, out col);

if (row == 0 && col > 0)

{

GridRangeInfo range;

bool check = this.gridDataBoundGrid1.Model.CoveredRanges.Find(row, col, out range);

if (check)

this.gridDataBoundGrid1.Model.Selections.Add(GridRangeInfo.Cols(range.Left, range.Right));

}

}

 

VB

Me.gridDataBoundGrid1.Model.CoveredRanges.Add(GridRangeInfo.Cells(0,3,0,4));

Private Sub GridDataBoundGrid1_CellClick(ByVal sender As System.Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridCellClickEventArgs) Handles GridDataBoundGrid1.CellClick

If e.RowIndex = 0 AndAlso e.ColIndex > 0 Then

Dim range As GridRangeInfo

Dim check As Boolean = Me.gridDataBoundGrid1.Model.CoveredRanges.Find(e.RowIndex, e.ColIndex, range)

If check Then

Me.gridDataBoundGrid1.Model.Selections.Add(GridRangeInfo.Cols(range.Left, range.Right))

End If

End If

'' On Mouse down, select both the column which is merged.

Private Sub GridDataBoundGrid1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles GridDataBoundGrid1.MouseDown

Dim row, col As Integer

Me.gridDataBoundGrid1.PointToRowCol(New Point(e.X, e.Y), row, col)

If row = 0 AndAlso col > 0 Then

Dim range As GridRangeInfo

Dim check As Boolean = Me.gridDataBoundGrid1.Model.CoveredRanges.Find(row, col, range)

If check Then

Me.gridDataBoundGrid1.Model.Selections.Add(GridRangeInfo.Cols(range.Left, range.Right))

End If

End If

Here is the sample link :

http://websamples.syncfusion.com/samples/KB/KB_ColumnMerge/main.htm.

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon