Change grouping

[Tomio]

Hi, How do I block a group of two columns, if you have a column grouped and the user from any other group in place.

"to put the grid outar remove the column that was already in the group" gridGroupingControl in VB.NET?

Follows as an attachment I want.

Thanks



What I want and I do not want_aaa4b968.zip

[Jisha Joy]

Hi,

You can achieve the desired behavior by handling the TableControlQueryAllowGroupByColumn event. It Occurs when the user drags a column header over the GroupDropArea. In your event handler, you can determine if the grid can be grouped by the selected column.

Regards,
Jisha

[Tomio]

Good afternoon.
Thanks for the help, but I've already.
The code is as follows:

Private Sub gridGrouping_TableControlQueryAllowGroupByColumn(ByVal sender As System.Object, ByVal e As Syncfusion.Windows.Forms.Grid.Grouping.GridQueryAllowGroupByColumnEventArgs) Handles gridGrouping.TableControlQueryAllowGroupByColumn

e.AllowGroupByColumn = False

If e.Reason = GridQueryAllowDragColumnReason.MouseUp Then

gridGrouping.TableDescriptor.GroupedColumns.Clear()

gridGrouping.TableDescriptor.GroupedColumns.Add(e.Column)

End If

End Sub

Regards,
Tomio

[Arulraj A]

Hi Tomio,

Thanks for the update

You can achieve the required behaviour by clearing the grouped columns collection in TableControlQueryAllowGroupByColumn event. The following code explains the same.

Private Sub gridGrouping_TableControlQueryAllowGroupByColumn(ByVal sender As System.Object, ByVal e As Syncfusion.Windows.Forms.Grid.Grouping.GridQueryAllowGroupByColumnEventArgs) Handles gridGrouping.TableControlQueryAllowGroupByColumn

Me.gridGroupingControl1.TableDescriptor.GroupedColumns.Clear()
            
End Sub

Regards,
Arulraj.A