VB.NET: How to generate Row Numbers in a column in DataGridView?

While filtering or loading data into the DataGridView, we don't have either sno or any row number from the query or the datasource and we want to view the row number to locate the data or to represent the particular row or to view in a regular format.


To get rid of the above problem I did some google and then get to know the event on which the increment can be done for DataGridView and then solved as below


The following code generates a serial number in a separate column in DataGridView:


Private Sub DataGridView1_RowPrePaint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewRowPrePaintEventArgs) Handles DataGridView1.RowPrePaint
        If e.RowIndex >= 0 Then
            Me.DataGridView1.Rows(e.RowIndex).Cells(0).Value = e.RowIndex + 1
        End If
    End Sub