Datagrid to Textbox

[riechan]

Is it possible to transfer the contents of a row in a datagrid to a textbox? (Like, when I click row 3, the contents of that row will be transferred to the textboxes) If it is, can anyone guide me to a tutorial? Or is this technique applicable only to the ListView object?

[jmcilhinney]

Text is text. It doesn't matter where it comes from. You can get text from any control and display it in another control.

That said, displaying data in both a DataGridView and TextBoxes is easier than it is a ListView and TextBoxes because the ListView doesn't support data-binding. With a ListView you would have to copy the data manually. With a DataGridView you simply bind the same data to both the grid and the TextBoxes and everything else happens automatically, e.g.

myBindingSource.DataSource = myDataTable
 
myDataGridView.DataSource = myBindingSource
 
firstNameTextBox.DataBindings.Add("Text", myBindingSource, "FirstName")
lastNameTextBox.DataBindings.Add("Text", myBindingSource, "LastName")

[riechan]

I'm a bit lost. If let's say my datasource is the datagrid itself, which, when the form loads, is filled by data from the database, would this code:

      myBindingSource.DataSource = myDataTable
      myDataGridView.DataSource = myBindingSource
      firstNameTextBox.DataBindings.Add("Text", myBindingSource, "FirstName")
      lastNameTextBox.DataBindings.Add("Text", myBindingSource, "LastName")

be something like this (this is how I filled the datagrid with data):

dgBook.DataSource = dbDsetTransact
dgBook.DataMember = "Book"

[riechan]

Um, I'm sort of looking for something like this:

http://www.vbforums.com/showthread.php?t=493902

The thing is, the code that was posted in that thread has some problems in it.

eg:

       txtTitle.Text = dgBook.Item(1, e.RowIndex).Value

Only transfers the contents of the currently selected row of the dgBook when I click on the 2nd column. Does it have something to do with the event arguments?

Private Sub dgBook_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgBook.CellContentClick

[jmcilhinney]

This:

dgBook.DataSource = dbDsetTransact
dgBook.DataMember = "Book"

is functionally equivalent to this:

dgBook.DataSource = dbDsetTransact.Tables("Book")

which is functionally equivalent to this:

Dim myDataTable As DataTable = dbDsetTransact.Tables("Book")
dgBook.DataSource = myDataTable

My original code puts a BindingSource in there too. No big deal.