IndexOutOfRangeException error when DataGridView header is clicked

Question

Iam trying to get DataGridView rowIndex and set it to textbox and all is well with this code

Private Sub dgv_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgv.CellContentClick
    isitxt(e.RowIndex)
    btnInsert.Enabled = False
    btnUpdate.Enabled = True
    btnDelete.Enabled = True
End Sub

and

Sub isitxt(ByVal x As Integer)
    txtIDBarang.Text = dgv.Rows(x).Cells(0).Value
    txtNamaBarang.Text = dgv.Rows(x).Cells(1).Value
    cbJenisBarang.Text = dgv.Rows(x).Cells(2).Value
    numHargaBeli.Value = dgv.Rows(x).Cells(3).Value
    numHargaJual.Value = dgv.Rows(x).Cells(4).Value
End Sub

But i got IndexOutOfRangeException when i clicked on Column Header. how can i handle it ?

Use a try/catch/finally block or test x to see if it's a valid row index — SierraOscar
– SierraOscar, Commented Jan 26, 2016 at 15:00

LarsTech · Accepted Answer · 2016-01-27 02:38:01Z

1

Note, that if you use CellContentClick, the code will be executed only if the user actually aims at text content of a cell. Usually a CellClick is makes more sense.

As for your code, you can debug and see, what's in "x", when you get an error - I guess "-1"... You can handle it then. However, the reason for this should not be in your code above.

You can also set SelectionMode = FullRowSelect and do it following way:

Private Sub dgv_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgv.CellClick
  isitxt(Me.dgv.selectedRows(0).index)
  btnInsert.Enabled = False
  btnUpdate.Enabled = True
  btnDelete.Enabled = True
End Sub

Unless you want to handle the cells separately, users usually prefer the FullRowSelect mode.

edited Jan 27, 2016 at 2:38

LarsTech

81.9k14 gold badges161 silver badges237 bronze badges

answered Jan 26, 2016 at 21:52

Oak_3260548

2,0303 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Holger Just · Accepted Answer · 2023-10-25 19:01:50Z

0

You can use On error resume next like this :

Private Sub dgv_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgv.CellContentClick
  on error resume next
  isitxt(e.RowIndex)
  btnInsert.Enabled = False
  btnUpdate.Enabled = True
  btnDelete.Enabled = True
End Sub

edited Oct 25, 2023 at 19:01

Holger Just

56.5k15 gold badges124 silver badges137 bronze badges

answered Oct 18, 2023 at 2:47

King Of Hydra

1

Collectives™ on Stack Overflow

IndexOutOfRangeException error when DataGridView header is clicked

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related