Vb.net – Selecting single cell data from selected row – DataGridView

vb.net

I have a datagridview with data in it, I have set it so you can only select the row and one at a time.

However, I need to get the data from one of the cells in the selected row, I have tried this;

Dim data As String = DataGridView1.SelectedRows.Cells(5).toString

Something like that, but I can't get the value of it, does anyone know the way to do it?

Best Answer

Perhaps the right syntax is:

Dim data As String = DataGridView1.SelectedRows(0).Cells(5).Value.ToString

See MSDN docs

Related Solutions

Remember selected row in DataGridView

I'm doing something similar, but not using a grid event to determine when to refresh. I call my refresh routine after they're done editing in the edit form.

The problem with using the grid row number is it could have changed after or during the edit, especially if you're supporting multiple users and your grid is a view of a table on a server, or if they can sort the grid rows.

I have to use the row's PK value(s) to identify the changed row, and considering they could change one of the pk values during the edit, I need to keep track of the updated PK value as well.

I raise my own event when they update a value.

Vb.net – how to get data from selected row from datagridview

To get the cell value, you need to read it directly from DataGridView1 using e.RowIndex and e.ColumnIndex properties.

Eg:

Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
   Dim value As Object = DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value

   If IsDBNull(value) Then 
      TextBox1.Text = "" ' blank if dbnull values
   Else
      TextBox1.Text = CType(value, String)
   End If
End Sub

Best Answer

Related Solutions

Remember selected row in DataGridView

Vb.net – how to get data from selected row from datagridview

Related Topic