DataGridViewRowCollection.AddRange Method

Adds the specified DataGridViewRow objects to the collection.

Namespace:  System.Windows.Forms
Assembly:  System.Windows.Forms (in System.Windows.Forms.dll)

Public Overridable Sub AddRange ( _
	ParamArray dataGridViewRows As DataGridViewRow() _


Type: System.Windows.Forms.DataGridViewRow()

An array of DataGridViewRow objects to be added to the DataGridViewRowCollection.


dataGridViewRows is Nothing.


dataGridViewRows contains only one row, and the row it contains has more cells than there are columns in the control.


The associated DataGridView control is performing one of the following actions that temporarily prevents new rows from being added:

  • Selecting all cells in the control.

  • Clearing the selection.


This method is being called from a handler for one of the following DataGridView events:


The DataSource property of the DataGridView is not Nothing.


At least one entry in the dataGridViewRows array is Nothing.


The DataGridView has no columns.


At least one row in the dataGridViewRows array has a DataGridView property value that is not Nothing.


At least one row in the dataGridViewRows array has a Selected property value of true.


Two or more rows in the dataGridViewRows array are identical.


At least one row in the dataGridViewRows array contains one or more cells of a type that is incompatible with the type of the corresponding column in the control.


At least one row in the dataGridViewRows array contains more cells than there are columns in the control.


This operation would add frozen rows after unfrozen rows.

The AddRange method adds shared rows to the DataGridViewRowCollection, if possible. Otherwise, the new rows are unshared. For more information, see Best Practices for Scaling the Windows Forms DataGridView Control.

Rows in the control are not automatically sorted when new rows are added. To sort new rows into their correct position, call the DataGridView.Sort method in a DataGridView.RowsAdded event handler. You might also want to call the DataGridView.Sort method in a CellValueChanged event handler to sort the rows when the user modifies a cell.

Important noteImportant

Due to a bug, the AddRange method will make your application stop responding if the AllowUserToAddRows property is true and the row for new records is selected. To work around this bug, you must cancel the selection of the row before calling this method, and then reselect the row. For more information, see the code example in this topic.

The following code example demonstrates how to use the AddRange method when the row for new records is selected to work around the bug indicated in the Remarks section.

' Workaround for bug that prevents DataGridViewRowCollection.AddRange 
' from working when the row for new records is selected.  
Private Sub AddRows(ByVal ParamArray rows As DataGridViewRow())
    InsertRows(dataGridView1.RowCount - 1, rows)
End Sub 

' Workaround for bug that prevents DataGridViewRowCollection.InsertRange 
' from working when any rows before the insertion index are selected. 
Private Sub InsertRows(ByVal index As Integer, _
    ByVal ParamArray rows As DataGridViewRow())

    Dim selectedIndexes As New System.Collections.Generic.List(Of Integer)

    For Each row As DataGridViewRow In dataGridView1.SelectedRows
        If row.Index >= index Then
            row.Selected = False 
        End If 
    Next row

    dataGridView1.Rows.InsertRange(index, rows)

    For Each selectedIndex As Integer In selectedIndexes
        dataGridView1.Rows(selectedIndex).Selected = True 
    Next selectedIndex

End Sub

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2014 Microsoft