How to Insert or Delete rows

Question

How can I insert a row (and have all rows below it shift down automatically) and also delete a row and have all rows below it shift up?
Thanks

Clay Burch · Answer

To remove rows in a GridControl, use the GridControl.Rows.RemoveRange method.

To insert rows into a GridControl, use the GridControl.Rows.InsertRange method.

For a GridDataBoundGrid, the methods are GridDataBoundGrid.Binder.RemoveRecords and GridDataBoundGrid.Binder.AddNew.

Thomas Eyde · Answer

Thank you. But I guess I have to be more precise. How do I invoke the deletion from the GUI? I like to select one or more rows, then press the delete button. But I can't find the proper event.

Administrator · Answer

Try handling the CurrentCellKeyDown event.


Private Sub GridControl1_CurrentCellKeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles GridControl1.CurrentCellKeyDown
        If e.KeyCode = Keys.Delete Then
            Dim range As GridRangeInfo = Me.GridControl1.Selections.Ranges.ActiveRange
            If range.IsRows Then
                Me.GridControl1.Rows.RemoveRange(range.Top, range.Bottom)
                e.Handled = True
            End If
        End If
    End Sub