How to disable or hide button in datagridview

See more:

VB

MySQL

DataGridView

XAMPP

Hi I want to Hide or Disable the button in my 3rd column which I intend to add row every time I click it. The mess is, the previous buttons are active and can add row. How can I place the button only in the last row?


Can anyone help me about this? TIA.

What I have tried:

Private Sub dgAppliances_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgAppliances.CellContentClick

    If e.ColumnIndex <> 2 Then
        Exit Sub
    Else
        If Me.dgAppliances.RowCount = 20 Then
            MsgBox("Maximum of 20 appliances only.")
        Else
            dgvAppsRowNo += 1
            Me.dgAppliances.Rows.Add()
            Me.dgAppliances.Rows(dgvAppsRowNo).Cells(0).Value = dgvAppsRowNo + 1

            Dim cell As DataGridViewButtonCell = dgAppliances.Rows(dgvAppsRowNo).Cells(2)
            cell.Value = New DataGridTextBoxColumn()
            cell.ReadOnly = True
        End If
    End If

End Sub