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.

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