From this thread I kind of get the idea of how to fill textboxes with records from a row by clicking on the datagridview but I have not quite got it right in practice.

My Code:
VB Code:
  1. Private Sub frmEdit_Load( _
  2.         ByVal sender As Object, _
  3.         ByVal e As System.EventArgs) Handles Me.Load
  4.  
  5.         Dim da As SqlDataAdapter
  6.         Dim ds As DataSet = New DataSet
  7.         da = New SqlDataAdapter("Select * " & _
  8.            "From vShowEditData Where StoreID = '" & _
  9.            StoreID & "' Order by CategoryCode, ItemCode", Con)
  10.         da.TableMappings.Add("Table", "EditInv")
  11.         Try
  12.             da.Fill(ds)
  13.             ds.Tables("EditInv").DefaultView.AllowNew = False
  14.             dgvEditData.DataSource = ds.Tables("EditInv")
  15.             myBindingSource.DataSource = ds.Tables("EditInv")
  16.         Catch ex As Exception
  17.             MessageBox.Show( _
  18.                 ex.Message & vbNewLine & _
  19.                 ex.Source, "Data Error", _
  20.                 MessageBoxButtons.OK)
  21.         Finally
  22.             da.Dispose()
  23.             ds.Dispose()
  24.         End Try
  25.     End Sub
  26.  
  27.     Private Sub dgvEditData_RowHeaderMouseDoubleClick( _
  28.         ByVal sender As Object, _
  29.         ByVal e As System.Windows.Forms.DataGridViewCellMouseEventArgs) _
  30.         Handles dgvEditData.RowHeaderMouseDoubleClick
  31.  
  32.         tbStart.DataBindings.Add("Text", myBindingSource, "OnHandQ")
  33.     End Sub
On the first dbl Click it sets it to 0 every time and on the second dbl Click I get this error: This causes two bindings in the collection to bind to the same property. Parameter name: binding