How to get related data to records displayed in a DataGridView in VB

Question

How to get related data to records displayed in a DataGridView in VB

Giovanni Conte 66

I Have a DataGridView connected to a db table. I click on each row of the grid and the Cell_Click Event shows the related data of another table in a TextBox. Clicking on the BindingNavigator MoveNext button and invoking Cell_Click, I don't see the correct data in the TextBox but see the data of the previous record (that was the current just before). Only clicking once more on the MoveNext button I can see the desired data, always relative to the previos record. One upon a time, in VB6, the event RowChange overcame the issue but now, the events Leave, RowLeave, RowEnter don't immediately make the row I'm moving to, the current row. I hope I was clear. I could skip a record to solve the issue but it's not very elegant. Can someone help me?

KOZ6.0 6,735

Are you talking about VB.NET? If you use the DataBindings property, record movement will be done automatically.

Public Class Form1

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Dim dt As New DataTable
        With dt.Columns
            .Add("Column1")
            .Add("Column2")
        End With
        With dt.Rows
            .Add("1111111111", "AAAAAAAAAA")
            .Add("2222222222", "BBBBBBBBBB")
            .Add("3333333333", "CCCCCCCCCC")
        End With
        BindingSource1.DataSource = dt
        BindingNavigator1.BindingSource = BindingSource1
        DataGridView1.DataSource = BindingSource1
        TextBox1.DataBindings.Add("Text", BindingSource1, "Column1")
        TextBox2.DataBindings.Add("Text", BindingSource1, "Column2")
    End Sub

End Class

Giovanni Conte 66 Reputation points

2023-11-14T12:50:55.5+00:00

Thank you K..., of course: the record movement is done automatically, but always pointing to the previous record, because the DataGrid events don't point immediatly to the new record. However the problem has been solved by Jiachen Li. Thank tou again!

Accepted answer

0 additional answers

Your answer

KOZ6.0 6,735 Reputation points

2023-11-14T02:51:34.0566667+00:00

Are you talking about VB.NET? If you use the DataBindings property, record movement will be done automatically.

Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim dt As New DataTable With dt.Columns .Add("Column1") .Add("Column2") End With With dt.Rows .Add("1111111111", "AAAAAAAAAA") .Add("2222222222", "BBBBBBBBBB") .Add("3333333333", "CCCCCCCCCC") End With BindingSource1.DataSource = dt BindingNavigator1.BindingSource = BindingSource1 DataGridView1.DataSource = BindingSource1 TextBox1.DataBindings.Add("Text", BindingSource1, "Column1") TextBox2.DataBindings.Add("Text", BindingSource1, "Column2") End Sub End Class
Giovanni Conte 66 Reputation points

2023-11-14T12:50:55.5+00:00

Thank you K..., of course: the record movement is done automatically, but always pointing to the previous record, because the DataGrid events don't point immediatly to the new record. However the problem has been solved by Jiachen Li. Thank tou again!

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @Giovanni Conte ,

Perhaps you can try using the DataGridView.SelectionChanged Event to implement the RowChange event in VB6.

Private Sub DataGridView1_SelectionChanged(sender As Object, e As EventArgs) Handles DataGridView1.SelectionChanged
    If DataGridView1.SelectedRows.Count > 0 Then
        Dim selectedRow As DataGridViewRow = DataGridView1.SelectedRows(0)
        Dim rowIndex As Integer = selectedRow.Index
        'Take further action
    End If
End Sub

Best Regards.

Jiachen Li

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Giovanni Conte 66 Reputation points

2023-11-14T12:48:19.9833333+00:00

Magic! I didn't try the SelectionChanged event (don't know why). This event make immediately the pointed row as the current record and the issue is solved. Thank you Jiachen Li!

Share via

How to get related data to records displayed in a DataGridView in VB

0 additional answers

Your answer